4
Database Tools

Oracle8 Utilities  

ORADIM80¹  

Yes  

No  

No  

Server Manager (SVRMGR30)  

Yes  

Yes  

Yes  

Migration Utility (MIG80)  

Yes  

No  

No  

Export (EXP80)  

Yes  

Yes  

Yes  

Import (IMP80)  

Yes  

Yes  

Yes  

SQL*Loader (SQLLDR80)  

Yes  

Yes  

Yes  

Recovery Manager (RMAN80)  

Yes  

Yes  

Yes  

Password Utility (ORAPWD80)²  

Yes  

No  

No  

OCOPY80  

Yes  

Yes  

Yes  

Windows NT Tools  

User Manager  

Yes  

Yes  

No  

Control Panel  

Yes  

Yes  

No  

Oracle Enterprise Manager  

Instance Manager  

Yes  

Yes  

Yes  

Data Manager  

Yes  

Yes  

Yes  

Schema Manager  

Yes  

Yes  

Yes  

Security Manager  

Yes  

Yes  

Yes  

Backup Manager  

Yes  

Yes  

Yes  

SQL Worksheet  

Yes  

Yes  

Yes  

Oracle Assistants (wizards)  

Oracle Migration Assistant for Microsoft Access  

Yes  

Yes  

Yes  

Oracle Database Assistant  

Yes  

No  

No  

Oracle Data Migration Assistant  

Yes  

No  

No  

Oracle Net8 Assistant  

Yes  

Yes  

Yes  

Oracle Net8 Easy Config  

Yes  

Yes  

Yes  

Oracle INTYPE File Assistant  

Yes  

Yes  

Yes  

NT Backup Manager³  

Yes  

No  

Yes  

NT Recovery Manager  

Yes  

No  

Yes  

SQL*Plus  

Yes  

Yes  

Yes  

Create a database  

Oracle Database Assistant  

ORADIM80 and Server Manager together

SQL Worksheet  

Delete a database  

Oracle Database Assistant  

ORADIM80 and Server Manager together  

Delete a database service  

Oracle Database Assistant  

ORADIM80  

Start a database  

Instance Manager¹  

Server Manager, ORADIM80, or SQL Worksheet  

Shut down a database  

Instance Manager  

ORADIM80, Server Manager, Control Panel, or SQL Worksheet  

Change internal database passwords  

ORAPWD80  

ORADIM80²  

Migrate data  

Oracle Data Migration Assistant  

Migration Utility  

Export data  

Data Manager  

Export Utility  

Import data  

Data Manager  

Import Utility  

Load data  

Data Manager  

SQL*Loader  

Back up database  

Backup Manager³  

RMAN80, NT Backup Manager or OCOPY80  

Recover database  

Backup Manager  

RMAN80, OCOPY80, NT Recovery Manager, or OCOPY80  

Authenticate Database Administrators and users  

Security Manager  

Server Manager, SQL*Plus, or SQL Worksheet  

Grant database roles  

Security Manager  

User Manager  

Create database objects⁴  

Schema Manager  

Server Manager or SQL*Plus  

ORADIM80  

Enter the following with parameters at the MS-DOS command prompt:

C:\> ORADIM80 PARAMETERS

To get a complete listing of ORADIM80 parameters, enter a question mark preceded by a dash after the executable name:

C:\> ORADIM80 -?

The section, "Using ORADIM80" in this chapter  

Server Manager (Line mode only)  

Enter the following at the MS-DOS command prompt:

C:\> SVRMGR30

• Oracle Server Manager User's Guide
• Chapter 10, "Administering a Database", which contains examples of starting and stopping the database with Server Manager

Migration Utility  

Enter the following at the MS-DOS command prompt:

C:\> MIG80

Chapter 5, "Database Co-existence and Migration"  

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 NT" 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

Chapter 12, "Backing Up and Recovering Database Files"  

Password Utility  

Enter the following at the MS-DOS command prompt:

C:\> ORAPWD80 FILE=FILENAME PASSWORD=PASSWORD 
ENTRIES=USERS

where:

• FILENAME is the instance's password file name
• PASSWORD is the logon password for the instance
• USERS is the maximum number of users

Oracle8 Server Administrator's Guide, which describes how to use the Password utility  

OCOPY80  

Enter the following at the MS-DOS command prompt.

C:\> OCOPY80

Chapter 12, "Backing Up and Recovering Database Files"  

User Manager  

Choose Start>Programs>Administrative Tools>User Manager  

• Chapter 7, "Oracle8 Integration with Windows NT"
• Your Microsoft Windows NT documentation

Control Panel  

Choose Start>Settings>Control Panel  

• Chapter 7, "Oracle8 Integration with Windows NT"
• Your Microsoft Windows NT documentation

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  

Oracle Migration Assistant for Microsoft Access  

Choose Start>Programs>Oracle for Windows NT>Oracle Migration Assistant for Microsoft Access  

Chapter 5, "Database Co-existence and Migration"  

Oracle Database Assistant  

Choose Start>Programs>Oracle for Windows NT>Oracle Database Assistant  

• Chapter 9, "Creating a Database"
• Oracle8 Installation for Windows NT CD-ROM Insert

Oracle Data Migration Assistant  

Choose Start>Programs>Oracle for Windows NT>Oracle Data Migration Assistant  

• Chapter 5, "Database Co-existence and Migration"
• Oracle8 Installation for Windows NT CD-ROM Insert

Oracle Net8 Assistant  

Choose Start>Programs>Oracle for Windows NT>Oracle Net8 Assistant  

Net8 Administrator's Guide  

Oracle Net8 Easy Config  

Choose Start>Programs>Oracle for Windows NT>Oracle Net8 Easy Config  

Net8 Administrator's Guide  

NT Backup Manager  

Choose Start>Programs>Oracle for Windows NT>NT Backup Manager  

Online help included with this tool  

NT Recovery Manager  

Choose Start>Programs>Oracle for Windows NT>NT Recovery Manager  

Online help included with this tool  

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 Getting Started for Windows NT and Windows 95
• SQL*Plus User's Guide and Reference
• SQL*Plus Quick Reference

Create an instance  

ORADIM80 -NEW -SID SID [-INTPWD INTERNAL_PWD] [-SRVC SRVCNAME] 
[-MAXUSERS NUMBER][-STARTMODE AUTO, MANUAL][-PFILE FILENAME]

where:

• SID is the value of the new system identifier (SID).
• INTERNAL_PWD is the password for the INTERNAL account. Mandatory unless DBA_AUTHORIZATION or DBA_SID_AUTHORIZATION is set to BYPASS in \\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ of the registry.
• SRVCNAME is the service name.
• NUMBER is the number of users defined in the password file. The default is five.
• AUTO or MANUAL indicate whether to start the database automatically or manually at startup. The default setting is manual.
• FILENAME is the INITSID.ORA file to be used with this instance.

Note... -NEW and -SID are mandatory parameters. The remaining parameters are optional.

Note... Creating an instance using ORADIM80 only creates the password file and related service. The database (that is, the database files) is not created.  

Start an instance  

ORADIM80 -STARTUP -SID SID [-PFILE FILENAME ][-USRPWD USER_PWD] -STARTTYPE 
SRVC,INST

where:

• SID is the value of the SID to start.
• FILENAME is the INITSID.ORA file to be used with this instance.
• USER_PWD is the password for the INTERNAL account. This is a mandatory parameter.
• SRVC is for starting the services and INST is for starting an instance (both can be specified).

Note... -STARTUP, -SID, and -STARTTYPE are mandatory parameters. The remaining parameters are optional.  

Stop an instance  

ORADIM80 -SHUTDOWN -SID SID [-USRPWD USER_PWD] -SHUTTYPE SRVC, INST -SHUTMODE 
[A, I, N]

where:

• SID is the value of the SID to stop.
• USER_PWD is the password for the INTERNAL account. Mandatory unless DBA_AUTHORIZATION or DBA_SID_AUTHORIZATION is set to BYPASS in \\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ of the registry.
• SRVC is for stopping the services and INST is for shutting down a database (both can be specified).
• Specifications on how to stop an instance; A indicates abort mode, I indicates immediate mode, and N normal mode.

Note... -SHUTDOWN, -SID, and -SHUTTYPE are mandatory parameters. The remaining parameters are optional.  

Edit an instance  

ORADIM80 -EDIT -SID SID [-NEWSID NEWSID][-INTPWD INTERNAL_PWD]

[-STARTMODE AUTO, MANUAL][-PFILE FILENAME]

where:

• SID is the value of the SID to edit.
• NEWSID is the new SID for the instance (enter only if changing an existing instance name).
• INTERNAL_PWD is the password for the INTERNAL account. This is necessary only if the password file was not created earlier.
• AUTO or MANUAL indicate whether to start the database automatically or manually at startup.
• FILENAME is the INITSID.ORA file to be used with this instance.

Note... -EDIT and -SID are mandatory parameters. The remaining parameters are optional.

Note... This command cannot be used to change the password, as it does not overwrite the existing password file. It can only create a new password file when none already exists. To create a new password file, use ORAPWD80, or delete the Oracle8 services (this action implicitly deletes the associated password file) and then recreate the Oracle8 services (this action implicitly creates the associated password file).  

Delete an instance  

ORADIM80 -DELETE -SID SIDA, SIDB, SIDC,... 

ORADIM80 -DELETE -SRVC SRVCA, SRVCB, SRVCC,... 

where:

• SIDA, SIDB, SIDC are the values of the SIDs to delete.
• SRVCA, SRVCB, SRVCC are the services to delete.

Display a complete list of ORADIM80 commands  

ORADIM80 -? | /? | /H | /HELP

When you use ORADIM80, a log file called ORADIM80.LOG is opened in ORACLE_HOME\RDBMS80. All operations (both successful and failed) are logged in this file. You must check this file to verify the success of an operation.  

"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.