Interactive Mode Syntax
by Brian Laskey, David C. Kreines
Oracle Database Administration: The Essential Refe
- Dedication
- Preface
- I. DBA Tasks
- 1. Introduction
- 2. Installation
- 3. Maximizing Oracle Performance
- 4. Preventing Data Loss
- 5. Oracle Networking
- Oracle Names
- MultiProtocol Interchange
- Connecting to Non-Oracle Databases
- Network Manager Data Storage
- Using Network Manager
- Files Created by Network Manager
- Oracle Net8 Assistant
- Manual Network Configuration
- Sample SQL*Net Files
- SQL*Net Troubleshooting
- 6. Security and Monitoring
- 7. Auditing
- 8. Query Optimization
- 9. Oracle Tools
- 10. The Oracle Instance
- 11. The Oracle Database
- 12. Initialization Parameters
- 13. SQL Statements for the DBA
- SQL Commands by Task
- SQL Command Syntax
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- column_constraint_clause
- auto_extend_clause
- for_clause
- filespec
- autoextend_clause
- global_index_clause
- local_index_clause
- table_constraint_clause
- table_ref_clause
- column_ref_clause
- column_constraint_clause
- index_organization_clause
- segment_attrib_clause
- partition_clause
- autoextend_clause
- 14. The Oracle Data Dictionary
- Static Data Dictionary Views
- Dynamic Performance Data Dictionary Views
- 15. System Privileges and Initial Roles
- 16. Tools and Utilities
Interactive Mode Syntax
Export may be invoked in an interactive mode from a host system command prompt, using the following syntax:
exp [username[/password]][@hostname]
- username
The Oracle username for the account to run Export.
- password
The password for the username. If the password is omitted, SQL*Plus will prompt for the password.
- hostname
The hostname assigned to the database being connected to, as contained in the tnsnames.ora file or Oracle Names.
When running in interactive mode, Export will prompt for some, but not all, parameters as follows. Defaults appear at the end of each line:
Username: SYSTEM Password: Enter array fetch buffer size: 4096 >Export file: expdat.dmp > (1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > Export grants (yes/no): yes > Export table data (yes/no): yes > Compress extents (yes/no): yes >
Note
The option to export the E(ntire) database is only presented if the username specified has the EXPORT_FULL_DATABASE privilege (see Chapter 15).
The actual name of the Export executable may vary from platform to
platform, and from release to release. For example, the executable
name for Export for Windows 95 is exp73.exe (for
Version 7.3) or exp80 (for Version 8.0), and is
therefore entered on the command line as exp73 or
exp80.
-
No Comment