Index
A
B
C
D
E
F
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
A
- Ada, 10-6
- ALTER DATABASE command, 5-4, 6-2
- ALTER SYSTEM command, 2-5
- ALTER TABLESPACE command, 5-4
- Appendices, 11
- ARCH process, 6-4
- ARCHIVELOG mode, 1-7
- AUTHORIZE utility, 2-3
B
- BACKGROUND_DUMP_DEST parameter, 9-2
- Backup procedures, 1-7
- Binary integers, 10-15
- Blocksize, 5-4
- Buffers
- database buffer pool, 1-5
- redo log buffers, 1-5
C
- C Language
- precompiling, 10-6
- CATDBSYN.SQL script, 7-5, 8-8
- COBOL, 10-6, 10-16
- Commands
- ALTER DATABASE, 5-4
- CONNECT INTERNAL, B-2
- CREATE TABLE, 5-4
- DROP TABLESPACE, 5-5
- Compiling with programmatic interfaces, 10-7
- CONNECT INTERNAL, B-2
- CONTINUE command, C-2
- Control files
- creating, 5-3
- identifying, 5-3
D
- Database
- automatic recovery, 7-2
- granting access to, 2-3
- opening in exclusive mode, 3-4
- Database files
- defined, 1-6
- Database links
- creating, 5-3
- Database verification utility, 5-8
- database verification utility, 5-8
- Datafiles, 1-8
- Datatypes, 10-15
- DB_BLOCK_BUFFERS parameter, 1-5
- DB_dbname directory, 5-4
- DCL command
- from within SQL*Plus or SQL*Forms, 11-3
- DEBUG qualifier, 10-7
- Demo files
- programmatic interfaces, 10-10
- Detached processes, 7-3
- identification, A-6
- DROP TABLESPACE command, 5-5
E
- EDIT command, 11-9, 11-10
- Editing files in SQL*Plus, 11-9
- Errors
- ORA-00445, 8-3
- ORA-00921, 5-4
- ORA-07623, 8-3
- event flags
- restrictions, 10-7
- Exclusive mode, 3-4
- Export utility, 6-8
- for reducing fragmentation, 8-7
F
- FORTRAN, 10-6, 10-16
- Fragmentation, 8-7
H
- Help
- SQL*Plus Help tables, 11-2
- HOST
- DCL command, 11-3
- , 10-6
I
- Import utility
- for recovery, 7-4
- INCLUDE option, 10-6
- INIT.ORA file
- location, A-5
- INIT.ORA files
- at start-up, 1-4
- setting SGA size, 1-4
- INSORACLE.COM file
- run as a batch job, 3-10
- Interrupt keys
- SQL*Plus, 11-2
- I/O
- improving, 1-5
J
- Java, 1-2
- JDBC drivers, 1-2
L
- limit
- on length of HOST command, 11-3
- linker directives
- with Oracle programming interfaces, 10-10
- Linking
- , 10-8
- LOUTL.COM, 10-10
- OCI routines, 10-13, 10-15
- LNOCIC.COM, 10-13
- LNOCI.COM, 10-14
- LOG_BUFFER parameter, 1-5
- LOG_CHECKPOINT_INTERVAL parameter, 1-6, 6-2
- Logical names
- alphabetical listing, A-3
- command files that define, A-2
- Logicals
- identification, 1-8
- using to specify files, 1-7
- LOGIN.COM file
- of ORACLE users, 2-2
- LOGINOUT, C-3
- LOGIN.SQL, 11-9
- LRS
- See Log roll-forward server (LRS), A-1, B-1, C-1, D-1
M
- Managing Instances, 4-1
N
- NOARCHIVELOG mode, 1-7
O
- OCI routines, 10-12, 10-15
- options file
- using for linker directives, 10-10
- ORA_DATA logical name, 11-8
- ORA_DUMP directory, 6-4
- ORA_INSTALL logical name, A-4
- ORA_INSUTL
- using to install shared images, 8-6
- ORA_PARAMS logical, 8-2
- ORA_PATH logical name, 11-8
- ORA_SID logical, 3-5
- default value, 1-4
- ORA_USER.COM file, A-6
- ORA-00445 error, 8-3
- ORA-00921 error, 5-4
- ORA-07623 error, 8-3
- Oracle
- contacting Worldwide Technical Support, xviii
- ORACLE call interface
- OCI routines, 10-12
- ORACLE programmatic interfaces
- compiling, 10-7
- datatypes, 10-15
- FORTRAN %REF directive, 10-15
- HOST option, 10-6
- linking, 10-8
- LNOCIC.COM, 10-13
- LNOCI.COM, 10-14
- , 10-8
- OCI routines, 10-13, 10-15
- optional call parameters, 10-16
- precompiling, 10-5
- , 10-7
- Oracle7
- granting access privileges, 2-3
- linked as shared image, 1-4
- logical names, A-2
- relinking, 1-4
- shutting down, 3-12
- ORACLE.EXE file
- defined, 1-4
- ORACLEINS
- to shut down Oracle7, 3-14
- ORACLEINS.COM file
- logical assignments made, A-2
- ORAMBX, 5-9
- ORAUSER_instance.COM file, 2-2
- running for ORACLE users, 2-2
P
- Parallel Query, 4-4
- Parameters
- optional with programmatic interfaces, 10-16
- passing to SQL*Plus, 11-3, 11-4, 11-5
- Pascal, 10-6
- password utility, 2-3
- Peformance analysis, 11-10
- PL/I, 10-6
- Precompiling
- guidelines and restrictions, 10-7
- options, 10-6
- syntax and example, 10-5
- preface
- PT PrefaceTitle, xi
- Privileges
- and Process Rights Identifier, B-1
- Process Global Area
- dump files for, 9-2
- Process ID
- OpenVMS, 9-2
- Process name
- OpenVMS, 9-2
- Process Rights Identifier, B-1
- PRODUCT_USER_PROFILE, 11-2
- profile files
- SQL*Plus
- Pages, 11-7
- Programmatic Interfaces
- ORACLE programmatic interfaces, 10-2
- PT PrefaceTitle, xi
Q
- Quotas
- process quota logicals, 8-3
R
- Redo log file
- mode of use, 6-2
- Redo log files
- default names for, 1-7
- defining, 1-6
- modes of, 1-7
- moving, 5-7
- reusing, 1-7
- size of, 1-7
- Relinking Oracle7, 1-4
- Rolling backward, 7-2
- Rolling forward, 7-2
- Runtime libraries
- used with Oracle7, 1-3
S
- Server Manager, 3-6
- Shared memory
- installing products in, 8-5
- Shared ORACLE7 image, A-5
- Shared Pool, 1-5
- SHUTDOWN command, 7-3
- SHUTDOWN file
- to stop ORACLE7, 3-14
- SID
- and instances, 4-2
- ORA_SID, A-5
- SPOOL command, 11-9
- SQL*Plus
- editing files in, 11-9
- GLOGIN.SQL, 11-7
- help tables, 11-2
- HOST command, 11-3
- interrupt keys, 11-2
- LOGIN.SQL, 11-7, 11-9
- passing parameters to, 11-3, 11-4, 11-5
- passing values from, 11-6, 11-7
- PRODUCT_USER_PROFILE, 11-2
- running system commands from, 11-3
- SPOOL command, 11-9
- TIMING command, 11-10
- STARTUP command, 3-6, 7-3
- System Global Area
- components, 1-5
- defined, 1-4
- dump files for, 9-2
- identification, A-6
- size, 1-4
- SYSTEM tablespace, 7-4
- removing, 5-4
T
- Tablespace files
- moving, 5-6
- TIMING command, 11-10
- Trace files, A-4
- tracing
- and SQL trace utility, 9-2
U
- User Identification Code (UIC), 9-2
- Utility
- database verification, 5-8
- useful, 5-8
V
- VMS Mailbox driver
- creating database links for the, 5-3
