REMAPSCHEMA - Definition,Properties- Oracle Tablespaces

Q.  Which parameter when not specified then all the database objects are created in the same user schema as in the source database, and those users must already exist in the target database?
- Published on 03 Aug 15

a. TRANSPORT_DATAFILES
b. DUMPFILE
c. DIRECTORY
d. REMAP_SCHEMA

ANSWER: REMAP_SCHEMA
 

    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


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)