Default: There is no default
Specifies that a schema-mode import is to be performed.
Syntax and Description
If you have the
DATAPUMP_IMP_FULL_DATABASE role, then you can use this parameter to perform a schema-mode import by specifying a list of schemas to import. First, the user definitions are imported (if they do not already exist), including system and role grants, password history, and so on. Then all objects contained within the schemas are imported. Unprivileged users can specify only their own schemas or schemas remapped to their own schemas. In that case, no information about the schema definition is imported, only the objects contained within it.
The use of filtering can restrict what is imported using this import mode. See "Filtering During Import Operations".
Schema mode is the default mode when you are performing a network-based import.
The following is an example of using the
SCHEMAS parameter. You can create the
expdat.dmp file used in this example by running the example provided for the Export
SCHEMAS parameter. See "SCHEMAS".
> impdp hr SCHEMAS=hr DIRECTORY=dpump_dir1 LOGFILE=schemas.log DUMPFILE=expdat.dmp
hr schema is imported from the
expdat.dmp file. The log file,
schemas.log, is written to