N

N variable in SQLDA

how value is set, PC_ 15-7

purpose of, PC_ 15-7

name attribute, server resource, LEG 2-26

NAME column

SYS.INCEXP table, SUT 1-52

Name must be specified - error, ADQ D-6

name registration, DCI 2-10

name resolution, ADG 2-38, LEG B-9, PLS 2-37, PLS D-1

distributed databases, DDS 1-22

impact of global name changes, DDS 1-42

schema objects, DDS 1-38

when global database name is complete, DDS 1-37

when global database name is partial, DDS 1-37

when no global database name is specified, DDS 1-37

in distributed databases, SCN 392

name resolution for procedures, SCN 62

name translation

for RMAN commands, RMN 1-7

Name, Object, ADQ 2-2

NAMED clause

of CREATE JAVA, SQL 7-313

named datatypes

binding, OCI 5-10, OCI 12-2

binding and defining, OCI 12-6

defining, OCI 5-21, OCI 12-4

definition, OCI 3-18

external datatypes, OCI 3-18

indicator variable for, OCI 2-32

indicator variables, OCI 2-33

named notation, PLS 7-13

Named Pipes protocol

described, NET 4-3

parameters for addresses, NET B-3

PIPE parameter, NET B-3

SERVER parameter, NET B-3

named user licensing, SCN 300

named user limits, SAD 22-5

setting initially, SAD 2-24

names

cursor, PLS 5-7

qualified, PLS 2-36

savepoint, PLS 5-45

variable, PLS 2-37

Names Wizard, NET 6-51, NET 6-55

names, LSM administrators, LEG 2-28

names, of object classes, OID 6-7

NAMES_DID table, MIG F-18

NAMES_DOM table for Oracle Names, MIG F-18

NAMES.ADDRESSES parameter, NET 6-52, NET 6-56, NET C-59

NAMES.ADMIN_REGION parameter, MIG F-19, MIG F-20, NET 6-52, NET C-59

NAMES.AUTHORITY_REQUIRED parameter, NET C-60

NAMES.AUTO_REFRESH_EXPIRE parameter, NET C-60

NAMES.AUTO_REFRESH_RETRY parameter, NET C-60

NAMES.CACHE_CHECKPOINT_FILE parameter, NET C-61

NAMES.CACHE_CHECKPOINT_INTERVAL parameter, NET C-61

NAMES.CONFIG_CHECKPOINT_FILE parameter, NET C-61

NAMES.CONNECT_TIMEOUT parameter, NET C-62

NAMESCTL utility, NET A-26

command reference, NET A-28 to NET A-79

commands

DELEGATE_DOMAIN, NET A-28

DOMAIN_HINT, NET A-29

DUMP_LDAP, NET A-30

DUMP_TNSNAMES, NET A-33

EXIT, NET A-34

FLUSH, NET A-34

FLUSH_NAME, NET A-35

HELP, NET A-36

LIST_DELEGATED, NET A-37

LIST_DOMAINS, NET A-37

LIST_OBJECTS, NET A-38

LOAD_TNSNAMES, NET A-39

LOG_STATS, NET A-40

PASSWORD, NET A-40

PING, NET A-41

QUERY, NET 11-14, NET A-42

QUIT, NET A-44

REGISTER, NET A-44

RELOAD, NET A-45

REORDER_NS, NET A-46

REPEAT, NET A-47

RESET_STATS, NET A-48

RESTART, NET A-48

SET, NET A-26, NET A-49

SET CACHE_CHECKPOINT_INTERVAL, NET A-50

SET DEFAULT_DOMAIN, NET A-51

SET FORWARDING_AVAILABLE, NET A-51

SET LOG_FILE_NAME, NET A-52

SET LOG_STATS_INTERVAL, NET A-53

SET NAMESCTL_TRACE_LEVEL, NET A-54

SET PASSWORD, NET A-55

SET REQUESTS_ENABLED, NET A-56

SET RESET_STATS_INTERVAL, NET A-56

SET SAVE_CONFIG_INTERVAL, NET A-57

SET SAVE_CONFIG_ON_STOP, NET A-58

SET SERVER, NET A-59

SET TRACE_FILE_NAME, NET A-60

SET TRACE_LEVEL, NET A-60

SHOW, NET A-26, NET A-61

SHOW CACHE CHECKPOINT_INTERVAL, NET A-62

SHOW DEFAULT_DOMAIN, NET A-63

SHOW FORWARDING_AVAILABLE, NET A-64

SHOW LOG_FILE_NAME, NET A-65

SHOW LOG_STATS_INTERVALE, NET A-65

SHOW NAMESCTL_TRACE_LEVEL, NET A-66

SHOW REQUEST_ENABLED, NET A-67

SHOW RESETS_STATS_INTERVAL, NET A-67

SHOW SAVE_CONFIG_INTERVAL, NET A-68

SHOW SAVE_CONFIG_ON_STOP, NET A-68

SHOW SERVER, NET A-69

SHOW STATS, NET A-69

SHOW SYSTEM_QUERIES, NET A-70

SHOW TRACE_FILE_NAME, NET A-70

SHOW TRACE_LEVEL, NET A-71

SHOW VERSION, NET A-72

SHUTDOWN, NET A-72

START, NET A-73

START_CLIENT_CACHE, NET 11-6, NET A-75

STARTUP, NET A-75

STATUS, NET A-76

STOP, NET A-76

TIMED_QUERY, NET A-77

UNREGISTER, NET A-78

VERSION, NET A-79

confirmation mode, NET A-27

delegating domains, NET 6-73

described, NET 4-30

discovering Oracle Names servers, NET 6-59, NET 6-61

distributed operation, NET A-27

function of and syntax format

global database links, NET 6-69

loading tnsnames.ora file into Oracle Names, NET 6-67

modes of operation, NET A-2

net service names, NET 6-66

querying objects, NET 11-14

starting an Oracle Names server, NET 11-5

testing network objects with, NET 11-14

testing the network, NET 11-3

NAMESCTL.INTERNAL_ENCRYPT_PASSWORD parameter, NET C-10

NAMESCTL.INTERNAL_USE parameter, NET C-11

NAMESCTL.NO_INITIAL_SERVER parameter, NET C-11

NAMESCTL.NOCONFIRM parameter, NET C-11

NAMESCTL.SERVER_PASSWORD parameter, NET C-11

NAMESCTL.TRACE_DIRECTORY parameter, NET C-12

NAMESCTL.TRACE_FILE parameter, NET C-12

NAMESCTL.TRACE_LEVEL parameter, NET C-12

NAMESCTL.TRACE_UNIQUE parameter, NET C-12

NAMES.DCE.PREFIX parameter, NET C-7

NAMES.DEFAULT_DOMAIN parameter, MIG F-4, NET 6-7, NET 6-63, NET 8-18

NAMES.DEFAULT_FORWARDERS parameter, NET C-62

NAMES.DEFAULT_FORWARDERS_ONLY parameter, NET C-62

NAMES.DEFAULT_ZONE parameter, MIG F-4

NAMES.DEFAULT.DOMAIN parameter, NET C-8

NAMES.DIRECTORY_PATH parameter, OAS 14-19, NET 8-20, NET C-8

CDS, NET 8-20

HOSTNAME, NET 8-20

LDAP, NET 8-20

NDS, NET 8-20

NIS, NET 8-20

ONAMES, NET 8-20

TNSNAMES, NET 8-20

NAMES.DOMAIN_CHECKPOINT FILE parameter, NET C-80

NAMES.DOMAIN_HINTS parameter, NET C-62

NAMES.DOMAINS parameter, MIG F-18, NET 6-53, NET 6-54, NET 6-58, NET C-63

NAMES.FORWARDING_AVAILABLE parameter, NET C-63

NAMES.FORWARDING_DESIRED parameter, NET C-63

namesini.sql script, NET 6-51

namesini.sql script for Oracle Names, MIG F-25

NAMES.INITIAL_RETRY_TIMEOUT parameter, NET 6-63, NET C-8

NAMES.KEEP_DB_OPEN parameter, NET C-64

names.log file
, NET 12-19

NAMES.LOG_DIRECTORY parameter, NET 12-21, NET C-64

NAMES.LOG_FILE parameter, NET 12-21, NET C-64

NAMES.LOG_STATS_INTERVAL parameter, NET C-64

NAMES.LOG_UNIQUE parameter, NET C-65

NAMES.MAX_OPEN_ CONNECTIONS parameter, NET 6-63

NAMES.MAX_OPEN_CONNECTIONS parameter, NET C-9, NET C-65

NAMES.MAX_REFORWARDS parameter, NET C-65

NAMES.MESSAGE_POOL_ START_SIZE parameter, NET 6-63

NAMES.MESSAGE_POOL_START_SIZE parameter, NET C-9, NET C-66

NAMES.NDS.NAME_CONTEXT parameter, NET 6-86

NAMES.NDS.NAME.CONTEXT parameter, NET C-9

NAMES.NIS.META_MAP parameter, NET C-9

NAMES.NO_MODIFY_RESPONSE parameter, NET C-66

NAMES.NO_REGION_DATABASE parameter, NET C-66

names.ora file

configuration parameter reference, NET C-59 to NET C-69

obsolete parameters, NET C-80

parameters

NAMES.ADDRESSES, NET C-59

NAMES.ADMIN_REGION, NET C-59

NAMES.AUTHORITY_REQUIRED, NET C-60

NAMES.AUTO_REFRESH_EXPIRE, NET C-60

NAMES.AUTO_REFRESH_RETRY, NET C-60

NAMES.CACHE_CHECKPOINT_FILE, NET C-61

NAMES.CACHE_CHECKPOINT_INTERVAL, NET C-61

NAMES.CONFIG_CHECKPOINT_FILE, NET C-61

NAMES.CONNECT_TIMEOUT, NET C-62

NAMES.DEFAULT_FORWARDERS, NET C-62

NAMES.DEFAULT_FORWARDERS_ONLY, NET C-62

NAMES.DOMAIN_CHECKPOINT FILE, NET C-80

NAMES.DOMAIN_HINTS, NET C-62

NAMES.DOMAINS, NET C-63

NAMES.FORWARDING_AVAILABLE, NET C-63

NAMES.FORWARDING_DESIRED, NET C-63

NAMES.KEEP_DB_OPEN, NET C-64

NAMES.LOG_DIRECTORY, NET C-64

NAMES.LOG_FILE, NET C-64

NAMES.LOG_STATS_INTERVAL, NET C-64

NAMES.LOG_UNIQUE, NET C-65

NAMES.MAX_OPEN_CONNECTIONS, NET C-65

NAMES.MAX_REFORWARDS, NET C-65

NAMES.MESSAGE_POOL_START_SIZE, NET C-66

NAMES.NO_MODIFY_REQUESTS, NET C-66

NAMES.NO_REGION_DATABASE, NET C-66

NAMES.PASSWORD, NET C-66

NAMES.REGION_CHECKPOINT_FILE, NET C-67

NAMES.RESET_STATS_INTERVAL, NET C-67

NAMES.SAVE_CONFIG_ON_STOP, NET C-67

NAMES.SERVER_NAME, NET C-68

NAMES.TOPOLOGY_CHECKPOINT_FILE, NET C-80

NAMES.TRACE_DIRECTORY, NET C-68

NAMES.TRACE_FILE, NET C-68

NAMES.TRACE_FUNC, NET C-68

NAMES.TRACE_LEVEL, NET C-69

NAMES.TRACE_UNIQUE, NET C-69

NAMES.USE_PLUG_AND_PLAY, NET C-80

NAMESPACE column

V$LIBRARYCACHE table, STU 19-14

namespaces

and object naming rules, SQL 2-73

for nonschema objects, SQL 2-74

for schema objects, SQL 2-73

reserved by Oracle, PCO C-5

NAMES.PASSWORDS parameter, NET C-66

namespid.trc file, NET 12-39

NAMES.PREFERRED_SERVERS parameter, MIG F-4, NET 8-26, NET 8-27, NET C-10

NAMES.REGION_CHECKPOINT_FILE parameter, NET C-67

NAMES.REQUEST_RETRIES parameter, NET 6-63, NET C-10

NAMES.RESET_STATS_INTERVAL parameter, NET C-67

NAMES.SAVE_CONFIG_ON_STOP parameter, NET C-67

NAMES.SERVER_NAME parameter, NET 6-52, NET 6-56

NAMES.SERVER_NAMES parameter, NET C-68

NAMES.TOPOLOGY_CHECKPOINT_FILE parameter, NET C-80

NAMES.TRACE_DIRECTORY parameter, NET 12-39, NET C-68

NAMES.TRACE_FILE parameter, NET 12-39, NET C-68

NAMES.TRACE_FUNC parameter, NET C-68

NAMES.TRACE_LEVEL parameter, NET 12-39, NET C-69

NAMES.TRACE_UNIQUE parameter, NET 12-39, NET C-69

names.trc file, NET 12-34

namesupg.sql script, NET 6-51

namesupg.sql script for Oracle Names, MIG F-18, MIG F-20, MIG F-23, MIG F-25

NAMES.USE_PLUG_AND_PLAY parameter, NET C-80

naming

host variables, PCO 2-16

of cursors, PC_ 6-12

of database objects, PC_ F-11, PCO F-10

of select-list items, PC_ 15-5

of SQL*Forms user exits, PC_ 20-13

select-list items, PCO 11-4

naming backup sets, RMN 1-35

naming contexts

and distributed directories, OAS 17-4, OID 2-10

in partitioned directories, OID 2-18

in replication, OID 2-13, OID 10-2

subordinate, OID 2-19

naming conventions, DCI 2-8, PLS 2-36

configuration files, DCI 2-7

cursor, PCO 5-13

default database, PCO 3-5

error messages, DCI 2-6

globals, DCI 2-5

host variable, PCO 2-8

installation directory, DCI 2-6

message files, DCI 2-6

name format, DCI 2-9

need for, DCI 2-8

registering a name with Oracle, DCI 2-10

schema, DCI 2-5

shared libraries, DCI 2-7

naming database objects, NLS 3-16

naming directory entries, OAS 17-3, OID 2-2

naming methods

CDS, NET 2-37, NET 6-79

Cell Directory Services, NET 2-37, NET 6-79

centralized, NET 6-4

choosing, NET 5-3

described, NET 2-34

directory naming, NET 2-35, NET 6-16 to NET 6-46

external naming, NET 2-37, NET 4-24, NET 6-79 to NET 6-88

host naming, NET 2-36, NET 6-74 to NET 6-78

local naming, NET 2-35, NET 6-5 to NET 6-15

localized, NET 6-4

NDS, NET 2-37, NET 6-79

Network Information Service, NET 2-37, NET 6-79

NIS, NET 2-37, NET 6-79

Novell Directory Services, NET 2-37, NET 6-79

Oracle Names, NET 2-36, NET 6-47 to NET 6-74

prioritizing order, NET 8-19

naming model

hierarchical, NET 4-17

single domain, NET 4-16

namingContexts, OID 5-18

NATIONAL CHAR datatype (ANSI), SQL 2-28

NATIONAL CHAR VARYING datatype (ANSI), SQL 2-28

NATIONAL CHARACTER datatype (ANSI), SQL 2-28

national character datatypes, PLS 2-20

national character set, PLS 2-20

fixed vs. variable width, SQL 2-15, SQL 2-16

in Oracle8i, MIG 9-28

multibyte character data, SQL 2-26

multibyte character sets, SQL 2-15, SQL 2-16

parameter, NLS 2-34

variable-length strings, SQL 2-16

NATIONAL CHARACTER SET clause

of CREATE DATABASE, SQL 7-271

NATIONAL CHARACTER SET parameter

of ALTER DATABASE, SQL 7-16

NATIONAL CHARACTER VARYING datatype

ANSI, SQL 2-28

national language support, GTK 3-43

NCLOBs, ADL 2-2, SPR 18-3

National Language Support (NLS), PC_ 4-48, PCO 4-35, PLS 2-20

architecture, NLS 1-2

bulkdelete, OID 11-9

bulkload, OID 11-8

bulkmodify, OID 11-9

character sets for, SCN 12-6

CHECK constraints and, SCN 271

clients and servers may diverge, SCN 417

client/server architectures, DDS 1-48

command line tools, OID 11-5

DATE datatype and partitions, SCN 11-12, SCN 11-21

distributed databases

clients and servers may diverge, DDS 1-47

heterogeneous systems, DDS 1-49

homogeneous systems, DDS 1-48

Export, SUT 1-54

Heterogeneous Services, DDS A-6

character set of non-Oracle source, DDS A-8

date format, DDS A-7

languages in character date values, DDS A-7

Import, SUT 2-52

Java clients

ldapadd, OID 11-6

ldapaddmt, OID 11-6

ldapbind, OID 11-6

ldapcompare, OID 11-6

ldapdelete, OID 11-6

ldapmoddn, OID 11-7

ldapmodify, OID 11-6

ldapmodifymt, OID 11-6

ldapsearch, OID 11-6

ldifwrite, OID 11-8

NCHAR and NVARCHAR2 datatypes, SCN 12-7

NCLOB datatype, SCN 12-14

NLS_LANGUAGE parameter, NLS 4-4

parameters, SCN 5-5

settings for Oracle Internet Directory, OID 11-2

SQL*Loader, SUT 5-30

views and, SCN 10-15

national language support (NLS), DCI 2-12

national language support. See NLS

NATIVE

value of DBMS option, PC_ 10-16

native authentication for directory naming, NET 2-51

native authentication on Windows NT, GTK 3-77

native datatypes

and SQL*Loader, SUT 5-59

conflicting length specifications

SQL*Loader, SUT 5-68

native dynamic SQL

advantages of, ADG 8-13

compatibility, MIG 9-13

differences with DBMS_SQL package, ADG 8-12

downgrading, MIG 13-34

fetching into records, ADG 8-16

interoperability, MIG 9-30

performance, ADG 8-15

See Also dynamic SQL

user-defined types, ADG 8-16

native dynamic SQL. See dynamic SQL

native interface, PC_ 5-55

NATURAL subtype, PLS 2-13

NATURALN subtype, PLS 2-13

navigating Oracle Directory Manager, OID 4-7

navigation, OCI 13-17, ADQ 2-6

navigational access sample program, PC_ 17-24

navigational functions

error codes, OCI 16-6

return values, OCI 16-5

terminology, OCI 16-4

Navigator pane, in Oracle Directory Manager, OID 4-7

Navigator window

Oracle Parallel Server folder, PSG 7-3

Oracle Parallel Server objects, PSG 7-3

Parallel Server Instances folder, PSG 7-5

right-mouse menu, PSG 7-5, PSG 7-12

Connect, PSG 7-6

Disconnect, PSG 7-6

Edit, PSG 7-6, PSG 7-16

Related Tools, PSG 7-6

Remove, PSG 7-6

Results, PSG 7-6

Shutdown, PSG 7-6, PSG 7-9

Startup, PSG 7-6, PSG 7-7

starting Oracle Parallel Server database, PSG 7-7

stopping Oracle Parallel Server database, PSG 7-9

viewing Oracle Parallel Server status, PSG 7-16

viewing shutdown results, PSG 7-12

viewing startup results, PSG 7-12

NCHAR

issues, OCI 5-31

migration, MIG 9-28

use in Oracle8i, MIG 9-28

NCHAR and NLS environment variables

compatibility, MIG 9-28

NCHAR data

Export, SUT 1-56

NCHAR datatype, ADG 3-2, ADG 3-5, GTK 4-15, PLS 2-20, SCN 12-7, SQL 2-15

ANSI, SQL 2-28

NCHAR VARYING datatype (ANSI), SQL 2-28

NCLOB, DCI 6-2

datatype, OCI 3-21

NCLOB datatype, PLS 2-23, SCN 12-14, SQL 2-26

transactional support of, SQL 2-26

NCLOB support, REP A-7

NCLOBs

compatibility, MIG 9-26

datatype, ADL 2-2

DBMS_LOB, offset and amount parameters in characters, ADL 3-7

loading, SUT 5-98

modify via DBMS_LOB, ADL 3-8

varying-width, ADL 2-4

NCR, SMS 32-1

NDS external naming, NET 2-37, NET 6-79, NET 8-20

connecting with, NET 6-83

establishing a connection with, NET 6-83

negative numbers

loading, SUT 4-15

negative scale, SQL 2-18

nested column objects

loading, SUT 5-92

nested files, SRF 1-45

nested loop joins, DWG 18-35

nested loops joins, STU 4-50

cost-based optimization, STU 4-59

nested materialized views, DWG 8-23

refreshing, DWG 14-26

restrictions, DWG 8-24

NESTED precompiler option, PCO A-3

nested programs, PCO A-7

support for, PCO 2-23

nested queries, DWG 18-49

nested table

element ordering, OCI 11-21

functions for manipulating, OCI 11-20

NESTED TABLE clause

of ALTER TABLE, SQL 7-142

of CREATE TABLE, SQL 7-386, SQL 7-400

nested table types, SQL 2-31

compared with varrays, SQL 2-35

comparison rules, SQL 2-35

creating, SQL 7-439

dropping the body of, SQL 7-508

dropping the specification of, SQL 7-506

modifying, SQL 7-145

nested tables, ADO 1-9, ADO 6-14, PC_ 18-2, SCN 10-10, SCN 13-12

changing returned value, SQL 7-145

collection locators, GTK 3-34

compatibility, MIG 9-11, MIG 9-29

COMPRESS clause, ADO 6-16

creating, SQL 7-444

creating indexes on, ADO 6-17

creation, PC_ 18-2

data stored in indexed-organized table, GTK 3-34

defining as index-organized tables, SQL 7-142

DML operations on, ADO 6-19

exporting, SUT 1-59

consistency and, SUT 1-17

importing, SUT 2-56

in an index-organized table, ADO 6-15

indexes, ADO 2-4

index-organized tables, SCN 10-41

key compression, SCN 10-33

INSTEAD OF triggers, ADO 5-11, SCN 14-5

manipulating, PLS 4-13

OCICollIsLocator(), GTK 3-34

querying, ADO 9-18

restrictions, SCN 186

returning as locators, ADO 6-18, ADO 9-30

storage, ADO 6-14, ADO 9-29

storage characteristics of, SQL 7-142, SQL 7-400

storage parameters for, SAD 12-12

triggers on view columns, GTK 3-35

uniqueness in, ADO 9-30

updating in views, ADO 5-11, SCN 14-5

user-specified storage clauses for, GTK 3-34

UTL _COLL package, GTK 3-34

versus index-by tables, PLS 4-3

vs VARRAY, ADO 9-18

vs varrays, ADO 9-15

NESTED_TABLE_ID, ADO 6-17, ADO 9-29

NESTEDprecompiler option, PCO 14-31

nesting

block, PLS 1-3

FOR loop, PLS 3-14

object, PLS 9-7

record, PLS 4-43

net service name, OID 3-2, OID 3-3

Net Service Name Wizard, NET 6-7, NET 6-23

net service names

adding an address, NET 8-2

configure an Oracle Connection Manager address, NET 8-39

creating in Oracle Names, NET 6-66

directory naming, NET 6-23

external naming, NET 2-37, NET 6-79

external procedures, NET 8-48

local naming, NET 2-35, NET 6-6

multiple addresses, NET 8-2, NET 8-4

Oracle Names, NET 2-36, NET 6-65

prioritizing naming methods, NET 8-19

testing with TNSPING, NET 11-19

NET_CONFIG_METHOD parameter, NET C-79

Net8, OID 2-31, OID 2-33, GTK 3-64, GTK 3-70, GTK 3-75, SCN 1-19, SCN 1-36, SCN 6-5, SUT 1-53

applications and, SCN 6-5

client/server systems use of, SCN 6-5

coexistence issues, MIG F-5 to MIG F-11

Oracle Names, MIG F-11

release 8.0 client connection to release 8.1 database, MIG F-6

release 8.1 client connection to release 8.0 database, MIG F-9

release 8.1 client connection to release 8.1 database, MIG F-5

release 8.1 client connection to version 7 database, MIG F-9

third-party Oracle7 applications, MIG F-8

using SERVICE_NAME, MIG F-7

using SID, MIG F-7

using the Net8 Assistant, MIG F-11

compared with SQL*Net, MIG F-2

concept described, NET 1-2

concurrent logons, PCO 3-3

connect operations, NET 2-3

connecting to Oracle via, PC_ 3-7

connection load balancing, MIG 9-47

connection syntax, PC_ 3-6

control utilities, NET 11-3

dynamic (connection) load balancing, GTK 3-77

exception operations, NET 2-7

FAILOVER option, REP 6-10

FAILOVER parameter, MIG F-11

for concurrent connections, PC_ 3-7

function of, PC_ 3-6

JDBC drivers, NET 3-11

listener.ora file with Oracle Enterprise Manager, MIG F-15

LOAD_BALANCE parameter, MIG F-11

migrating or upgrading to, MIG 8-13, MIG 9-46

multi-threaded server requirement, SCN 8-14, SCN 8-16

NAMES.DEFAULT_DOMAIN parameter, MIG F-4

NAMES.PREFERRED_SERVERS parameter, MIG F-4

native authentication on Windows NT, GTK 3-77

Net8 Assistant, GTK 3-75

Use Options Compatible with Net8 8.0 Clients option, MIG F-11

Use Oracle8i Release 8.0 Compatible Identification option, MIG F-11

Net8 Easy Config, GTK 3-75

obsolete parameters, MIG F-4, MIG F-14

COMMUNITY parameter, MIG F-4

NAMES.DEFAULT_ZONE parameter, MIG F-4

operations, NET 2-7

overview, NET 1-2

overview of, SCN 6-5

preparing for replication, OID 10-4

primary functions, NET 2-7

service names in, SAD 7-15

service naming, MIG 9-47, GTK 3-75

downgrading, MIG 13-50

SERVICE_NAME parameter, MIG F-6

SOURCE_ROUTE parameter, MIG F-11

transmitting archived logs via, SAD 7-15

upgrading

configuration files, MIG F-13

listener.ora file, MIG F-15

software on client, MIG F-13

software on server, MIG F-13

sqlnet.ora file, MIG F-14

tnsnames.ora file, MIG F-14

to Oracle Connection Manager release 8.1, MIG F-16

to Oracle Names release 8.1, MIG F-17

to release 8.1, MIG F-12 to MIG F-15

verify service name and instance name, MIG F-12

using ROWID datatype, PCO 4-9

using to connect to Oracle, PCO 3-4

Net8 access control, NET 4-8, NET 8-35

Net8 Assistant, NET 8-52, STU 22-17

adding addresses, NET 8-2

clients

client load balancing, NET 8-4

connect-time failover, NET 8-4

default network domains, NET 8-17

local naming method, NET 6-7

Oracle Connection Manager, NET 8-39

Default Domain field, NET 6-63

delegating domains to administrative regions, NET 6-73

described, NET 4-28

directory naming, NET 2-43

Directory Server Migration Wizard, NET 6-32

discovering Oracle Names servers, NET 6-61

external procedure connections, NET 8-45

Heterogeneous Services connections, NET 8-49

Instance Name field, NET 8-9

listeners

Configure Prespawned Servers dialog box, NET 7-19

configuring, NET 7-5

Database Services tab, NET 7-14

Global Database Name field, NET 7-13, NET 8-9, NET 8-52

Maximum Prespawned Servers field, NET 7-16

non-default through Oracle Names, NET 7-11

Oracle Home Directory field, NET 8-47, NET 8-49

Oracle Home Directory field for listeners, NET 7-13

prespawned dedicated servers, NET 7-18

Program Name field, NET 8-47, NET 8-49

protocol addresses, NET 7-6

Register Service with Oracle Names option, NET 6-64

registering database information with Oracle Names, NET 6-64

SID field, NET 7-13

static service information, NET 7-13

local naming method, NET 6-7

log files, NET 12-22

multiple address options, NET 8-4

Names Wizard, NET 6-51, NET 6-55

Net Service Name Wizard, NET 6-7, NET 6-23

net service names, NET 6-7

Oracle Names

aliases, NET 6-72

Attempts Per Names Server field, NET 6-63

Default Domain field, NET 6-63

discovering, NET 6-61

global database link qualifiers, NET 6-70

global database links, NET 6-69

Initial Preallocated Requests field, NET 6-63

Maximum Open Connections field, NET 6-63

Maximum Wait Each Attempt field, NET 6-63

net service names, NET 6-66

non-default listener, NET 7-11

preferred Oracle Names servers, NET 8-26

querying network objects, NET 11-14

region database, NET 6-51

registering database information from listener, NET 6-64

starting Oracle Names servers, NET 11-14

Oracle Rdb Database, NET 8-53

Oracle RDB Database field, NET 8-9

profiles

advanced options, NET 8-23

Always Use Dedicated Server option, NET 8-21

Client Registration ID field, NET 8-23

Disable Out-of-Band Break option, NET 8-24

naming method specification, NET 8-19

Prefer Connection Manager Routing option, NET 8-21

preferred Oracle Names servers, NET 8-26

routing connections, NET 8-21

TNS Time Out Value option, NET 8-23

Turn Off UNIX Signal Handling option, NET 8-23

RDB Database field, NET 8-52

routing connection requests, NET 8-21

Session Data Unit (SDU) field in Net8 Assistant, NET 8-9

SID field for listeners, NET 8-47, NET 8-49

specifying naming methods, NET 8-19

starting, NET 4-28

starting an Oracle Names server, NET 6-59, NET 11-5

testing

client configuration, NET 11-22

server configuration, NET 11-15

Timeout field, NET 7-17

trace files, NET 12-40

Type of Service field, NET 8-9

Use for Heterogeneous Services option, NET 8-9, NET 8-51

Net8 Assistant, described, MIG F-2

Net8 Client, described, NET 4-2

Net8 Configuration Assistant, GTK 2-4, GTK 3-77

clients

administrative context selection, NET 6-19

directory access, NET 6-21

local naming method, NET 6-11

Custom installation, PSG 3-6

described, NET 4-27

listener configuration, NET 7-4

local naming method, NET 6-11

net service names, NET 6-11

OracleDBCreators group, NET 2-44, NET 2-53, NET 6-22

OracleNetAdmins group, NET 2-52, NET 6-22

OracleSecurityAdmins group, NET 2-53, NET 6-22

servers

administrative context selection, NET 6-19

directory access, NET 6-22

Oracle Context creation, NET 2-43, NET 6-22

Oracle schema creation, NET 6-22

starting, NET 4-27

Typical installation, PSG 3-5

using during installation, PSG 3-6

Net8 Configuration Assistant, described, MIG F-2

Net8 Firewall Proxy, NET 4-8

Net8 listener, DDS 6-5, DDS 7-2

Net8 Native Authentication, OAS 8-15

Net8 OPEN

API function calls, NET 10-3

compatibility with C language, NET 10-3

configuration requirements, NET 10-7

configuring system to use applications, NET 10-8

error messages, NET 10-9

finding API, NET 10-7

for distributed applications, NET 10-2

integrating with non-SQL information, NET 10-2

library, NET 10-7

sample applications, NET 10-9

Net8 Server, described, NET 4-2

../../network.816/a76933, SCN 383

Netscape Communications Corporation, OAS 10-2

network

array interface, STU 22-16

authentication, SAD 22-11

bandwidth, OID 12-14, STU 16-6

capacity planning, OID 12-14

communicating over, PC_ 3-6

connectivity, in capacity planning, OID 12-2

constraints, STU 16-6

detecting performance problems, STU 22-9

prestarting processes, STU 22-6

problem solving, STU 22-11

protocols, PC_ 3-6

reducing traffic, PC_ C-4

requirements, OID 12-14

Session Data Unit, STU 22-16

tuning, STU 22-1

network authentication, SAD 22-11

Network Authentication (NA)

layer in error stacks, NET 12-17

network character set, keyword values, NET C-4

network configuration

centralized management, NET 6-4

localized management, NET 6-4

network configuration files

ldap.ora.ora, PSG 3-16

listener.ora, PSG 3-14, PSG 3-40, PSG 6-6

Oracle Enterprise Manager service discovery, PSG C-4

sqlnet.ora, PSG 3-21, PSG 3-40

testing, PSG 4-3

tnsnames.ora, PSG 3-16, PSG 3-40

Oracle Enterprise Manager service discovery, PSG C-5

network connections

minimizing, DDS 2-14

/network directory, PSG A-3

Network Encryption (NAE), layer in error stacks, NET 12-17

network files

configuring, SBY 2-27, SBY 5-4

Network Information Service external naming, NET 2-37, NET 4-24, NET 8-20

configuring, NET 6-79

connecting with, NET 6-79

establishing a connection with, NET 6-79

Network Interface (NI)

described, NET 3-8

layer in error stacks, NET 12-17

Network Interface Cards (NICs), failures of, OID 14-8

network listener process, SCN 6-6

connection requests, SCN 8-14, SCN 8-16

dedicated server example, SCN 8-26

multi-threaded server example, SCN 8-22

service names, SCN 6-6

Network Naming (NN)

layer in error stacks, NET 12-17

network performance, improving

by adjusting SDU size, NET 5-8

by client load balancing, NET 5-8

client load balancing, NET 2-20, NET C-40

connection concentration, NET 5-7

connection pooling, NET 2-12, NET 5-6

listener queuesize, NET 5-6

Network Program Interface (NPI), NET 3-9

Network Routing (NR)

layer in error stacks, NET 12-17

Network Security

DES_40 encryption, NET 4-26

described, NET 4-26

MD5 checksumming, NET 4-26

RC4_128 encryption, NET 4-26

RC4_40 encryption, NET 4-26

RC4_56 encryption, NET 4-26

Network Services (NA), layer in error stacks, NET 12-17

Network Session (NS)

described, NET 3-8

Network Session (NS), layer in error stacks, NET 12-17

network traffic

reducing, PLS 1-22

Network Transport (NT), layer in error stacks, NET 12-17

NetWorker

label template, using, LEG C-1

name resolution, LEG B-9

naming requirements, LEG B-5

services, LEG B-10

NetWorker server

restarting, LEG 5-15

shutting down, LEG 5-15

NetWorker User program, LEG D-1

privileges, LEG D-1

starting, LEG D-1

network-level connection redirection, OID 14-6

network-level failover, OID 14-5

networks

client/server architecture use of, SCN 6-2

communication protocols, SCN 6-5, SCN 8-28

dispatcher processes and, SCN 8-14, SCN 8-16

distributed databases use of, DDS 1-2, SCN 372

drivers, SCN 8-28

Export, SUT 1-53

failure of, SBY 5-40

failures of, SCN 343

Import and, SUT 2-47

listener processes of, SCN 6-6, SCN 8-14

Net8, SCN 6-5

network authentication service, SCN 282

transporting Export files across a network, SUT 1-53

two-task mode and, SCN 8-24, SCN 8-25

using Oracle on, SCN 1-19, SCN 1-36

NEVER clause, DWG 8-20

NEVER REFRESH mode

materialized views and downgrading, MIG 13-17

NEW correlation name, ADG 13-16

new features, OAS 17-1, OCI 1-12, SPR xcvii, PSA iii, PSC xv

adding after migration or upgrade, MIG 8-8

autolocate option, RMN xxiii

benefits, OCI 1-12

centralized user and privilege management, DDS xxxiv

client load balancing, NET xviii

configure compatible command, RMN xxiv

connection load balancing, NET xviii

connect-time failover, NET xviii

create catalog command, RMN xxv

crosscheck commands, RMN xxiv

data corruption protection, SBR xxiv

data subsetting and subqueries, REP A-6

direct hand-off, NET xviii

directory naming, NET xviii

drop catalog command, RMN xxv

duplexed backup sets, RMN xxv

duplicate command, RMN xxv

encryption algorithm changes, OAS 2-2

enhanced security, REP A-8

FIPS 140-1, OAS D-1

for management and use, REP A-7

generic connectivity, DDS xxxiii

Heterogeneous Services initialization parameters, DDS xxxiv

improved mass deployment support, REP A-2

improved Oracle8i Lite integration, REP A-5

improved security, REP A-4

introduction, OCI 1-12

Java SSL, OAS F-1

LOB support, REP A-7

LOG_ARCHIVE_DEST_n parameter, SBR xxv

media management API 2.0, RMN xxiv

Net8 Configuration Assistant, NET xix

Oracle Connection Manager, NET xix

Oracle Enterprise Login Assistant, OAS 19-1

Oracle Enterprise Security Manager, OAS 20-1

Oracle Replication Manager enhancements, REP A-4

Oracle Wallet Manager, OAS 18-1

parallel DML and DDL, DDS xxxiv

performance enhancements, REP A-2, REP A-5

RADIUS authentication, OAS 4-1

remove records from recovery catalog, RMN xxiv

replication, REP A-1

report need backup redundancy command, RMN xxv

requiring 8.1.0 compatibility, MIG 9-9

resetlogs option in RMAN, RMN xxiv

RMAN disk affinity, RMN xxv

RMAN TSPITR without catalog, RMN xxvi

service naming, NET xviii

service registration, NET xviii

SERVICE_NAMES, NET xix

SQL optimization for heterogeneous systems, DDS xxxiv

SSL authentication, OAS 10-1

startup, shutdown, and alter database in RMAN, RMN xxv

subqueries for snapshots, REP A-6

subquery snapshots, REP A-6

suspend/resume database operations, SBR xxiv

TCP/IP with SSL, NET xix

Thin JDBC support, OAS 3-1

transportable tablespaces, SBR xxv

unique names for backup pieces by default, RMN xxv

upgrade catalog command, RMN xxv

V$BACKUP_SYNC_IO and V$BACKUP_ASYNC_IO, RMN xxvi

V$HS_AGENT and V$HS_SESSION, DDS xxxv

new features in 8.1.5

SQL*Loader behavior and restrictions, SUT 3-17

SQL*Loader support for LOBFILEs and SDFs, SUT 3-19

standby databases, SBY xxvii

new features in 8.16

standby databases, SBY xxvii

new syntaxes, adding, OID 2-6

new, features

Primary/Secondary Instance, PSC A-2

NEW_DBNAME

Migration utility option, MIG 4-17

NEW_TIME function, SQL 4-55

newdb.sql, OID B-10

newname for datafile option (RMAN)

set command, RMN 6-10

NEXT clause

of ALTER MATERIALIZED VIEW...REFRESH, SQL 7-53

NEXT collection method, PLS 4-23

NEXT extent, DWG 18-44

NEXT parameter

of STORAGE clause, SQL 7-607

NEXT storage parameter, PSA 13-5, PSC 7-7

altering, SAD 12-13

description, SAD 12-9

rollback segments, SAD 11-5, SAD 11-8

setting for the data dictionary, SAD 19-27

NEXT_DAY function, SQL 4-55

nextElement() - oracle.jms.AQjmsQueueBrowser.nextElement(), JPR 2-148

NEXTVAL pseudo-column, ADG 2-31

restrictions, ADG 2-32

NEXTVAL pseudocolumn, PLS 5-3, SQL 2-56, SQL 7-372

NEXTVAL pseudocolumns, PCO 4-12

NI layer, NET 3-8

nibble, PLS 2-30

nibbles, PCO 4-49

NIS external naming, NET 2-37, NET 4-24, NET 6-79, NET 8-20

connecting with, NET 6-79

establishing a connection with, NET 6-79

NIS Maps, NET 6-80

NIST

compliance, PC_ xvii, PCO cxxvi

NIST, address of, PC_ xviii, PCO cxxviii

NLS

and JDBC drivers, NLS 6-4

conversions, NLS 6-4

data size restrictions, NLS 6-10

for JDBC OCI drivers, NLS 6-6

for JDBC Thin drivers, NLS 6-7

Java methods that employ, NLS 6-3

migration, MIG 9-28

OCI functions, OCI xvii, OCI 2-3

ratio, NLS 6-10

See National Language Support

NLS (National Language Support), PC_ 4-48, PC_ A-2, PCO 4-35, PLS 2-20

multi-byte character strings, PCO 4-37

NLS (national language support), DCI 2-12

NLS and NCHAR environment variables

compatibility, MIG 9-28

NLS Calendar Utility, NLS B-11

NLS data

error messages, NLS A-4

obsolete, NLS C-2

supported calendar systems, NLS A-21

supported linguistic definitions, NLS A-19

supported territories, NLS A-5

NLS Data Installation Utility, NLS B-13

NLS parameter

NLS_CURRENCY, PC_ 4-48, PCO 4-35

NLS_DATE_FORMAT, PC_ 4-48, PCO 4-35

NLS_DATE_LANGUAGE, PC_ 4-48, PCO 4-35

NLS_ISO_CURRENCY, PC_ 4-48, PCO 4-35

NLS_LANG, PC_ 4-49, PCO 4-36

NLS_LANGUAGE, PC_ 4-48, PCO 4-35

NLS_NUMERIC_CHARACTERS, PC_ 4-48, PCO 4-35

NLS_SORT, PC_ 4-48, PCO 4-35

NLS_TERRITORY, PC_ 4-48, PCO 4-35

NLS parameters

default values, NLS A-25

using in SQL functions, NLS 4-2

NLS. See National Language Support (NLS)

NLS. See National Language Support (NLS).

NLS_* parameters, PSA 1-11

NLS_CALENDAR initialization parameter, SRF 1-73

NLS_CALENDAR parameter, NLS 2-20

of ALTER SESSION, SQL 7-90

NLS_CHAR precompiler option, PC_ 10-32

NLS_CHARSET_DECL_LEN function, NLS 4-6, SQL 4-56

NLS_CHARSET_ID function, NLS 4-6, SQL 4-56

NLS_CHARSET_NAME function, NLS 4-6, SQL 4-57

NLS_COMP initialization parameter, SRF 1-74

NLS_COMP parameter, NLS 2-32, NLS 4-9

of ALTER SESSION, SQL 7-90

NLS_CREDIT parameter, NLS 2-23, NLS 2-27

NLS_CURRENCY initialization parameter, SRF 1-75

defined by NLS_TERRITORY, SRF 1-79

NLS_CURRENCY parameter, NLS 2-23

of ALTER SESSION, SQL 7-90

NLS_DATABASE_PARAMETERS view, SRF 2-154

NLS_DATE_FORMAT environment variable, RMN 2-2, RMN 5-21, RMN 6-26

NLS_DATE_FORMAT initialization parameter, SRF 1-75

defined by NLS_NUMERIC_CHARACTERS, SRF 1-79

defined by NLS_TERRITORY, SRF 1-79

NLS_DATE_FORMAT parameter, ADG 3-8, NLS 2-14, SCN 12-10

of ALTER SESSION, SQL 7-90

NLS_DATE_LANGUAGE initialization parameter, SRF 1-76

NLS_DATE_LANGUAGE parameter, NLS 2-16, SQL 2-48

of ALTER SESSION, SQL 7-90

NLS_DEBIT parameter, NLS 2-27

NLS_DUAL_CURRENCY parameter, NLS 2-25

NLS_INITCAP function, SQL 4-58

NLS_INSTANCE_PARAMETERS view, SRF 2-155

NLS_ISO_CURRENCY initialization parameter, SRF 1-76

defined by NLS_TERRITORY, SRF 1-79

NLS_ISO_CURRENCY parameter, NLS 2-24

of ALTER SESSION, SQL 7-90

NLS_LANG

choosing a locale with, NLS 2-4

environment variable, NLS 3-18, NLS 6-6

examples, NLS 2-5

specifying, NLS 2-5

NLS_LANG environment variable, OID 11-2, RMN 2-2, RMN 5-21, RMN 6-26, SCN 11-20, SUT 2-53

compatibility, MIG 9-28

Export, SUT 1-54

Import, SUT 2-53

settings, OID 11-2

specifying, OID 11-3

SQL*Loader, SUT 5-30

NLS_LANGUAGE initialization parameter, SRF 1-77

NLS_LANGUAGE parameter, NLS 2-8, SCN 11-20, SQL 2-48, SQL 5-21

of ALTER SESSION, SQL 7-90

NLS_LIST_SEPARATOR parameter, NLS 2-33

NLS_LOCAL

precompiler option, PCO 14-31

NLS_LOCAL precompiler option, PC_ 10-32

NLS_LOWER function, SQL 4-59

NLS_MONETARY_CHARACTERS parameter, NLS 2-26

NLS_NCHAR

Migration utility option, MIG 4-17

NLS_NCHAR environment variable, NLS 3-18

NLS_NCHAR parameter, NLS 2-34

NLS_NUMERIC_CHARACTERS initialization parameter, SRF 1-78

NLS_NUMERIC_CHARACTERS parameter, NLS 2-21, SCN 12-9

of ALTER SESSION, SQL 7-91

NLS_SESSION_PARAMETERS view, SRF 2-155

NLS_SORT initialization parameter, SRF 1-78

NLS_SORT parameter, NLS 2-32, NLS 2-33, SQL 5-21

no effect on partitioning keys, SCN 11-20

of ALTER SESSION, SQL 7-91

ORDER BY access path, STU 4-45

NLS_TERRITORY initialization parameter, SRF 1-79

NLS_TERRITORY parameter, NLS 2-10, SQL 2-48

of ALTER SESSION, SQL 7-91

NLS_UNION_CURRENCY initialization parameter, SRF 1-76

NLS_UNION_CURRENCY parameter

of ALTER SESSION, SQL 7-90

NLS_UPPER function, SQL 4-60

NLSDATA (language-independent data)

utilities for loading, NLS B-12

NLSSORT function, NLS 4-7, SQL 4-59

NLSSORT order, and indexes, ADG 5-8

nmcbild.sql script, MIG F-22

nmcrgrnt.sql script, MIG F-22

nmiconf.log file, PSG C-7

nmiconf.lst file, PSG C-7

NMO_INFORMATION table for Oracle Names, MIG F-19

NMP, SMS 31-1

NMTOKEN - oracle.xml.parser.v2.AttrDecl.NMTOKEN, JPR 4-7

NMTOKENS - oracle.xml.parser.v2.AttrDecl.NMTOKENS, JPR 4-7

NNC, SMS 26-1

NNF, SMS 30-1

NNL, SMS 28-1

NNL-00018 error message, NET 6-54

NNL-00024 error message, NET 6-54

NNO, SMS 27-1

N-node

Oracle Parallel Server configuration, PSC 9-17

No AQ driver registered - error, ADQ D-13

no authentication, in access control, OID 9-24, OID 9-30

no SSL authentication option, OID 4-6

No such element - error, ADQ D-10

NO_DATA_FOUND exception, PLS 6-5

NO_DATA_FOUND keyword, DDS 3-12

NO_EXPAND hint, SQL 2-65, STU 7-17

NO_INDEX hint, SQL 2-65, STU 7-15, STU 12-7

NO_MERGE hint, DDS 3-9, SQL 2-67, STU 7-32

NO_PUSH_JOIN_PRED hint, SQL 2-67

NO_PUSH_PRED hint, STU 7-34

NO_SPACE_CHECK

Migration utility option, MIG 4-17

NO_UNNEST hint, STU 7-33

NOAPPEND hint, DWG 18-60, SQL 2-67, STU 7-28

NOARCHIVELOG clause

of ALTER DATABASE, SQL 7-9, SQL 7-18

of CREATE CONTROLFILE, SQL 7-266

OF CREATE DATABASE, SQL 7-270

NOARCHIVELOG mode, DWG 18-57, PSA 3-8, SCN 358

archiving, SAD 7-3, SBR 2-17

backing up, RMN 5-25

changing mode, PSA 3-2, PSA 3-8, PSC B-3

creating a database, PSA 3-2, PSA 3-8, SRF 1-61

database backups for recovery, SCN 365

datafile loss in, SBR 6-2

defined, SCN 358

definition, SAD 7-3, SBR 2-17

disadvantages, SBR 5-15

distributed database backups, SBR 3-9

inconsistent closed backups in, SBR 1-18

LOGGING mode and, SCN 150

media failure, SAD 7-4

no hot backups, SAD 7-4

offline backups, PSC 1-5

overview, SBR 1-11, SCN 1-47

recovery, SBR 5-15

requiring offline backups, PSA 13-3

running in, SAD 7-3, SBR 2-17

strategies for backups in, SBR 3-4

switching to, SAD 7-6

taking datafiles offline in, SAD 10-8

NOAUDIT schema_objects statement, SQL 7-552

NOAUDIT sql_statements statement, SQL 7-550

NOAUDIT statement, SCN 13

disabling audit options, SAD 24-11

disabling default object audit options, SAD 24-13

disabling object auditing, SAD 24-12

disabling statement and privilege auditing, SAD 24-12

locks, SCN 240

NOCACHE clause

of ALTER MATERIALIZED VIEW, SQL 7-51

of ALTER MATERIALIZED VIEW LOG, SQL 7-61

of ALTER SEQUENCE. See CREATE SEQUENCE

of ALTER TABLE, SQL 7-151

of CREATE CLUSTER, SQL 7-258

of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG, SQL 7-336

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-323

of CREATE SEQUENCE, SQL 7-374

of CREATE TABLE, SQL 7-408

NOCACHE hint, SQL 2-67, STU 7-31

NOCACHE option

CREATE SEQUENCE statement, ADG 2-34

NOCOMPRESS clause

of ALTER TABLE, SQL 7-144

of CREATE INDEX, SQL 7-300

of CREATE TABLE, SQL 7-397

NOCOPY clause

of CREATE FUNCTION, SQL 7-287

of CREATE PROCEDURE, SQL 7-356

NOCOPY compiler hint, PLS 7-17

restrictions on, PLS 7-19

NOCOPY parameter passing mode, GTK 3-80

compatibility, MIG 9-13

NOCOPY restrictions, ADL 10-12

NOCYCLE clause

of ALTER SEQUENCE. See CREATE SEQUENCE, SQL 7-81

of CREATE SEQUENCE, SQL 7-373

node

current, PC_ 3-7

definition of, PC_ 3-6

failure, PSC 1-3

node in Oracle Internet Directory, OID 2-29

node monitoring, PSC 3-3

node#environ parameter, PSG B-5

node#inst_init_ora parameter
, PSG B-5

node#tns_admin parameter, PSG B-5

node_list parameter, PSG B-4, PSG C-3

NodeFactory - oracle.xml.parser.v2.NodeFactory, JPR 4-35

NodeFactory() - oracle.xml.parser.v2.NodeFactory.NodeFactory(), JPR 4-36

nodes

adding, PSA 8-11

adding to cluster, PSG 9-7

affinity awareness, PSA 13-19

cache coherency, PSC 4-9

definition of, PSC 2-2

described, PSG 1-2

disk affinity in a Parallel Server, SCN 205

failure of, PSA 14-2

hardware for, PSC 2-1

high availability, PSC 9-6

local, PSA 1-4, PSA 1-5

of distributed databases, SCN 1-34

parallel backup, PSA 13-16

remote, PSA 4-4

nodes, described, NET 3-2

NOFORCE clause

of CREATE JAVA, SQL 7-313

of CREATE VIEW, SQL 7-458

NOLOG attribute, SUT 8-20

NOLOGGING clause, DWG 18-50, DWG 18-56, DWG 18-58, SBY 5-28, SBY 5-48

of ALTER INDEX, SQL 7-36

of ALTER MATERIALIZED VIEW, SQL 7-50

of ALTER MATERIALIZED VIEW LOG, SQL 7-60

of ALTER TABLE, SQL 7-152

of ALTER TABLESPACE, SQL 7-178

of CREATE INDEX, SQL 7-301

of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG, SQL 7-336

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-322

of CREATE TABLE, SQL 7-395

of CREATE TABLESPACE, SQL 7-421

with APPEND hint, DWG 18-60

NOLOGGING mode

direct-load INSERT, SCN 149

parallel DDL, SCN 187, SCN 189

partitions, SCN 11-58

SQL operations affected by, SCN 151

NOMAXVALUE clause

of CREATE SEQUENCE, SQL 7-373

NOMAXVALUE parameter

of ALTER SEQUENCE. See CREATE SEQUENCE

NOMINIMIZE RECORDS PER BLOCK clause

of ALTER TABLE, SQL 7-153

NOMINVALUE clause

of ALTER SEQUENCE. See CREATE SEQUENCE, SQL 7-81

of CREATE SEQUENCE, SQL 7-373

NOMONITORING clause

of ALTER TABLE, SQL 7-152

of CREATE TABLE, SQL 7-409

NOMOUNT option, PSA 14-11

STARTUP statement, SAD 3-4

non-blank-padding semantics, PLS B-3

non-blocking mode, OCI 2-37

example, OCI 2-38

noncumulative incremental backups, RMN 1-52

non-default parameter files, PSA 1-2

non-default port, running on, OID 4-3

non-deferred linking, GTK 7-4

NONE - oracle.jms.AQjmsConstants.NONE, JPR 2-55

NONE clause

of SET ROLE, SQL 7-601

NONE option

STATISTICS Export parameter, SUT 1-24

non-equijoins

defined, STU 4-47

nonequivilancy tests, SQL 3-6

nonfatal errors

warning messages, SUT 1-40

non-fixed mode, lock elements, PSC 5-19

non-NULL

before writing to LOB column make it

internal persistent LOBs, ADL 9-259

non-PCM locks, PSA 7-16

dictionary cache lock, PSA 7-19, PSC 4-7

DML lock, PSA 7-17, PSC 4-7

enqueue, PSC 4-4

IDLM capacity, PSC 4-13

library cache lock, PSA 7-19, PSC 4-7

mount lock, PSA 7-19

mount locks, PSC 4-8

overview, PSA 7-16, PSC 4-6

relative number, PSC 4-13

system change number, PSA 7-18

table lock, PSA 7-17, PSC 4-7

transaction lock, PSA 7-17, PSC 4-7

types, PSC 4-5

user control, PSC 4-13

non-persistent queues, SCN 76

Non-Persistent Queues, Creating, ADQ 9-27

non-persistent queues, use of, ADQ 6-3

nonprefixed indexes, SCN 11-30, SCN 11-34

global partitioned indexes, SCN 11-32

nonrepeatable reads, SCN 213, SCN 221

nonscalar datatypes, SUT 5-93

nonschema objects

list of, SQL 2-69

namespaces, SQL 2-74

non-shared locations, PSG B-10

non-uniform disk access, PSC 2-6

non-uniform memory access

definition of, PSC 2-3

nonunique indexes, SCN 10-24

no-op

definition, OCI 16-22

noop()

function of UTL_SMTP, SPR 65-12

NOORDER clause

of ALTER SEQUENCE. See CREATE SEQUENCE

of CREATE SEQUENCE, SQL 7-374

NOORDER option, CREATE SEQUENCE, PSC 8-14

NOPARALLEL attribute, DWG 18-48

NOPARALLEL clause

of CREATE CLUSTER, SQL 7-258

of CREATE INDEX, SQL 7-304

of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG, SQL 7-336

of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-323

of CREATE TABLE, SQL 7-405

NOPARALLEL hint, SQL 2-67, STU 7-26

NOPARALLEL_INDEX hint, SQL 2-67, STU 7-30

NORELY clause

of constraint_clause, SQL 7-244

NORESETLOGS clause

of CREATE CONTROLFILE, SQL 7-265

NORESETLOGS option

ALTER DATABASE statement

backing up control file, SBR 4-16

NOREVERSE clause for indexes, SCN 10-33

NOREWRITE hint, DWG 19-5, DWG 19-28, SQL 2-65, STU 7-18

NORMAL - oracle.jms.AQjmsConstants.NORMAL, JPR 2-55

normal mode, running directory servers in, OID F-5

normal transmission mode

definition, SAD 7-14

normalization

of pre-8.1.6 control file on NT, RMN 10-123

normalize() - oracle.xml.parser.v2.XMLElement.normalize(), JPR 4-98

normalized tables, SCN 1-28, SCN 10-20

normalizing data during a load

SQL*Loader, SUT 4-19

NOSORT clause, STU 20-38, STU 20-39

of ALTER INDEX, SQL 7-300

of constraint_clause, SQL 7-244

NOT, STU 4-68

NOT DEFERRABLE clause

of constraint_clause, SQL 7-243

NOT FOUND condition

in the WHENEVER statement, PC_ 9-24

meaning of, PC_ 9-24

of WHENEVER directive, PC_ F-119, PCO 8-16, PCO F-93

NOT IDENTIFIED clause

of ALTER ROLE. See CREATE ROLE

of CREATE ROLE, SQL 7-366

NOT IN operator, SQL 3-7

NOT IN subquery, STU 4-61

NOT logical operator

treatment of nulls, PLS 2-50

NOT NULL clause

of constraint_clause, SQL 7-239

of CREATE TABLE, SQL 7-393

NOT NULL constraint

CHECK constraint and, ADG 4-16

data integrity, ADG 4-20

effect on %TYPE declaration, PLS 2-33

effect on performance, PLS 5-67

Import, SUT 2-45

load method, SUT 8-9

restriction, PLS 5-7, PLS 7-4

using in collection declaration, PLS 4-6

using in field declaration, PLS 4-44

using in variable declaration, PLS 2-32

when to use, ADG 4-3

NOT NULL constraints, SQL 7-239

constraint checking, SCN 273

defined, SCN 257

implied by PRIMARY KEY, SCN 262

UNIQUE keys and, SCN 261

not null constraints, SQL 7-239

not null filter, in Oracle Directory Manager, OID 6-9

NOT operator, SQL 3-11

NOT_LOGGED_ON exception, PLS 6-5

notation

conventions, DCI clix, PC_ xvi

mixed, PLS 7-13

positional versus named, PLS 7-13

rules for, DCI clix, PC_ xvi

NOTATION - oracle.xml.parser.v2.AttrDecl.NOTATION, JPR 4-7

notation used in this manual, PCO cxxv

Notation, BNF, PC_ xvi

NotationDecl - oracle.xml.parser.v2.XMLToken.NotationDecl, JPR 4-138

%NOTFOUND cursor attribute, PLS 5-36

notification log table

conflicts

creating, RAR B-6

sample, RAR B-7

notification methods

user-defined, RAR B-6

notification package

conflicts

creating, RAR B-7

Notifications, Asynchronous, ADQ 8-77

notifyConsumer(Hashtable, MessageListener) - oracle.jms.AQjmsConsumer.notifyConsumer(java.util.Hashtable, javax.jms.MessageListener), JPR 2-60

notifySession(Hashtable) - oracle.jms.AQjmsSession.notifySession(java.util.Hashtable), JPR 2-181

NOVALIDATE constraints, SCN 276

Novell Directory Services external naming, NET 2-37, NET 2-39, NET 8-20

configuring, NET 6-79

connecting with, NET 6-83

described, NET 4-24

establishing a connection with, NET 6-83

Novell's NetWare Management System, DDS 1-32, SCN 403

NOWAIT clause

of LOCK TABLE, SQL 7-548

NOWAIT option, ADG 7-12

NOWAIT parameter, PCO 3-23, PLS 5-48

effect of, PC_ 3-25

in LOCK TABLE statements, PC_ 3-25

omitting, PC_ 3-25

using in LOCK TABLE statement, PCO 3-23

NPI, NET 3-9

NPL, SMS 29-1

NS layer, NET 3-8

NSName - oracle.xml.parser.v2.NSName, JPR 4-38

nsr_shutdown command, LEG 5-15

NSResolver - oracle.xml.parser.v2.NSResolver, JPR 4-41

NS.SMD record, NET 11-14, NET A-42

NSTANCE_GROUPS parameter, PSA 2-5

NT performance, STU 23-6

NT Performance Monitor, OID 13-2

NT Task Manager, OID 13-2

nterface - javax.jms.Destination, ADQ B-26

n-tier authentication, ADG 11-64, ADG 11-65, ADG 11-66

n-tier authentication and authorization

compatibility, MIG 9-12

NTILE function, DWG 17-33, SQL 4-61

NVARCHAR2 datatype, PLS 2-21

NVL function

treatment of nulls, PLS 2-51

null, SQL 2-54

difference from zero, SQL 2-54

in conditions, SQL 2-55

table of, SQL 2-55

in functions, SQL 2-54

with comparison operators, SQL 2-55

NULL clause

of constraint_clause, SQL 7-239

null columns

at end of record, SUT 5-81

NULL conditions, SQL 5-18

null data

missing columns at end of record during load, SUT 5-43

unspecified columns and SQL*Loader, SUT 5-47

null handling, PLS 2-49

in dynamic SQL, PLS 10-13

null indicator struct, OCI 10-29

generated by OTT, OCI 10-9

null lock mode, PSC 4-12

null refresh, REP A-2

NULL statement, PLS 3-19

syntax, PLS 11-109

using in a procedure, PLS 7-4

NULL values

objects, SUT 5-93

null values, in attributes, OID 6-2

NULLIF clause

SQL*Loader, SUT 5-44, SUT 5-81, SUT 5-82

NULLIF...BLANKS clause

example, SUT 4-25

SQL*Loader, SUT 5-46

nullity, PLS 2-46

nullness

atomic, OCI 10-29

of objects, OCI 10-29

NULLs

definition, PCO 2-7

definition of, PC_ 2-6

detecting, OCI 2-33, PC_ 6-4, PCO 4-23, PCO 5-4

handling

in dynamic SQL method 4, PCO 11-21

indicator variables, PCO 6-2

handling in dynamic SQL method 4, PC_ 15-17

hardcoding, PC_ 6-4, PCO 5-4

inserting, OCI 2-33, PC_ 6-4, PCO 5-4

inserting into database, OCI 2-32

inserting using indicator variables, OCI 2-32

meaning in SQL (NVL function), PCO 2-17

restrictions, PCO 5-6

restrictions on, PC_ 6-5

retrieving, PCO 5-5

returning, PC_ 6-5

SQLNUL subroutine, PCO 11-21

testing for, PC_ 6-5, PCO 5-6

using the sqlnul() function to test for, PC_ 15-18

nulls

as default values, SCN 10-9

atomic, ADO 2-2, SUT 5-94

attribute, SUT 5-93

column order and, SCN 10-8

converting to values, SCN 10-9

optimization, STU 4-86

defined, SCN 10-8

foreign keys and, SCN 265, SCN 266

how stored, SCN 10-8

indexes and, DWG 6-5, SCN 10-9, SCN 10-25, SCN 10-38

inequality in UNIQUE key, SCN 261

non-null values for, SCN 10-9, STU 4-86

object types, ADO 2-2

partitioned tables and indexes, SCN 11-20

prohibited in primary keys, SCN 261

prohibiting, SCN 257

UNIQUE key constraints and, SCN 261

unknown in comparisons, SCN 10-9

NULLs in SQL

how to detect, PCO 2-17

null-terminated strings, PC_ 4-7

NUM_DISTINCT column

USER_TAB_COLUMNS view, STU 4-26

NUM_ROWS column

USER_TABLES view, STU 4-26

NUMA

definition of, PSC 2-3

NUMBER

external datatype, OCI 3-10

NUMBER datatype, ADG 3-7, PC_ 4-5, PLS 2-13, SCN 12-8, SQL 2-17

converting to VARCHAR2, SQL 2-40

internal format of, SCN 12-9

precision, SQL 2-17

rounding, SCN 12-9

scale, SQL 2-17

SQL*Loader, SUT 5-70

using the SQLPRC subroutine with, PCO 11-20

using the sqlprc() function with, PC_ 15-16

number format models, SQL 2-40

number functions, SQL 4-4

number generator, PSC 8-13

number of nines

metric for measuring availability, PSC 9-3

Number of Rows Processed data view, STU 14-12

numbers

comparison rules, SQL 2-32

floating-point, SQL 2-17, SQL 2-19

in SQL syntax, SQL 2-4

precision of, SQL 2-4

rounding, SQL 2-18

spelling out, SQL 2-51

syntax of, SQL 2-4

numeric

formats, NLS 2-21, NLS 4-11

parameters, NLS 2-21

NUMERIC datatype (ANSI), SQL 2-28

numeric expressions

cannot serve as host variables, PC_ 4-16

numeric EXTERNAL datatypes

delimited form and SQL*Loader, SUT 5-70

determining length, SUT 5-73

SQL*Loader, SUT 5-67

numeric fields

precision versus length, SUT 5-16

numeric group separators, SRF 1-78

NUMERIC keyword

behavior in Oracle7 and Oracle8i, MIG 9-23

numeric literals, PLS 2-7

NUMERIC subtype, PLS 2-14

NUMTODSINTERVAL function, SQL 4-62

NUMTOYMINTERVAL function, SQL 4-63

NVARCHAR2 datatype, ADG 3-2, ADG 3-5, SCN 12-7, SQL 2-16

NVL function, SCN 10-9, SQL 4-64

for retrieving NULL values, PCO 2-17

NVL2 function, SQL 4-65

nwadmin command, LEG 2-11

n-way replication. See multimaster replication

NZE, SMS 33-1