Already a member?
Sign in
Welcome! This is a website that everyone can build together. It's easy!
Location: The Official Oracle Wiki
Discussion: DataPump Import
Keyword tags:
ACBS
content management
DBA Certitification
ibr
idc
middleware
oracle
oracle applications
Oracle eAM
site studio
stellent
ucm
Watch
|
GaneshRamadoss GaneshRamadoss |
DataPump Import
Jun 4 2008, 12:29 AM EDT 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, so is there any way to overcome this error. 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 (DEV) team 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. I also checked in data dictionary there also i see the object names enclosed with double quotes. so i anybody has solution please revert back. Thanks Regards, Ganesh R 1 out of 4 found this valuable. Do you? |
|
sacrophyte sacrophyte |
RE: DataPump Import
Jun 10 2008, 4:28 PM EDT That's "the way it is", unfortunately. We discovered the same issue when converting our character set and doing a DB comparison with TOAD. However, TOAD does allow you to select which differences to ignore, like whitespaces and quotes, which helped tremendously. 3 out of 3 found this valuable. Do you? |
