"SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "RJB"."SYS_IMPORT_FULL_01": rjb/******** parfile=dp_rjb_import.par
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"KFC" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
Job "RJB"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 13:22:32
[oracle@oc1 ~]$
The only error during the impdp command was that the KFC user already exists; I created it
explicitly earlier, and this error message can safely be ignored.
What if a table being imported already exists? In this example, with the CONTENT option set
to METADATA_ONLY, the table would be skipped by default. If the CONTENT option was set to
DATA_ONLY, the new data would be appended to the existing table data. To alter this behavior,
use the TABLE_EXISTS_ACTION option. Valid values for TABLE_EXISTS_OPTION are SKIP,
APPEND, TRUNCATE, and REPLACE.
408 Oracle Database 11g DBA Handbook
Stopping and Restarting Running Jobs
After you have started a Data Pump Import job, you can close the client window you used to start
the job. Because it is server based, the import will continue to run. You can then attach to the job,
check its status, and alter it:
impdp rjb/rjb parfile=rjb_dp_import.
Pages:
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635