Oracle8i Generic Documentation Master Index
Release 2 (8.1.6)

A76991-01

Library

Product

Contents

Prev Up Next

Oracle8i Generic Documentation Master Index


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

Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents