Default: AUTOMATIC
Purpose
Instructs Import to use a particular method to load data.
Syntax and Description
ACCESS_METHOD=[AUTOMATIC | DIRECT_PATH | EXTERNAL_TABLE | CONVENTIONAL]
The ACCESS_METHOD
parameter is provided so that you can try an alternative method if the default method does not work for some reason. Oracle recommends that you use the default option (AUTOMATIC
) whenever possible because it allows Data Pump to automatically select the most efficient method.
Restrictions
If the NETWORK_LINK
parameter is also specified, then the ACCESS_METHOD
parameter is ignored.
Example
> impdp hr SCHEMAS=hr DIRECTORY=dpump_dir1 LOGFILE=schemas.log DUMPFILE=expdat.dmp ACCESS_METHOD=CONVENTIONAL