Default: There is no default
Purpose
Specifies that a schema-mode import is to be performed.
Syntax and Description
SCHEMAS=schema_name [,...]
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.
Example
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
The hr
schema is imported from the expdat.dmp
file. The log file, schemas.log
, is written to dpump_dir1
.