import/export--need help gurus!!!!!!
585321Feb 12 2008 — edited Feb 14 2008C:\DOCUME~1\ADMINI~1>set oracle_sid=orcl
C:\DOCUME~1\ADMINI~1>expdp scott/tiger directory=orcl_exp_datapump schemas=scott
Export: Release 10.2.0.1.0 - Production on Tuesday, 12 February, 2008 19:35:34
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "SCOTT"."SYS_EXPORT_SCHEMA_01": scott/******** directory=orcl_exp_datapump schemas=scott
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 32.62 MB
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/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
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/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "SCOTT"."SYS_EXPORT_FULL_02" 7.628 MB 12224 rows
. . exported "SCOTT"."SYS_EXPORT_FULL_03" 7.670 MB 12231 rows
. . exported "SCOTT"."SYS_EXPORT_FULL_01" 7.080 MB 9573 rows
. . exported "SCOTT"."SYS_EXPORT_TABLESPACE_01" 255.8 KB 318 rows
. . exported "SCOTT"."DEPT" 5.656 KB 4 rows
. . exported "SCOTT"."EMP" 7.820 KB 14 rows
. . exported "SCOTT"."SALGRADE" 5.585 KB 5 rows
. . exported "SCOTT"."TESTDEPT" 5.726 KB 7 rows
. . exported "SCOTT"."BONUS" 0 KB 0 rows
Master table "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_SCHEMA_01 is:
C:\ORCL_EXP_DATAPUMP\EXPDAT.DMP
Job "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully completed at 19:37:35
C:\DOCUME~1\ADMINI~1>impdp abc/abc directory=orcl_exp_datapump dumpfile=expdat.dmp remap_schema=scott:abc
Import: Release 10.2.0.1.0 - Production on Tuesday, 12 February, 2008 19:43:48
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-31626: job does not exist
ORA-31633: unable to create master table "ABC.SYS_IMPORT_FULL_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 863
ORA-01031: insufficient privileges
Any advise is appreciated!
trying to import from scott schema to abc schema....but unsuccessful.
DBA creates directory
grants permission on the directory to scott and abc schemas
exports scott schema (userid/password.....scott/tiger)
imports to abc schema(userid/password....abc/abc)
is this the right way?
i need some assistance guys!!!!!!
Message was edited by:
oracle novice
Message was edited by:
oracle novice