3
Database Tools

Server Manager (Line mode only)  

Enter the following at the MS-DOS command prompt: C:\> SVRMGR30  

• Oracle Server Manager User's Guide

Export Utility  

Enter the following at the MS-DOS command prompt followed by your user name and password. C:\> EXP80

EXP80 runs and prompts you for parameters. To obtain a list of these parameters, enter the following at the MS-DOS command prompt: C:\> EXP80 HELP=Y

Note... When running the Export utility, the default values for the following parameters under Windows NT are:

BUFFER 4 KB

RECORDLENGTH 2 KB

Note... To export an entire database, you must use the user name SYSTEM. Do not use INTERNAL or SYS.  

• Oracle8 Server Utilities, which describes how to use the Export utility
• Oracle8 Server Messages, Volume I and Oracle8 Server Messages, Volume II for information on error messages

Import Utility  

Enter the following at the MS-DOS command prompt followed by your user name and password. C:\> IMP80

IMP80 runs and prompts you for parameters. To obtain a list of these parameters, enter the following at the MS-DOS command prompt: C:\> IMP80 HELP=Y

Note... When running the Import utility, the default values for the following parameters under Windows NT are:

BUFFER 4 KB

RECORDLENGTH 2 KB  

• Oracle8 Server Utilities, which describes how to use the Import utility
• Oracle8 Server Messages, Volume I and Oracle8 Server Messages, Volume II for information on error messages

SQL*Loader  

Invoke SQL*Loader at the MS-DOS command prompt followed by certain keywords. Enter the following and SQL*Loader displays a Help screen with the available keywords and default values. C:\> SQLLDR80  

• Oracle8 Server Utilities, which describes how to use the SQL*Loader utility
• Oracle8 Server Messages, Volume I and Oracle8 Server Messages, Volume II for information on error messages
• The section, "Using SQL*Loader with Windows 32-bit" in this chapter

Recovery Manager (RMAN80)  

Enter the following at the MS-DOS command prompt: C:\> RMAN80 PARAMETERS

To obtain a list of these parameters enter the following at the MS-DOS command prompt: C:\> RMAN80 HELP=Y  

See Oracle8 Server Backup and Recovery  

Instance Manager  

• Choose View>Launch Palettes>Applications. The Applications palette appears. Click the Instance Manager icon.
• Choose Tools>Applications>Instance Manager

The section, "Starting Instance Manager" in Chapter 10, "Managing Instances and Sessions" of Oracle Enterprise Manager Administrator's Guide  

Data Manager  

• Choose View>Launch Palettes>Applications. The Applications palette appears. Click the Data Manager icon.
• Choose Tools>Applications>Data Manager

The section, "Starting Data Manager" in Chapter 14, "Managing and Moving Data" of Oracle Enterprise Manager Administrator's Guide  

Schema Manager  

• Choose View>Launch Palettes>Applications. The Applications palette appears. Click the Schema Manager icon.
• Choose Tools>Applications>Schema Manager

The section, "Starting Schema Manager" in Chapter 11, "Managing Schema Objects" of Oracle Enterprise Manager Administrator's Guide  

Security Manager  

• Choose View>Launch Palettes>Applications. The Applications palette appears. Click the Security Manager icon.
• Choose Tools>Applications>Security Manager

The section, "Starting Security Manager" in Chapter 9, "Controlling Database Security" of Oracle Enterprise Manager Administrator's Guide  

Backup Manager  

• Choose View>Launch Palettes>Applications. The Applications palette appears. Click the Backup Manager icon.
• Choose Tools>Applications>Backup Manager

The section, "Starting Backup Manager" in Chapter 12, "Managing Backups and Archiving" of Oracle Enterprise Manager Administrator's Guide  

SQL Worksheet  

• Choose Tools>Applications>SQL Worksheet. The new worksheet is connected to the database you have selected in the Navigator tree list or in the map window.

The section, "Overview of the SQL Worksheet" in Chapter 13, "Using the SQL Worksheet" of Oracle Enterprise Manager Administrator's Guide  

SQL*Plus  

Enter either of the following at the MS-DOS command prompt: C:\> SQLPLUS

Starts the line mode version of SQL*Plus

or C:\> PLUS80W

Starts the GUI version of SQL*Plus

or C:\> PLUS80

Starts the line mode version of SQL*Plus

or

Choose Start>Programs>Oracle for Windows NT>SQL*Plus 8.0

Starts the GUI version of SQL*Plus  

• SQL*Plus for Windows NT and Windows95 Getting Started
• SQL*Plus User's Guide and Reference
• SQL*Plus Quick Reference

"VAR xxxx"  

Load variable length records. Specify the OSD "VAR recsizehint" in the control file for this option to take effect. The xxxx gives an estimate of the average record size to SQL*Loader so that it can approximate buffer sizes accurately and not waste memory. The default length is eighty characters. The xxxx does not specify how many leading bytes of length are included in each record. It only acts as a hint to SQL*Loader. Each record must always be preceded by five ASCII bytes containing the length of the remainder of the record. For example, a record must look like the following: 00024This is a 24 byte string

Any whitespace, carriage returns, or linefeeds at the end of the record are ignored unless specifically included in the byte count in the length field.  

"FIX n"  

Fixed record format in which each record is exactly n bytes long. If the record is terminated by a newline character, the newline character must be the nth byte.  

""¹  

Stream record format in which each record is terminated by a newline character. The maximum record size is 48 KB.  

INTEGER  

4  

SMALLINT  

2  

FLOAT  

4  

DOUBLE  

8  

For a complete list of options and instructions on using SQL*Loader, see Oracle8 Server Utilities. The directory ORACLE_HOME\RDBMS80\LOADER contains a number of examples on the use of SQL*Loader.