Database Reference
In-Depth Information
Exporting Views As Tables
Starting with Oracle 12c, you can export a view and later import it as a table. You may want to do this if you need to
replicate the data contained in a view to a historical reporting database.
Use the
VIEWS_AS_TABLES
parameter to export a view into a table structure. This parameter has the following
syntax:
VIEWS_AS_TABLES=[schema_name.]view_name[:template_table_name]
Here is an example:
$ expdp mv_maint/foo directory=dp_dir dumpfile=v.dmp \
views_as_tables=sales_rockies
The dump file can now be used to import a table named
SALES_ROCKIES
into a different schema or database.
$ impdp mv_maint/foo directory=dp_dir dumpfile=v.dmp
If you just want to import the table (which was created from a view during the export), you can do so as follows:
$ impdp mv_maint/foo directory=dp_dir dumpfile=v.dmp tables=sales_rockies
The table will have the same columns and data types as per the view definition. The table will additionally
contain rows of data that match what would have been selected from the view at the time of the export.
Disabling Logging of Redo on Import
Starting with Oracle 12c, you can specify that objects be loaded with nologging of redo. This is achieved via the
DISABLE_ARCHIVE_LOGGING
parameter:
$ impdp mv_maint/foo directory=dp_dir dumpfile=inv.dmp \
transform=disable_archive_logging:Y
While performing the import, the logging attributes for objects are set to
NO
; after the import the logging attributes
are set back to their original values. For operations that Data Pump can perform with direct path (such as inserting
into a table), this can reduce the amount of redo generated during an import.
Interactive Command Mode
Data Pump provides an interactive command mode that allows you to monitor the status of a Data Pump job and
modify on the fly a number of job characteristics. The interactive command mode is most useful for long-running
Data Pump operations. In this mode, you can also stop, restart, or terminate a currently running job. Each of these
activities is discussed in the following sections.
