Other uses for Export
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
Other uses for Export
Because the Export utility provides a logical backup of the database, it can be used to move data in and out of the database. As a DBA, you can use Export/Import as follows:
To move data between operating systems or versions of Oracle. If you do move data between computer systems, use a binary mode file copy rather than a record-based copy (see Chapter 16 for details).
To assist in changing some of the storage attributes of a table. Once you have exported a table, you can drop it, recreate it with different storage parameters, or even place it in a new tablespace and then reimport the table. If you are doing this, make sure that you specify IGNORE=Y in the Import control file.
To change the owner of the table. Any export file written by a non-DBA user can be imported by any other user. The userid specified when invoking Import will become the owner of the objects. If the export was performed by a DBA, then the import can only be performed by a DBA, but the FROM-OWNER and TOOWNER clauses can be used to change the owner of the objects.
The Export/Import facility is not the only way to accomplish these tasks; you can use a series of SQL statements and SQL*Net to perform all of these actions. However, in many cases, using Export/Import is easiest, and requires less storage within the database.
-
No Comment