Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Problem Description: Getting errors while importing 9208 DB to 10204 DB
My source Database is on Windows 2003 server, database version is 9.2.0.8, I have fully exports it from the 9i export utility on the O-H/bin
Exp file=xx log=xx direct=y statistics=none full=y (uploaded the export log file).
My target Database is on Windows 2008 Server, database version is 10.2.0.4, I have imported the dump file from imp 10g utility from the 10g O-H/bin directory
Imp file=xx ignore=y full=y log=xx
Then I got many errors with import log file touches 500M
Getting errors like
1.ORA-01400: cannot insert null into sh.costs.promo_id,even though promo_id column does not exists on the source database.
2.ORA-01722:invalid number
3.many errors like ORA-00942: Table or view does not exists
Solution:
Trying to import into read only table spaces.
Change any read only table spaces to read write
My source Database is on Windows 2003 server, database version is 9.2.0.8, I have fully exports it from the 9i export utility on the O-H/bin
Exp file=xx log=xx direct=y statistics=none full=y (uploaded the export log file).
My target Database is on Windows 2008 Server, database version is 10.2.0.4, I have imported the dump file from imp 10g utility from the 10g O-H/bin directory
Imp file=xx ignore=y full=y log=xx
Then I got many errors with import log file touches 500M
Getting errors like
1.ORA-01400: cannot insert null into sh.costs.promo_id,even though promo_id column does not exists on the source database.
2.ORA-01722:invalid number
3.many errors like ORA-00942: Table or view does not exists
Solution:
Trying to import into read only table spaces.
Change any read only table spaces to read write
No comments:
Post a Comment