DUMPFILE specifies exported file containing metadata for tablespaces to be imported - Oracle Tablespaces

Discussion

• Nirja Shah   -Posted on 31 Aug 15
  - Any privileged user can import a tablespace set.
  
  - Certain parameters used for importing are as follows:
  
  - DUMPFILE - This parameter specifies the exported file containing the metadata for the tablespaces to be imported.
  
  - DIRECTORY - This parameter specifies the directory object that identifies the location of the dump file.
  
  - TRANSPORT_DATAFILES - This parameter identifies all of the datafiles containing the tablespaces to be imported.
  
  - REMAP_SCHEMA - This parameter changes the ownership of database objects.
  - If you do not specify REMAP_SCHEMA, all database objects (such as tables and indexes) are created in the same user schema as in the source database, and those users must already exist in the target database.
  - If they do not exist, then the import utility returns an error.

➨ Post your comment / Share knowledge