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=YCan you pls provide step by instructions?
first check at least that the version of the destination database is higher or better same version as the source database.
Second check that the version of the imp tool exact matches the version of destination database and
version of exp tool exact matches the version of source database.
(with exp -help you can see it)
When your destination database has already db objects of the source db then you can supress warnings from imp with: