14.3.2 call impdp-import scheme

1. delete a user

C: \> sqlplus system/orcl @ orcl

SQL * Plus: Release 10.2.0.1.0-production on Sunday January 4 17:48:51 2009

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connect:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the partitioning, OLAP and Data Mining options

SQL> drop user Scott cascade;

The user has been deleted.

2. Create a user (grant DBA permissions for convenience)

SQL> create user Scott identified by tiger;

The user has been created.

SQL> grant DBA to Scott;

Authorization successful.

3. Import your own solution

C: \> impdp Scott/tiger @ orcl directory = dump_dir dumpfile = schema. dmp schemas = Scott

Import: Release 10.2.0.1.0-production on Sunday, 04 August 1, 2009 18:02:46

Copyright (c) 2003,200 5, Oracle. All rights reserved.

Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the partitioning, OLAP and Data Mining options
The master table "Scott". "sys_import_schema_01" is successfully loaded/uninstalled"
Start "Scott". "sys_import_schema_01": Scott/********* @ orcl directory = dump_dir dum
Pfile = schema. dmp schemas = Scott
Processing object type schema_export/user
ORA-31684: Object Type User: "Scott" 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/table
Processing object type schema_export/table/table_data
.. Imported "Scott". "Dept" 5.656 kb 4 lines
.. Imported "Scott". "EMP" 7.820 kb 14 rows
.. Imported "Scott". "salgrade" 5.585 kb 5 rows
.. Imported "Scott". "bonus" 0 kb 0 rows
Processing object type schema_export/table/index/Index
Processing object type schema_export/table/constraint/Constraint
Processing object type schema_export/table/index/statistics/index_statistics
Processing object type schema_export/table/constraint/ref_constraint
Processing object type schema_export/table/statistics/table_statistics
The job "Scott". "sys_import_schema_01" has been completed, but there is one error (completed at 18:02:56)

4. Import to other solutions

C: \> impdp system/orcl @ orcl directory = dump_dir dumpfile = schema. dmp remap_schema = s
Cott: System

Import: Release 10.2.0.1.0-production on Sunday, 04 August 1, 2009 18:05:55

Copyright (c) 2003,200 5, Oracle. All rights reserved.

Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the partitioning, OLAP and Data Mining options
The master table "system". "sys_import_full_01" is successfully loaded/uninstalled"
Start "system". "sys_import_full_01": System/********* @ orcl directory = dump_dir dum
Pfile = schema. dmp remap_schema = SCOTT: System
Processing object type schema_export/user
Processing object type schema_export/system_grant
Processing object type schema_export/role_grant
........................................................................................................................ ..................

Processing object type schema_export/table/post_table_action
Processing object type schema_export/post_schema/procact_schema
The job "system". "sys_import_full_01" has been completed, but there are 136 errors (completed at 18:06:37)