troubleshooting Question

Export and Import Warnings

Avatar of basirana
basirana asked on
Oracle Database
8 Comments1 Solution1822 ViewsLast Modified:

I am trying to do export and import from one database to another database. And See warning messages in the log file

EXP-00056: ORACLE error 4031 encountered
ORA-04031: unable to allocate 18020 bytes of shared memory ("shared pool","KU$_NT_LIST_T","type object de","KOKT object")
ORA-06512: at "SYS.DBMS_METADATA", line 1546
ORA-06512: at "SYS.DBMS_METADATA", line 1583
ORA-06512: at "SYS.DBMS_METADATA", line 1901
ORA-06512: at "SYS.DBMS_METADATA", line 3806
ORA-06512: at "SYS.DBMS_METADATA", line 3784
ORA-06512: at line 1

The destination database is already having data when I try to Import full database at destiation it gives me whole bunch or warning saying object already exist

IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\EXAMPLE01.DBF'
ORA-27038: created file already exists
OSD-04010: <create> option specified, file already exists
IMP-00017: following statement failed with ORACLE error 1119:

I thought something wrong with the process or the way I am trying to import.

Do I need to remove all objects from destination database?

Can you please help with steps I need to fallow If I want to make two database same. And when I do export and import I don't want any warnings. Can yuo help me with steps I need to fallow for export and import?

exp / full=y file=c:\backup\expdat.dmp consistent=y grants=y constraints=y direct=y log= c:\backup\expdat.log.
imp / file= c:\backup\expdat.dmp ignore=Y log= c:\backup\impdat.log analyze=N full=Y commit=Y rows=Y
Can you pls provide step by instructions?
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros