| Importing error [message #152398] |
Thu, 22 December 2005 21:25  |
sam_jo98
Messages: 5
Registered: December 2005
Location: Phil
|
Junior Member |
|
|
Hi,
I export dump file from my live database and it was exported succesfully in Database Control Console of Oracle 10g Release 2 (10.2), then i created Test database then i imported the dump file in thesame version of oracle but i got an error. How to solve this problem?
Here's the error:
Master table "SYSTEM"."TSTDB" successfully loaded/unloaded
Starting "SYSTEM"."TSTDB":
Job "SYSTEM"."TSTDB" stopped due to fatal error at 09:36:11
Job "SYSTEM"."TSTDB" stopped due to fatal error at 09:36:11
Job TSTDB has been reopened at Friday, 23 December, 2005 9:36
Restarting "SYSTEM"."TSTDB":
Processing object type DATABASE_EXPORT/TABLESPACE
ORA-31684: Object type TABLESPACE:"UNDOTBS1" already exists
ORA-31684: Object type TABLESPACE:"SYSAUX" already exists
ORA-31684: Object type TABLESPACE:"TEMP" already exists
ORA-31684: Object type TABLESPACE:"USERS" already exists
Processing object type DATABASE_EXPORT/PROFILE
ORA-31684: Object type PROFILE:"MONITORING_PROFILE" already exists
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
ORA-31684: Object type USER:"SCOTT" already exists
ORA-31684: Object type USER:"OUTLN" already exists
ORA-31684: Object type USER:"TSMSYS" already exists
ORA-31684: Object type USER:"ANONYMOUS" already exists
ORA-31684: Object type USER:"OLAPSYS" already exists
ORA-31684: Object type USER:"SYSMAN" already exists
ORA-31684: Object type USER:"MDDATA" already exists
ORA-31684: Object type USER:"MGMT_VIEW" already exists
Processing object type DATABASE_EXPORT/ROLE
|
|
|
|
| Re: Importing error [message #152480 is a reply to message #152398] |
Fri, 23 December 2005 07:48  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
It is just telling you that object and user already exist in the database where you are intending to import.
you can use parameter ignore=y while importing.
And if fails again then post your exp/imp scripts.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
