User`s guide

General Variables
B-4 Oracle Database User's Guide
Format:
EXP_CLIB_FILE_IO
=
FALSE
Classification:
USER
Default:
EXP_CLIB_FILE_IO
=
TRUE
B.3.5 IMP_CLIB_FILE_IO
This variable should be set to
FALSE
when you use the
Import
utility to overcome a
problem with the C library functions when an import file is read from tape.
Format:
IMP_CLIB_FILE_IO
=
FALSE
Classification:
USER
Default:
IMP_CLIB_FILE_IO
=
TRUE
B.3.6 NLS_LANG
This variable specifies the default language and character set. For example:
NLS_LANG=GERMAN_GERMANY.D8BS2000
Format:
NLS_LANG
=
language_territory.character-set
Classification:
USER
,
DBA
Default:
NLS_LANG
=
AMERICAN_AMERICA.WE8BS2000
B.3.7 OPS_JID
This variable is used for concatenation with the
OS_AUTHENT_PREFIX
, refer to
initialization parameter. The default value concatenates the value of the parameter
OS_
AUTHENT_PREFIX
with the BS2000 user ID. Using
OPS_JID
, you can specify that the
BS2000 jobname,
/.jobname LOGON..
., is used instead. This is useful when many users
are sharing one BS2000 user ID.
Format:
OPS_JID
=
userid/jobname
Classification:
DBA
Default:
userid
B.3.8 ORADUMP
This variable specifies the dump file for Oracle Database and user trace output.
Format:
ORADUMP
=
dump-file
Classification:
USER, DBA
Default:
ORADUMP
=
OTRC.?.&TSN..&PGM..TRC
Example:
ORADUMP=(SYSOUT)
This assignment redirects the trace output to
SYSOUT
.
B.3.9 ORASID
This variable defines the database that is used if no database identification is given at
connect time.This variable is a synonym of the
ORACLE_SID
variable.