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.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
