User`s guide

iii
Contents
Preface ................................................................................................................................................................. ix
Audience....................................................................................................................................................... ix
Documentation Accessibility..................................................................................................................... ix
Using Oracle Database Documentation................................................................................................... x
Related Documents ..................................................................................................................................... x
Conventions Used in this Manual............................................................................................................. x
1 Getting Started
1.1 The Oracle Database Environment-Definition File................................................................ 1-1
1.1.1 Generating the Environment-Definition File................................................................... 1-1
1.1.2 Calling the Environment-Definition File.......................................................................... 1-2
1.1.3 Specifying the Environment Variables............................................................................. 1-2
1.2 The ORALOAD Library............................................................................................................. 1-3
1.3 Starting Oracle Utilities with BS2000 SDF commands .......................................................... 1-3
1.4 Starting Oracle Utilities in UNIX-Style.................................................................................... 1-4
1.5 Starting Oracle Utilities in the POSIX environment .............................................................. 1-4
1.6 Connecting to an Oracle Instance............................................................................................. 1-6
1.6.1 Default Connections............................................................................................................ 1-6
1.6.2 Accessing an Oracle Instance............................................................................................. 1-6
1.7 Using BS2000 Files for Input and Output................................................................................ 1-7
1.7.1 Text Files ............................................................................................................................... 1-7
1.7.2 Binary Files ........................................................................................................................... 1-7
1.7.3 Generic Oracle Database File Name Syntax .................................................................... 1-7
1.7.4 Default File Name Extensions............................................................................................ 1-7
1.7.5 Using Link Names............................................................................................................... 1-7
1.7.6 Fixed Link Names................................................................................................................ 1-8
2 Oracle Database Utilities
2.1 SQL*Loader ................................................................................................................................. 2-1
2.1.1 Starting the SQL*Loader Utility ........................................................................................ 2-1
2.1.2 Using the SQL*Loader Demonstration Files.................................................................... 2-1
2.2 The Export Utility ....................................................................................................................... 2-2
2.2.1 Starting the Export Utility .................................................................................................. 2-2
2.2.2 Exporting to Foreign Systems............................................................................................ 2-3
2.2.2.1 Transferring Data by Tape .......................................................................................... 2-3