Starting Database Tools from the Command Line
Describes how to start Oracle Database tools from the command line, and where to go for further information on using these products.
Table 2-3 Starting Database Tools from the Command Line
Tool | Enter at Prompt | More Information |
---|---|---|
|
"Marking Disk Partitions for Oracle ASM Before Installation" in Oracle Grid Infrastructure Installation and Upgrade Guide for Microsoft Windows x64 (64-Bit) |
|
DBVERIFY starts and prompts you for a file name parameter. To obtain a list of parameters, enter:
|
||
EXP starts and prompts you for parameters. To obtain a list of these parameters, enter:
|
Oracle Database Utilities for instructions on use of Data Pump Export Oracle Database Error Messages Reference for information on error messages |
|
IMP starts and prompts you for parameters. To get a list of these parameters, enter:
|
Oracle Database Utilities for instructions on use of Data Pump Import Oracle Database Error Messages for information on error messages |
|
Database Configuration Assistant |
Oracle Database Configuration Assistant tool starts in interactive mode. For silent options and other command-line options, enter:
|
"Starting DBCA" in Oracle Database 2 Day DBA |
Database Upgrade Assistant |
Oracle Database Upgrade Assistant wizard starts in interactive mode. For silent options and other command line options enter:
|
|
EXP starts and prompts you for parameters. To obtain a list of these parameters, enter:
|
Oracle Database Utilities for instructions on use of Export Oracle Database Error Messages for information on error messages |
|
Import |
IMP starts and prompts you for parameters. To get a list of these parameters, enter:
|
Oracle Database Utilities for instructions on use of Import Oracle Database Error Messages for information on error messages |
Net Services Configuration |
Oracle Net Configuration Assistant tool starts in interactive mode. For silent options and other command-line options, enter:
|
|
To get a list of ORADIM options, enter either of the following:
|
||
Oracle Wallet Manager |
|
|
Password file is hidden. Use Windows Explorer to see it in a file list. From the View menu, select Options, then select View and then select Show All Files. |
||
|
||
|
SQL*Plus User's Guide and Reference | |
SQL*Loader displays a Help screen with available keywords and default values. |
||
|
Oracle Database SQL Tuning Guide | |
User Migration Utility |
To get a list of parameters, enter:
|
"Using the User Migration Utility" in Oracle Database Enterprise User Security Administrator's Guide |
Note:
-
Three special conditions apply when running Export or Import utilities on Windows. First, default values for
BUFFER
andRECORDLENGTH
parameters are 4 KB and 2 KB respectively. This defaultRECORDLENGTH
parameter does not depend on the value ofBUFSIZ
defined in the system header file. If you specify a value larger thanUSHRT_MAX
(64 KB), you get a warning message. Second, theVOLSIZE
parameter is not supported. Third, to export an entire database, you must use theEXP_FULL_DATABASE
role. -
Oracle Enterprise Manager Database Express is another database tool for managing the database. For information about logging in to Oracle Enterprise Manager Database Express, see "Configuring the HTTP Port for EM Express" in Oracle Database 2 Day DBA.
- About Archiving Redo Log Files
If you installed Oracle Database through the Typical installation, then it is created in theNOARCHIVELOG
mode. If you created your database through the Custom option of Oracle Database Configuration Assistant, then you had the choice of eitherARCHIVELOG
orNOARCHIVELOG
.
Parent topic: Starting Database Tools