10g New fatures - Tip of the Day

What is the replacement for fromuser/touser in impdp?

Z:\OraDocs\10g\Work>impdp sami/sami remap_schema=scott:sami dumpfile=sami2.dmp logfile=sami2_imp.log

Import: Release 10.1.0.2.0 - Production on Sunday, 07 August, 2005 16:00

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Master table "SAMI"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SAMI"."SYS_IMPORT_FULL_01": sami/******** remap_schema=scott:sami dum
pfile=sami2.dmp logfile=sami2_imp.log
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"SAMI" 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/SE_PRE_SCHEMA_PROCOBJACT/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "SAMI"."SYS_EXPORT_TABLE_01" 54.91 KB 337 rows
. . imported "SAMI"."DEPT" 5.656 KB 4 rows
. . imported "SAMI"."EMP" 7.820 KB 14 rows
. . imported "SAMI"."SALGRADE" 5.585 KB 5 rows
. . imported "SAMI"."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/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/SE_POST_SCHEMA_PROCOBJACT/PROCOBJ
.
.
.
Job "SAMI"."SYS_EXPORT_SCHEMA_01" successfully completed at 16:33


The user SAMI should have all the privileges to create objects residing in SCOTT schema.


For example, user ARASI dose not have privilege to create_program as show below.


Z:\OraDocs\10g\Work>impdp sami/sami remap_schema=scott:arasi dumpfile=sami2.dmp
logfile=arasi_imp.log

Import: Release 10.1.0.2.0 - Production on Sunday, 07 August, 2005 16:01

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Master table "SAMI"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SAMI"."SYS_IMPORT_FULL_01": sami/******** remap_schema=scott:arasi dumpfile=sami2.dmp logfile=arasi_imp.log
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/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/SE_PRE_SCHEMA_PROCOBJACT/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "ARASI"."SYS_EXPORT_TABLE_01" 54.91 KB 337 rows
. . imported "ARASI"."DEPT" 5.656 KB 4 rows
. . imported "ARASI"."EMP" 7.820 KB 14 rows
. . imported "ARASI"."SALGRADE" 5.585 KB 5 rows
. . imported "ARASI"."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/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/SE_POST_SCHEMA_PROCOBJACT/PROCOBJ
ORA-39083: Object type PROCOBJ failed to create with error:
ORA-27486: insufficient privileges
Failing sql is:
BEGIN
dbms_scheduler.create_program('"CHECK_ALERT_LOG_ERRORS"','EXECUTABLE',
'C:\oracle\product\10.1.0\WorkArea\check_alert.bat'
,0, TRUE,
'Email DBA if errors in the alert file'
);COMMIT; END;


Job "SAMI"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 16:01