Oracle8
i
Generic Documentation Master Index
Release 8.1.5
A68826-01
Library
Product
Contents
Index
N
N variable in SQLDA
how value is set, PC_ 15-7
purpose of, PC_ 15-7
name
cursor, PLS 5-7
qualified, PLS 2-35
savepoint, PLS 5-44
variable, PLS 2-36
name attribute, server resource, LEG 2-25
NAME column
SYS.INCEXP table, SUT 1-51
name registration, DCI 2-10
name resolution, ADG 3 - 46,
LEG B-9,
PLS 2-36,
PLS D-1
in distributed databases, DDS 1-6
name resolution for procedures, SCN 18-19
name resolution in distributed databases, SCN 33-6
name translation for RMAN commands, SBR 4-6
NAMED clause
of CREATE JAVA, SQL 7-294
named datatypes
binding, OCI 5-10,
OCI 12-2
binding and defining, OCI 12-6
defining, OCI 5-16,
OCI 12-4
definition, OCI 3-18
external datatypes, OCI 3-18
indicator variable for, OCI 2-31
indicator variables, OCI 2-33
named notation, PLS 7-13
Named Pipes
described, NET 4-26
parameters for addresses, NET 6-78
named user licensing, SCN 29-21
named user limits, SAD 23-5
setting initially, SAD 2-13
NAMES, PSC 4-32
names, LSM administrators, LEG 2-27
NAMES_DIRECTORY_PATH parameter, NET 6-9,
NET 6-19,
NET 6-54,
NET 6-57,
NET 6-60,
PSC 4-32
NAMES.ADDRESSES parameter, NET 6-28,
NET 6-33,
NET C-65
NAMES.ADMIN_REGION parameter, NET 5-25,
NET 6-28,
NET C-66
NAMES.AUTHORITY_REQUIRED parameter, NET C-66
NAMES.AUTO_REFRESH_EXPIRE parameter, NET C-67
NAMES.AUTO_REFRESH_RETRY parameter, NET C-67
NAMES.CACHE_CHECKPOINT_FILE parameter, NET C-68
NAMES.CACHE_CHECKPOINT_INTERVAL parameter, NET C-68
NAMES.CONFIG_CHECKPOINT_FILE parameter, NET C-68
NAMES.CONNECT_TIMEOUT parameter, NET C-67
NAMESCTL
see Oracle Names Control Utility
NAMESCTL.INTERNAL_ENCRYPT_PASSWORD parameter, NET C-13
NAMESCTL.INTERNAL_USE parameter, NET C-13
NAMESCTL.NO_INITIAL_SERVER parameter, NET C-13
NAMESCTL.NOCONFIRM parameter, NET C-13
NAMESCTL.SERVER_PASSWORD parameter, NET C-14
NAMESCTL.TRACE_DIRECTORY parameter, NET C-14
NAMESCTL.TRACE_FILE parameter, NET C-14
NAMESCTL.TRACE_LEVEL parameter, NET C-14
NAMESCTL.TRACE_UNIQUE parameter, NET C-15
NAMES.DCE.PREFIX parameter, NET C-9,
NET C-12
NAMES.DEFAULT_DOMAIN parameter, NET 6-15,
NET 6-39,
NET 7-16
NAMES.DEFAULT_FORWARDERS parameter, NET C-69
NAMES.DEFAULT_FORWARDERS_ONLY parameter, NET C-69
NAMES.DEFAULT_ZONE parameter, NET 5-4
NAMES.DEFAULT.DOMAIN parameter, NET C-9
NAMES.DIRECTORY_PATH parameter, NET C-10
CDS, NET 7-19
HOSTNAME, NET 7-19
NDS, NET 7-19
NIS, NET 7-19
ONAMES, NET 7-19
TNSNAMES, NET 7-19
NAMES.DOMAIN_CHECKPOINT FILE parameter, NET 4-20
NAMES.DOMAIN_HINTS parameter, NET C-69
NAMES.DOMAINS parameter, NET 6-29,
NET 6-30,
NET 6-34,
NET C-70
NAMES.FORWARDING_AVAILABLE parameter, NET C-70
NAMES.FORWARDING_DESIRED parameter, NET C-70
NAMESINI, NET 6-26
NAMESINI.SQL script, NET 5-24,
NET 6-26
NAMES.INITIAL_RETRY_ TIMEOUT parameter, NET 6-39
NAMES.INITIAL_RETRY_TIMEOUT parameter, NET C-10
NAMES.KEEP_DB_OPEN parameter, NET C-70
NAMES.LOG file contents, NET 11-18
NAMES.LOG_DIRECTORY parameter, NET 11-21,
NET C-71
NAMES.LOG_FILE parameter, NET 11-21,
NET C-71
NAMES.LOG_STATS_INTERVAL parameter, NET C-71
NAMES.LOG_UNIQUE parameter, NET C-71
NAMES.MAX_OPEN_ CONNECTIONS parameter, NET 6-39
NAMES.MAX_OPEN_CONNECTIONS parameter, NET C-72
NAMES.MAX_REFORWARDS parameter, NET C-72
NAMES.MESSAGE_POOL_ START_SIZE parameter, NET 6-39
NAMES.MESSAGE_POOL_START_SIZE parameter, NET C-11,
NET C-72
NAMES.NO_MODIFY_RESPONSE parameter, NET C-73
NAMES.NO_REGION_DATABASE parameter, NET C-73
NAMES.ORA
see Oracle Names servers, configuration file
NAMESPACE column
V$LIBRARYCACHE table, STU 19-13
namespaces
and object naming rules, SQL 2-68
for nonschema objects, SQL 2-69
for schema objects, SQL 2-68,
SQL 2-69
reserved by Oracle, PCO C-4
NAMES.PASSWORDS parameter, NET C-73
NAMES.PREFERRED_SERVERS parameter, NET 7-21,
NET C-12
NAMES.REGION_CHECKPOINT_FILE parameter, NET C-73
NAMES.REQUEST_RETRIES parameter, NET 6-39,
NET C-12
NAMES.RESET_STATS_INTERVAL parameter, NET C-74
NAMES.SAVE_CONFIG_ON_STOP parameter, NET C-74
NAMES.SERVER_NAME parameter, NET 6-28,
NET 6-33
NAMES.SERVER_NAMES parameter, NET C-74
NAMES.TOPOLOGY_CHECKPOINT_FILE parameter, NET 4-20
NAMES.TRACE_DIRECTORY parameter, NET 11-37,
NET C-74
NAMES.TRACE_FILE parameter, NET 11-37,
NET C-75
NAMES.TRACE_FUNC parameter, NET C-75
NAMES.TRACE_LEVEL parameter, NET C-75
NAMES.TRACE_UNIQUE parameter, NET 11-37,
NET C-75
NAMES.TRC file contents, NET 11-32
NAMESUPG.SQL script, NET 5-23,
NET 6-26
NAMESUPG.SQL script for Oracle Names, NET 5-27
NAMES.USE_PLUG_AND_PLAY parameter, NET 4-20
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, SBR 4-31
naming conventions, DCI 2-8,
PLS 2-35
configuration files, DCI 2-7
cursor, PCO 5-13
default database, PCO 3-4
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
SQL*Forms user exit, PCO 12-13
naming database objects, NLS 3-14
naming methods
centralized naming, NET 3-5
choosing, NET 3-8
configuring with the Net8 Configuration Assistant, NET 4-23
described, NET 1-4,
NET 3-3
external naming, NET 1-4,
NET 3-6,
NET 4-31,
NET 6-5,
NET 6-51,
NET 7-19
host naming, NET 3-3,
NET 6-5,
NET 6-7,
NET 7-19
local naming, NET 1-4,
NET 3-5,
NET 6-5,
NET 6-12,
NET 7-19
Oracle Names, NET 1-4,
NET 3-5,
NET 6-5,
NET 6-21,
NET 7-19
prioritizing order, NET 7-18
naming model
hierarchical, NET 2-38
single domain, NET 2-37
naming methods
host naming, NET 1-4
NATIONAL CHAR datatype (ANSI), SQL 2-24
NATIONAL CHAR VARYING datatype (ANSI), SQL 2-24
NATIONAL CHARACTER datatype (ANSI), SQL 2-24
national character set, PLS 2-19
fixed vs. variable width, SQL 2-11,
SQL 2-12
in Oracle8
i
, MIG 8-27
multibyte character data, SQL 2-21
multibyte character sets, SQL 2-11,
SQL 2-12
parameter, NLS 2-29
variable-length strings, SQL 2-12
NATIONAL CHARACTER SET clause
of CREATE DATABASE, SQL 7-253
NATIONAL CHARACTER SET parameter
of ALTER DATABASE, SQL 7-16
NATIONAL CHARACTER VARYING datatype
ANSI, SQL 2-24
National Language Support
SQL*Loader, SUT 5-30
national language support, GTK 2-43
NCLOBs, ADL 1-2,
SPR 17 - 3
National Language Support (NLS), PC_ 4-48,
PCO 4-39,
PLS 2-19
architecture, NLS 1-1
calendars, NLS A-19,
NLS A-20
character sets for, SCN 12-6
CHECK constraints and, SCN 28-18
clients and servers may diverge, DDS 1-20,
SCN 33-20
DATE datatype and partitions, SCN 11-14,
SCN 11-21
Export, SUT 1-53
Import, SUT 2-55
linguistic definitions, NLS A-16,
NLS A-17
NCHAR and NVARCHAR2 datatypes, SCN 12-6
NCLOB datatype, SCN 12-13
NLS Configuration Utility, NLS B-16
NLS Data Installation Utility, NLS B-12
NLS_LANGUAGE parameter, NLS 2-6,
NLS 4-4
parameters, SCN 5-5
views and, SCN 10-14
national language support (NLS), DCI 2-12
national language support.
See
NLS.
NATIVE
value of DBMS option, PC_ 10-16
native authentication on Windows NT, GTK 2-77
native datatypes
and SQL*Loader, SUT 5-59
conflicting length specifications
SQL*Loader, SUT 5-69
native dynamic SQL
advantages of, ADG 9 - 13
compatibility, MIG 8-14
differences with DBMS_SQL package, ADG 9 - 12
fetching into records, ADG 9 - 16
interoperability, MIG 8-30
performance, ADG 9 - 15
See Also
dynamic SQL
user-defined types, ADG 9 - 16
native dynamic SQL. See dynamic SQL
native hash arithmetic execute statistic, SRF C-12
native hash arithmetic fail statistic, SRF C-12
native interface, PC_ 5-55,
PCO 3-32
NATURAL subtype, PLS 2-12
NATURALN subtype, PLS 2-12
navigation, OCI 13-17
navigational access sample program, PC_ 17-24
navigational functions
error codes, OCI 16-6
return values, OCI 16-5
terminology, OCI 16-4
Navigator window
Oracle Parallel Server folder, PSC 6-14
Oracle Parallel Server objects, PSC 6-14
Parallel Server Instances folder, PSC 6-16
right-mouse menu, PSC 6-17,
PSC 6-24
Connect, PSC 6-17
Disconnect, PSC 6-17
Edit, PSC 6-17,
PSC 6-27
Related Tools, PSC 6-17
Remove, PSC 6-17
Results, PSC 6-17
Shutdown, PSC 6-17,
PSC 6-21
Startup, PSC 6-17,
PSC 6-18
starting Oracle Parallel Server database, PSC 6-18
stopping Oracle Parallel Server database, PSC 6-21
viewing Oracle Parallel Server status, PSC 6-27
viewing shutdown results, PSC 6-24
viewing startup results, PSC 6-24
NCHAR
compatibility, MIG 8-27
interoperability, MIG 8-27
issues, OCI 5-26
migration, MIG 8-27
use in Oracle8
i
, MIG 8-27
NCHAR and NLS environment variables
compatibility, MIG 8-28
NCHAR data
Export, SUT 1-54
NCHAR datatype, ADG 4 - 2,
ADG 4 - 5,
GTK 3-15,
PLS 2-19,
SCN 12-6,
SQL 2-11
ANSI, SQL 2-24
NCHAR datatypes
internal, PCO 4-3
NCHAR VARYING datatype (ANSI), SQL 2-24
NCHAR_CS value, PLS 2-29
NCLOB, DCI 6-2
datatype, OCI 3-21
NCLOB datatype, ADL 1-2,
PLS 2-22,
SCN 12-13,
SQL 2-21
transactional support of, SQL 2-21
NCLOB support, REP A-3
NCLOBs
compatibility, MIG 8-25
loading, SUT 5-99
NCR, SMS 32-1
NDS
see NetWare Directory Service
negative numbers
loading, SUT 4-15
negative scale, SQL 2-14
nested addresses, NET 4-11
nested column objects
loading, SUT 5-93
nested files, SRF 1-50
nested loop join, STU 27-3
nested loops joins, SCN 24-2
cost-based optimization, SCN 24-8
NESTED precompiler option, PCO A-3
nested programs, PCO A-7
support for, PCO 2-24
nested query, STU 27-18
nested table
element ordering, OCI 11-21
functions for manipulating, OCI 11-20
manipulating, PLS 4-13
versus index-by table, PLS 4-3
NESTED TABLE clause
of ALTER TABLE, SQL 7-136
of CREATE TABLE, SQL 7-363,
SQL 7-376
nested table types, SQL 2-27
compared with varrays, SQL 2-31
comparison rules, SQL 2-31
creating, SQL 7-413
dropping the body of, SQL 7-482
dropping the specification of, SQL 7-480
modifying, SQL 7-136
nested tables, ADG 18 - 13,
ADG 18 - 16,
PC_ 18-2,
SCN 10-9,
SCN 13-12
changing returned value, SQL 7-136
collection locators, GTK 2-34
compatibility, MIG 8-12,
MIG 8-29
COMPRESS clause, ADG 18 - 18
creating, SQL 7-418
creating indexes on, ADG 18 - 19
creation, PC_ 18-2
data stored in indexed-organized table, GTK 2-34
defining as index-organized tables, SQL 7-136
DML operations on, ADG 18 - 21
exporting, SUT 1-57
consistency and, SUT 1-17
importing, SUT 2-59
in an index-organized table, ADG 18 - 17
indexes, SCN 14-6
index-organized tables, SCN 10-38
key compression, SCN 10-30
INSTEAD OF triggers, SCN 15-5
OCICollIsLocator(), GTK 2-34
querying, ADG 16 - 20
restrictions, SCN 26-30
returning as locators, ADG 16 - 33,
ADG 18 - 20
storage, ADG 16 - 32,
ADG 18 - 16
storage characteristics of, SQL 7-136,
SQL 7-376
triggers on view columns, GTK 2-35
uniqueness in, ADG 16 - 33
updating in views, SCN 15-5
user-specified storage clauses for, GTK 2-34
UTL _COLL package, GTK 2-34
vs VARRAY, ADG 16 - 17,
ADG 16 - 20
NESTED_TABLE_ID, ADG 16 - 32,
ADG 18 - 19
NESTED precompiler option, PCO 14-32
nesting
block, PLS 1-3
FOR loop, PLS 3-14
object, PLS 9-7
record, PLS 4-38
net service names
adding an address, NET 7-3
addresses, resolving, NET 3-3
configure an Oracle Connection Manager address, NET 7-43
configuring, PSC 4-20
configuring CONNECT_DATA, NET 7-7
configuring protocol addresses, NET 6-64
defined, NET 1-3,
NET 2-2
deleting, NET 7-6
deleting protocol address, NET 7-5
described, NET 4-4,
NET 6-2,
PSC 4-12
external naming, NET 1-4,
NET 3-6
host naming, NET 3-3
identifying a service, NET 6-3
local naming, NET 1-4,
NET 3-5
modifying, NET 7-2
multiple addresses, NET 7-3,
NET 7-11
Oracle Names, NET 1-4,
NET 3-5
prioritizing naming methods, NET 7-18
registering with Oracle Names, NET 6-42
renaming, NET 7-3
testing with TNSPING, NET 8-22
Net3 listener, DDS 6-2
Net8, OAS Glossary-5,
GTK 2-64,
GTK 2-71,
NET 2-12,
NET 6-13,
NET 7-58,
SCN 1-7,
SCN 1-37,
SCN 6-5,
SCN 33-4
Advanced Security option, SCN 33-18
applications and, SCN 6-5
automatic instance registration, GTK 2-76
client-server configuration, SPS 1-20
client/server systems use of, SCN 6-5
compatibility with Oracle DCE Integration, NET 7-29
concept described, NET 1-2
concurrent logons, PCO 3-14
connect operations, NET 2-2
connect string, SPS 18-20,
SPS 18-21
connecting to Oracle via, PC_ 3-7
connecting using, PCO 3-13
connection load balancing, MIG 8-47
connection syntax, PC_ 3-6,
PCO 3-13
control utilities, NET 8-15
data operations, NET 2-4
differences from SQL*Net, NET 5-2
distributed database system, SPS 1-18
dynamic (connection) load balancing, GTK 2-76
exception operations, NET 2-4
for concurrent connections, PC_ 3-7
for CONNECT, SPS 18-17
for SET INSTANCE, SPS 18-17
function of, PC_ 3-6,
PCO 3-13
in stack communications, NET 2-12
installing, NET 4-21
JDBC drivers, NET 2-16
migrating or upgrading to, MIG 6-4,
MIG 8-46
multi-threaded server requirement, SCN 8-14,
SCN 8-16
native authentication on Windows NT, GTK 2-77
Net8 Assistant, GTK 2-75
Net8 Easy Config, GTK 2-75
operations, NET 2-4
overview, NET 1-2
overview of, SCN 6-5
primary functions, NET 2-4
service names in, SAD 7-15
service naming, GTK 2-75,
MIG 8-47
downgrading, MIG 12-41
transmitting archived logs via, SAD 7-15
using ROWID datatype, PCO 4-14
using to connect to Oracle, PCO 3-14
Net8 access control, NET 2-49,
NET 4-30,
NET 7-38
Net8 Assistant, NET 5-28,
NET 6-43,
NET 7-71
adding addresses, NET 7-3
Always Use Dedicated Server option, NET 7-26
Attempts Per Names Server option, NET 6-39
Client Registration ID option, NET 7-23
configure static listener information, NET 6-71
configuring a listener name, NET 6-69
configuring a non-default listener in Oracle Names, NET 6-68,
NET 7-62
configuring advanced profile options, NET 7-23
configuring an Oracle Rdb Database, NET 7-72
configuring client for Oracle Connection Manager, NET 7-43,
NET 7-46
configuring client load balancing, NET 7-11
configuring client profiles, NET 7-15
configuring CONNECT_DATA, NET 7-8
configuring domains, NET 7-16
configuring external procedures, NET 7-65
configuring failover, NET 7-11
configuring for a release 8.0 service, NET 5-14
configuring for a release 8.1 service, NET 5-12
configuring Heterogeneous Services, NET 7-67
configuring local naming method, NET 6-14
configuring log files, NET 11-23
configuring multiple domains for an Oracle Names server, NET 6-29,
NET 6-34
configuring net service names, NET 6-14
configuring net service names for each instance, PSC 4-20
configuring net service names for the database, PSC 4-25
configuring net service names for Windows NT, PSC 4-29
configuring Oracle Advanced Security, NET 7-28,
NET 7-29
configuring Oracle Names in a region database environment, NET 6-27
configuring Oracle8 database for Heterogeneous Services, NET 7-67,
NET 7-72
configuring preferred Oracle Names servers
Oracle Names servers
preferred, NET 7-20
configuring prespawned dedicated servers, NET 6-74
configuring protocol addresses, NET 6-64
configuring the listener, PSC 4-16
configuring the listener for failover, PSC 4-37
configuring the listener for IIOP clients, NET 7-58
configuring the listener with service information, NET 6-72
configuring trace files, NET 11-38
Default Domain option, NET 6-39
delegating domains to administrative regions, NET 6-50
deleting protocol addresses, NET 7-5
described, NET 4-29,
NET 5-2
Disable Out-of-Band Break option, NET 7-24
discovering Oracle Names servers, NET 6-36,
NET 6-37
enabling client load balancing, PSC 4-25
Global Database Name option, NET 6-71,
NET 7-8,
NET 7-71
Handler Name option, NET 7-7
Initial Preallocated Requests option, NET 6-39
Instance Name option, NET 7-7
loading TNSNAMES.ORA data into Oracle Names server, NET 5-25
loading TNSNAMES.ORA file into Oracle Names, NET 5-25
Maximum Open Connections option, NET 6-39
Maximum Prespawned Servers option, NET 6-73
Maximum Wait Each Attempt option, NET 6-39
migrating TNSNAMES.ORA file, NET 5-11
migrating TNSNAMES.ORA files, NET 5-11
multiple address options, NET 7-11
Oracle Home option, NET 7-69
Oracle RDB Database option, NET 7-8
Prefer Connection Manager Routing option, NET 7-26
prioritizing naming methods, NET 7-18
Program Name option, NET 7-69
RDB Database option, NET 7-71
Register Service with Oracle Names option, NET 6-40
registering aliases with Oracle Names, NET 6-49
registering global database links with Oracle Names, NET 6-45
registering net service names with Oracle Names, NET 6-42
routing connection requests, NET 7-26
Session Data Unit (SDU) option, NET 7-7
setting advanced connection options, NET 7-8
SID option, NET 7-69
starting, NET 4-29
starting an Oracle Names server, NET 6-31,
NET 6-36,
NET 8-3
testing network objects, NET 8-17
Timeout option, NET 6-74
TNS Time Out Value option, NET 7-23
Turn Off UNIX Signal Handling option, NET 7-24
Type of Service option, NET 7-8
upgrading TNSNAMES.ORA file, NET 5-11
Use Dedicated Server option, NET 7-7
Use for Heterogeneous Services option, NET 7-7
Use Options Compatible with Net8 8.0 Clients option, NET 5-11
Use Oracle8i Release 8.0 Compatible Identification option, NET 5-11
verifying connectivity, NET 8-25
Net8 Client
described, NET 4-24,
NET 4-25
installing, NET 4-24
Net8 Configuration Assistant, NET 4-28
automatically running as a part of installation, PSC 3-6
configuring local naming method, NET 6-18
configuring naming methods, NET 4-23
configuring net service names, NET 6-18
configuring the listener, NET 4-22
configuring the local naming method, NET 6-13
deleting net service names, NET 7-6
described, NET 4-5,
NET 4-28,
NET 5-2
modifying net service name attributes, NET 7-2
renaming net service names, NET 7-3
starting, NET 4-28
using after installation, NET 4-22,
NET 4-24
Net8 Easy Config
described, NET 4-28,
NET 5-2
Net8 Firewall Proxy, NET 2-49
Net8 Listener, DDS 5-5
Net8 Native Authentication, OAS 7-15
Net8 OPEN
API function calls, NET 9-3
compatibility with C language, NET 9-3
configuration requirements, NET 9-8
configuring system to use applications, NET 9-9
error messages, NET 9-12
finding API, NET 9-8
for distributed applications, NET 9-2
integrating with non-SQL information, NET 9-2
library, NET 9-8
sample applications, NET 9-11
Net8 Server
described, NET 4-22,
NET 4-25
installing, NET 4-22
Net8 stack communications
client application, NET 2-10
Oracle protocols, NET 2-12
session, NET 2-12
TTC, NET 2-11,
NET 9-7
Two-Task Common (TTC) presentation, NET 2-11
Netscape Communications Corporation, OAS 9-2
NetWare Directory Service (NDS),
NET 3-6,
NET 6-51,
NET 7-19
NetWare Directory Service (NDS) External Naming
described, NET 4-31
network
array interface, STU 22-2
bandwidth, STU 17-5
communicating over, PC_ 3-6
constraints, STU 17-5
detecting performance problems, STU 22-1
prestarting processes, STU 22-2
problem solving, STU 22-2
protocols, PC_ 3-6
reducing traffic, PC_ C-4
Session Data Unit, STU 22-3,
STU 23-5
tuning, STU 22-1
Network Authentication (NA)
layer in error stacks, NET 11-17
layer in stack communications, NET 2-12
network character set, keyword values, NET C-4
network configuration, PSC 3-6,
PSC C-6,
PSC C-7
additional steps for Windows NT, PSC 4-29
centralized management, NET 6-4
configuring connect-time failover, PSC 4-35
configuring net service names for Windows NT, PSC 4-29
configuring the listener, PSC 4-13
configuring the listener for failover, PSC 4-36
configuring transparent application failover, PSC 4-43
creating net service names, PSC 4-20
enabling client load balancing, PSC 4-25
localized management, NET 6-4
on clients, PSC 4-34
on Console, PSC 5-11
on nodes, PSC 4-12
Oracle Performance Manager machine, PSC 5-29
testing components, PSC 4-45
transparent application failover, PSC 4-35
network configuration file
LISTENER.ORA, PSC 4-13,
PSC 4-36
LISTENER.ORA file
how used for auto-discovery, PSC C-6
SQLNET.ORA, PSC 4-32
TNSNAMES.ORA file
how used for auto-discovery, PSC C-7
network configuration files
LISTENER.ORA, PSC 4-12,
PSC 5-7,
PSC B-9
on clients, PSC 4-34
on Console, PSC 5-11
on nodes, PSC 4-12
on Oracle Performance Manager machine, PSC 5-29
SQLNET.ORA, PSC 4-13
testing, PSC 4-45
TNSNAMES.ORA, PSC 4-13,
PSC 4-20,
PSC 5-7,
PSC 5-11,
PSC 5-29
network connections
minimizing, DDS 2-6
Network Encryption (NAE), layer in error stacks, NET 11-17
Network Information Service (NIS), NET 3-6,
NET 6-51,
NET 7-19
Network Information Service (NIS) External Naming, NET 4-31
Network Interface (NI)
described, NET 2-12
layer in error stacks, NET 11-17
network listener process, SCN 6-6
connection requests, SCN 8-14,
SCN 8-16
dedicated server example, SCN 8-24
multi-threaded server example, SCN 8-20
service names, SCN 6-6
Network Naming (NN)
layer in error stacks, NET 11-17
layer in stack communications, NET 2-12
Network Program Interface (NPI), NET 2-13
network protocol
dispatcher for each, SAD 4-5
Network Routing (NR)
layer in error stacks, NET 11-17
layer in stack communications, NET 2-12
Network Security
DES_40, NET 4-31
DES_56, NET 4-31
described, NET 4-31
MD5, NET 4-31
RC4_128, NET 4-31
RC4_40, NET 4-31
RC4_56, NET 4-31
Network Services (NA), layer in error stacks, NET 11-17
Network Session, NET 4-13
Network Session (NS), NET 4-13,
NET C-51
Network Session (NS), layer in error stacks, NET 11-17
network traffic
reducing, PLS 1-22
Network Transport (NT), layer in error stacks, NET 11-17
network usage, SPS 19-3
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
networks
client/server architecture use of, SCN 6-2
communicating over, PCO 3-13
communication protocols, SCN 6-5,
SCN 8-26
dispatcher processes and, SCN 8-14,
SCN 8-16
distributed databases, SCN 33-4
distributed databases use of', DDS 1-2,
SCN 33-2
drivers, SCN 8-26
Export, SUT 1-52
failures of, SCN 32-3
Import and, SUT 2-50
listener processes of, SCN 6-6,
SCN 8-14
Net8, SCN 6-5,
SCN 33-4
network authentication service, SCN 29-4
Oracle Names, SCN 33-4
protocols, PCO 3-13
reducing traffic, PCO D-4
transporting Export files across a network, SUT 1-52
two-task mode and, SCN 8-23
using Oracle on, SCN 1-7,
SCN 1-37
NEVER REFRESH mode
materialized views and downgrading, MIG 12-10
NEW correlation name, ADG 13 - 16
new features, OCI 1-12
benefits, OCI 1-12
data subsetting and subqueries, REP A-3
enhanced security, REP A-4
for management and use, REP A-3
introduction, OCI 1-12
LOB support, REP A-3
performance, REP A-2
subqueries for snapshots, REP A-3
subquery snapshots, REP A-3
new features of Oracle8
i
adding after migration, MIG 6-7
New Master Site dialog
setup wizard, REP 2-8
NEW_DBNAME
Migration utility option, MIG 3-14
NEW_TIME function, SQL 4-25
newname for datafile option (RMAN)
set command, SBR 9-9
NEXT clause
of ALTER MATERIALIZED VIEW...REFRESH, SQL 7-50
NEXT collection method, PLS 4-23
Next Date setting
Create New Scheduled Link property sheet, REP 2-12
Setup wizard, REP 2-16
NEXT extent, STU 27-13
NEXT parameter
of STORAGE clause, SQL 7-577
next scns gotten without going to DLM statistic, SRF C-12
NEXT storage parameter, SAD 12-8,
SPS 6-8,
SPS 21-4
parallel direct-load INSERT, SCN 25-9
calculating value, SCN 25-9
setting for the data dictionary, SAD 20-27
NEXT_DAY function, SQL 4-26
NEXTVAL pseudo-column, ADG 3 - 38
restrictions, ADG 3 - 39
NEXTVAL pseudocolumn, PLS 5-3,
SQL 2-51,
SQL 7-350
NEXTVAL pseudocolumns, PCO 4-7
NFS, SPS 5-9,
SPS 23-4,
SPS 23-9
NI
see Network Interface (NI)
nibble, PLS 2-29
nibbles, PCO 4-53
NIS
see Network Information Service
NIS Maps, NET 6-52
NLS
compatibility, MIG 8-27
interoperability, MIG 8-27
migration, MIG 8-27
OCI functions, OCI 2-3
See
National Language Support (NLS)
See
National Language Support
NLS (National Language Support), PC_ 4-48,
PC_ A-2,
PCO 4-39,
PLS 2-19
multi-byte character strings, PCO 4-41
NLS (national language support), DCI 2-12
NLS and NCHAR environment variables
compatibility, MIG 8-28
NLS Calendar Utility, NLS B-11
NLS data
error messages, NLS A-4
obsolete, NLS C-1
supported calendar systems, NLS A-19
supported linguistic definitions, NLS A-17
supported storage character sets, NLS A-7
supported territories, NLS A-5
NLS Data Installation Utility, NLS B-12
NLS datatype, PLS 2-19
NLS parameter
NLS_CURRENCY, PC_ 4-48,
PCO 4-39
NLS_DATE_FORMAT, PC_ 4-48,
PCO 4-39
NLS_DATE_LANGUAGE, PC_ 4-48,
PCO 4-39
NLS_ISO_CURRENCY, PC_ 4-48,
PCO 4-39
NLS_LANG, PC_ 4-49,
PCO 4-40
NLS_LANGUAGE, PC_ 4-48,
PCO 4-39
NLS_NUMERIC_CHARACTERS, PC_ 4-48,
PCO 4-39
NLS_SORT, PC_ 4-48,
PCO 4-39
NLS_TERRITORY, PC_ 4-48,
PCO 4-39
NLS parameters
using in SQL functions, NLS 4-1
NLS_* parameters, PSC 6-10,
SPS 18-10
NLS_CALENDAR parameter, NLS 2-6,
NLS 2-8,
NLS 2-11,
NLS 2-14,
NLS 2-17,
NLS 2-19,
NLS 2-20,
NLS 2-21,
NLS 2-22,
NLS 2-27,
NLS 2-28,
SRF 1-76
of ALTER SESSION, SQL 7-84
NLS_CHAR precompiler option, PC_ 10-32
NLS_CHARSET_DECL_LEN function, NLS 4-6,
SQL 4-27
NLS_CHARSET_ID function, NLS 4-5,
PLS 2-29,
SQL 4-27
NLS_CHARSET_NAME function, NLS 4-5,
PLS 2-29,
SQL 4-28
NLS_COMP, NLS 4-8
NLS_COMP parameter, NLS 2-28,
SRF 1-77
of ALTER SESSION, SQL 7-84
NLS_CREDIT environment variable, NLS 2-24
NLS_CREDIT parameter, NLS 2-20,
NLS 2-24
NLS_CURRENCY parameter, NLS 2-20,
SRF 1-78
defined by NLS_TERRITORY, SRF 1-83
of ALTER SESSION, SQL 7-84
NLS_DATABASE_PARAMETERS view, SRF 2-173
NLS_DATE_FORMAT environment variable, SBR 5-2,
SBR 8-19,
SBR 9-24
NLS_DATE_FORMAT parameter, ADG 4 - 8,
DDS A-9,
NLS 2-11,
SCN 12-10,
SRF 1-78
defined by NLS_NUMERIC_CHARACTERS, SRF 1-83
defined by NLS_TERRITORY, SRF 1-83
of ALTER SESSION, SQL 7-84
NLS_DATE_LANGUAGE parameter, DDS A-11,
NLS 2-14,
SQL 2-43,
SRF 1-79
of ALTER SESSION, SQL 7-84
NLS_DEBIT parameter, NLS 2-24
NLS_DUAL_CURRENCY parameter, NLS 2-22
NLS_INITCAP function, SQL 4-29
NLS_INSTANCE_PARAMETERS view, SRF 2-173
NLS_ISO_CURRENCY parameter, NLS 2-21,
SRF 1-80
defined by NLS_TERRITORY, SRF 1-83
of ALTER SESSION, SQL 7-84
NLS_LANG, NLS 2-3,
SUT 2-55
environment variable and SQL*Loader, SUT 5-30
NLS_LANG environment variable, NLS 2-4,
NLS 3-16,
SBR 5-2,
SBR 8-19,
SBR 9-24,
SCN 11-20
compatibility, MIG 8-28
Export, SUT 1-53
Import, SUT 2-56
NLS_LANG examples, NLS 2-5
NLS_LANG, specifying, NLS 2-5
NLS_LANGUAGE parameter, NLS 2-6,
NLS 4-4,
SCN 11-20,
SQL 2-43,
SQL 5-20,
SRF 1-80
of ALTER SESSION, SQL 7-85
NLS_LIST_SEPARATOR parameter, NLS 2-29
NLS_LOCAL
precompiler option, PCO 14-32
NLS_LOCAL precompiler option, PC_ 10-32
NLS_LOWER function, SQL 4-29
NLS_MONETARY_CHARACTERS parameter, NLS 2-23
NLS_NCHAR
Migration utility option, MIG 3-14
NLS_NCHAR environment variable, NLS 3-16
NLS_NCHAR parameter, NLS 2-29
NLS_NUMERIC_ CHARACTERS parameter, NLS 2-19
NLS_NUMERIC_CHARACTERS parameter, NLS 2-20,
SCN 12-9,
SRF 1-81
of ALTER SESSION, SQL 7-85
NLS_SESSION_PARAMETERS view, SRF 2-174
NLS_SORT parameter, NLS 2-27,
NLS 2-28,
NLS 2-29,
SQL 5-20,
SRF 1-81
no effect on partitioning keys, SCN 11-20
of ALTER SESSION, SQL 7-85
ORDER BY access path, SCN 23-47
NLS_TERRITORY parameter, NLS 2-8,
SQL 2-43,
SRF 1-82
of ALTER SESSION, SQL 7-85
NLS_UNION_CURRENCY parameter, SRF 1-79
of ALTER SESSION, SQL 7-85
NLS_UPPER function, SQL 4-30
NLSDATA (language independent data)
utilities for loading, NLS B-12
NLSSORT function, NLS 4-6,
SQL 4-30
NLSSORT order, and indexes, ADG 6 - 8
NMCBILD.SQL script, NET 5-27
NMCGRNT.SQL script, NET 5-27
NMICONF, PSC C-9,
PSC C-10
NMICONF.LOG file, PSC C-9
NMICONF.LST file, PSC C-10
NMP, SMS 31-1
NNC, SMS 26-1
NNF, SMS 30-1
NNL, SMS 28-1
NNL-00018 error message, NET 6-31
NNL-00024 error message, NET 6-31
NNO, SMS 27-1
no session layer, NET 4-13,
NET 7-55
no work - consistent read gets statistic, SRF C-12
NO_DATA_FOUND
PL/SQL keyword, DDS 4-11
NO_DATA_FOUND exception, PLS 6-5
NO_EXPAND hint, SQL 2-59,
STU 7-50
NO_INDEX hint, SQL 2-59,
STU 7-48
no_merge, DDS 4-8
NO_MERGE hint, SQL 2-62,
STU 7-65
NO_PUSH_JOIN_PRED hint, SQL 2-62,
STU 7-66
NO_SPACE_CHECK
Migration utility option, MIG 3-14
NOAPPEND hint, SQL 2-61,
STU 7-62,
STU 27-23
NOARCHIVELOG clause
of ALTER DATABASE, SQL 7-9,
SQL 7-17
of CREATE CONTROLFILE, SQL 7-248
OF CREATE DATABASE, SQL 7-252
NOARCHIVELOG mode, SCN 32-18,
SPS 14-9,
STU 26-77
archiving, SAD 7-4,
SBR 2-15
backing up, SBR 8-23
backup options, SBR 3-20
changing mode, SPS 14-2,
SPS 14-9,
SPS B-2
creating a database, SPS 14-2,
SPS 14-9,
SRF 1-66
database backups for recovery, SCN 32-24
datafile loss in, SBR 15-2
defined, SCN 32-18
definition, SAD 7-4,
SBR 2-15
disadvantages, SBR 14-17
distributed database backups, SBR 3-22
inconsistent closed backups in, SBR 3-4
LOGGING mode and, SCN 25-5
media failure, SAD 7-4
no hot backups, SAD 7-4
offline backups, SPS 4-6
overview, SBR 1-10,
SCN 1-48
recovery, SBR 14-17
requiring offline backups, SPS 21-3
running in, SAD 7-4,
SBR 2-15
strategies for backups in, SBR 3-16
switching to, SAD 7-7
taking datafiles offline in, SAD 10-8
NOAUDIT command, SCN 16-4
disabling audit options, SAD 25-11
locks, SCN 27-29
privileges, SAD 25-12
schema objects, SAD 25-12
statements, SAD 25-12
NOAUDIT schema_objects statement, SQL 7-525
NOAUDIT sql_statements statement, SQL 7-523
NOCACHE clause
of ALTER MATERIALIZED VIEW, SQL 7-48
of ALTER MATERIALIZED VIEW LOG, SQL 7-56
of ALTER SEQUENCE.
See
CREATE SEQUENCE.
of ALTER TABLE, SQL 7-142
of CREATE CLUSTER, SQL 7-240
of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG, SQL 7-316
of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-303
of CREATE SEQUENCE, SQL 7-351
of CREATE TABLE, SQL 7-383
NOCACHE hint, SQL 2-62,
STU 7-64
NOCACHE option
CREATE SEQUENCE statement, ADG 3 - 41
NOCOMPRESS clause
of ALTER TABLE, SQL 7-134
of CREATE INDEX, SQL 7-282
of CREATE TABLE, SQL 7-373
NOCOPY clause
of CREATE FUNCTION, SQL 7-269
of CREATE PROCEDURE, SQL 7-334
NOCOPY compiler hint, PLS 7-17
restrictions on, PLS 7-19
NOCOPY parameter passing mode, GTK 2-79
compatibility, MIG 8-14
NOCYCLE clause
of ALTER SEQUENCE.
See
CREATE SEQUENCE., SQL 7-76
of CREATE SEQUENCE, SQL 7-351
node, PSC 5-12,
PSC C-4
adding, SPS 17-13,
SPS 23-2
affinity awareness, SPS 21-14
cache coherency, SPS 4-12
current, PC_ 3-7
definition, SPS 1-2
definition of, PC_ 3-6
failure, SPS 1-14,
SPS 1-19,
SPS 22-2
local, SPS 18-6,
SPS 18-8
parallel backup, SPS 21-12
parallel shutdown, SPS 18-26
remote, SPS 18-17,
SPS 18-20
single to cluster, SPS 23-2
node monitoring, PSC 1-6
node#
environ parameter, PSC B-6
node#
inst_init_ora parameter
, PSC B-5
node#
tns_admin parameter, PSC B-5
node, defined, PSC 1-9
node_list parameter, PSC 5-12,
PSC C-4
node_list parameter
, PSC B-5
nodes, NET 2-6
definition of, PCO 3-13
disk affinity in a Parallel Server, SCN 26-48
of distributed databases, SCN 1-35
NOFORCE clause
of CREATE DIMENSION, SQL 7-260
of CREATE JAVA, SQL 7-294
of CREATE VIEW, SQL 7-432
NOLOGGING clause
of ALTER INDEX, SQL 7-36
of ALTER MATERIALIZED VIEW, SQL 7-48
of ALTER MATERIALIZED VIEW LOG, SQL 7-56
of ALTER TABLE, SQL 7-142
of ALTER TABLESPACE, SQL 7-166
of CREATE INDEX, SQL 7-282
of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG, SQL 7-316
of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-303
of CREATE TABLE, SQL 7-371
of CREATE TABLESPACE, SQL 7-395
NOLOGGING mode
direct-load INSERT, SCN 25-5
parallel DDL, SCN 26-31,
SCN 26-32
partitions, SCN 11-58
SQL operations affected by, SCN 25-7
NOLOGGING option, STU 26-71,
STU 26-76,
STU 27-19,
STU 27-21,
STU 27-23
NOMAXVALUE clause
of CREATE SEQUENCE, SQL 7-351
NOMAXVALUE parameter
of ALTER SEQUENCE.
See
CREATE SEQUENCE.
NOMINIMIZE RECORDS PER BLOCK clause
of ALTER TABLE, SQL 7-143
NOMINVALUE
of ALTER SEQUENCE.
See
CREATE SEQUENCE.
NOMINVALUE clause
of CREATE SEQUENCE, SQL 7-351
NOMONITORING clause
of ALTER TABLE, SQL 7-142
of CREATE TABLE, SQL 7-383
NOMOUNT option, SPS 14-3,
SPS 22-11
non-blank-padding semantics, PLS B-3
non-blocking mode, OCI 2-36
example, OCI 2-37
noncumulative incremental backups, SBR 4-40
non-deferred linking, GTK 6-4
NONE clause
of SET ROLE, SQL 7-571
NONE option
STATISTICS Export parameter, SUT 1-23
nonequijoins
defined, SCN 23-3
nonequivilancy tests, SQL 3-6
non-fatal errors
warning messages, SUT 1-39
non-fixed mode, lock element, SPS 9-20
non-PCM lock
dictionary cache lock, SPS 10-5
DML lock, SPS 10-3
enqueue, SPS 7-3
IDLM capacity, SPS 7-6
library cache lock, SPS 10-4
mount lock, SPS 10-5
overview, SPS 10-1
relative number, SPS 7-6
system change number, SPS 10-4
table lock, SPS 10-3
transaction lock, SPS 10-3
types, SPS 7-5
user control, SPS 7-6
non-PCM resources, SPS 16-4
non-persistent queues, SCN 19-10
nonprefixed indexes, SCN 11-31,
SCN 11-35
global partitioned indexes, SCN 11-33
non-queries
passthrough SQL, DDS 7-3
nonrepeatable reads, SCN 27-3,
SCN 27-10
non-scalar datatypes, SUT 5-93
nonschema objects
list of, SQL 2-64
namespaces, SQL 2-69
non-shared locations, PSC B-11
nonunique indexes, SCN 10-22
no-op
definition, OCI 16-22
NOORDER clause
of ALTER SEQUENCE.
See
CREATE SEQUENCE.
of CREATE SEQUENCE, SQL 7-352
NOORDER option, CREATE SEQUENCE, SPS 6-7
NOPARALLEL attribute, STU 27-17
NOPARALLEL clause
of CREATE CLUSTER, SQL 7-240
of CREATE INDEX, SQL 7-286
of CREATE MATERIALIZED VIEW LOG/SNAPSHOT LOG, SQL 7-316
of CREATE MATERIALIZED VIEW/SNAPSHOT, SQL 7-303
of CREATE TABLE, SQL 7-380
NOPARALLEL hint, SQL 2-61,
STU 7-58
NOPARALLEL_INDEX hint, SQL 2-61,
STU 7-63
NORELY clause
of constraint_clause, SQL 7-226
NORESETLOGS clause
of CREATE CONTROLFILE, SQL 7-247
NORESETLOGS option
ALTER DATABASE command
backing up control file, SBR 13-14
NOREVERSE option for indexes, SCN 10-31
NOREWRITE hint, SQL 2-59,
STU 7-51,
STU 31-4,
STU 31-21
normal transmission mode
definition, SAD 7-15
normalized tables, SCN 1-29,
SCN 10-19
star schemas, SCN 24-15
normalizing data during a load
SQL*Loader, SUT 4-19
NOSORT clause
of ALTER INDEX, SQL 7-282
of constraint_clause, SQL 7-227
NOSORT option, STU 20-37,
STU 20-38
NOT, SCN 23-7
NOT DEFERRABLE clause
of constraint_clause, SQL 7-226
NOT FOUND condition, PCO 8-28
in the WHENEVER statement, PC_ 9-24
meaning of, PC_ 9-24
of WHENEVER directive, PC_ F-120,
PCO 8-28,
PCO F-92
NOT IDENTIFIED clause
of ALTER ROLE.
See
CREATE ROLE.
of CREATE ROLE, SQL 7-344
NOT IN operator, SQL 3-7
NOT IN subquery, SCN 24-13
NOT logical operator
treatment of nulls, PLS 2-49
NOT NULL clause
of constraint_clause, SQL 7-222
of CREATE TABLE, SQL 7-369
NOT NULL constraint, SAD 20-19
CHECK constraint and, ADG 5 - 16
data integrity, ADG 5 - 22
effect on %TYPE declaration, PLS 2-32
effect on performance, PLS 5-66
Import, SUT 2-48
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-40
using in variable declaration, PLS 2-31
when to use, ADG 5 - 3
NOT NULL constraints, SQL 7-222
constraint checking, SCN 28-20
defined, SCN 28-7
implied by PRIMARY KEY, SCN 28-12
UNIQUE keys and, SCN 28-11
not null constraints, SQL 7-222
NOT operator, SQL 3-11
NOT_LOGGED_ON exception, PLS 6-5
notation
mixed, PLS 7-13
positional versus named, PLS 7-13
%NOTFOUND cursor attribute, PLS 5-35
notification
methods
custom, for conflict resolution, REP 6-10
using multiple conflict resolution methods for, REP 6-11
notification log
conflict
creating, REP 6-53
notification log table
conflict
sample, REP 6-53
notification methods
user-defined, REP 6-52
notification package
conflict
creating, REP 6-54
NOVALIDATE constraints, SCN 28-22
Novell's NetWare Management System, SCN 33-20
NovellsNetWareManagementSystem', DDS 1-20
NOWAIT clause
of LOCK TABLE, SQL 7-521
NOWAIT option, ADG 8 - 12
NOWAIT parameter, PCO 3-29,
PLS 5-47
effect of, PC_ 3-25
in LOCK TABLE statements, PC_ 3-25
omitting, PC_ 3-25
using in LOCK TABLE statement, PCO 3-29
NPI
see Network Program Interface
NPL, SMS 29-1
NS session, NET 4-13,
NET C-51
nsr_shutdown command, LEG 5-15
NS.SMD record, NET 8-17,
NET A-45
NSTANCE_GROUPS parameter, SPS 18-25
NT performance, STU 24-4
n-tier authentication and authorization
compatibility, MIG 8-13
NVARCHAR2 datatype, PLS 2-20
NVL function
treatment of nulls, PLS 2-50
null, SQL 2-49
difference from zero, SQL 2-49
in conditions, SQL 2-50
