Home » RDBMS Server » Server Utilities » Error while exporting (Oracle 10g)
Error while exporting [message #378878] Fri, 02 January 2009 04:08 Go to next message
aviva4500
Messages: 122
Registered: July 2008
Location: bangalore
Senior Member
Dear All,
I have created a directory which is named dmpdir and exported the tables which is present in scott user.
But now i need to import the SCOTT>DMP file to the user TEST but it throws the below error need your kind suggestions.
I have used EXPDP and IMPDP.

C:\Documents and Settings\Administrator>IMPDP TEST/TEST DIRECTORY=DMPDIR DUMPFILE=SCOTT.DMP

Import: Release 10.1.0.2.0 - Production on Friday, 02 January, 2009 15:30

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 "TEST"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "TEST"."SYS_IMPORT_FULL_01":  TEST/******** DIRECTORY=DMPDIR DUMPFILE=S
COTT.DMP
Processing object type SCHEMA_EXPORT/SE_PRE_SCHEMA_PROCOBJACT/PROCACT_SCHEMA
ORA-39083: Object type PROCACT_SCHEMA failed to create with error:
ORA-31625: error changing username from TEST to SCOTT
ORA-01031: insufficient privileges
Failing sql is:
BEGIN
sys.dbms_logrep_imp.instantiate_schema(schema_name=>'SCOTT', export_db_name=>'OR
CL', inst_scn=>'339736');COMMIT; END;


Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-31684: Object type TABLE:"SCOTT"."DEPT" already exists
ORA-31684: Object type TABLE:"SCOTT"."EMP" already exists
ORA-31684: Object type TABLE:"SCOTT"."BONUS" already exists
ORA-31684: Object type TABLE:"SCOTT"."SALGRADE" already exists
ORA-39138: Insufficient privileges to load data not in your schema
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
ORA-39111: Dependent object type INDEX:"SCOTT"."PK_DEPT" skipped, base object ty
pe TABLE:"SCOTT"."DEPT" already exists
ORA-39111: Dependent object type INDEX:"SCOTT"."PK_EMP" skipped, base object typ
e TABLE:"SCOTT"."EMP" already exists
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ORA-39111: Dependent object type CONSTRAINT:"SCOTT"."PK_DEPT" skipped, base obje
ct type TABLE:"SCOTT"."DEPT" already exists
ORA-39111: Dependent object type CONSTRAINT:"SCOTT"."PK_EMP" skipped, base objec
t type TABLE:"SCOTT"."EMP" already exists
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
ORA-39111: Dependent object type REF_CONSTRAINT:"SCOTT"."FK_DEPTNO" skipped, bas
e object type TABLE:"SCOTT"."EMP" already exists
Job "TEST"."SYS_IMPORT_FULL_01" completed with 11 error(s) at 15:30



Thanks and Regards,
Hammer.
Re: Error while exporting [message #380706 is a reply to message #378878] Tue, 13 January 2009 01:20 Go to previous message
mymailbox.21
Messages: 14
Registered: May 2007
Location: hyderabad
Junior Member
hi hammer in impdp you need to use REMAP_SCHEMA clause when you are trying to import into another user.

in your case issue REMAP_SCHEMA=TEST.
Previous Topic: ORACLE error 3113 encountered
Next Topic: Need Dump Files on Client machine using Data Pump
Goto Forum:
  


Current Time: Sun Dec 11 02:33:15 CST 2016

Total time taken to generate the page: 0.07747 seconds