DataPump Import [message #324377] |
Mon, 02 June 2008 04:27 |
GaneshRamadoss
Messages: 5 Registered: February 2008
|
Junior Member |
|
|
Hi,
I am facing a small problem with datapump import, i exported a schema using datapump export(expdp) the same dump file i used for import using (impdp), once when the import is over i see all procedures,triggers and etc are all created with double quotes such as CREATE OR REPLACE PROCEDURE "ACCOUNTTRANSFERDETAIL_INSERT". So when doing a DataBase Difference these all comes as mismatch, but this is not the case iin oracle 9i. So is there any way to overcome this errror.
Thanks in Advance.
Regards,
Ganesh R
|
|
|
|
Re: DataPump Import [message #324405 is a reply to message #324377] |
Mon, 02 June 2008 06:31 |
GaneshRamadoss
Messages: 5 Registered: February 2008
|
Junior Member |
|
|
Hi,
When i do a export and import in oracle 9i everthing was ok.
Now our QA team is doing a oracle 10g export and import (EXP & IMP) activities and i am using oracle 10g Datapump for export and import (expdp & impdp) this is where we are facing problem. Comparison is between oracle 10g (exp & imp ) and oracle 10g datapump (expdp & impdp).
For their schema there was no double quotes and when i refreshed a schema using impdp objects where enclosed using double quotes.
Regards,
Ganesh R
|
|
|
|