Oracle Export/Import

This is a discussion on Oracle Export/Import within the Oracle Database forums in category; Hi, Can anybody explains regarding the export/import activity? Recently, we have done exported the data from 8i(version 8.1.5) and imported into 10g(version 10.2.0.1). It is exported from 8i database but it is not imported into 10g database. I am getting the error of 'About to enable constraints...' and the Import is not moving. I have done the schema level export from 8i database by connecting to the user XXX and tried to import into 10g database. I have given the parmeters during import like: imp d:\expdat.dmp full=y commit=y ...

Go Back   Database Forum > Oracle Database

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 01-04-2008, 06:30 AM
Smile Oracle Export/Import

Hi,

Can anybody explains regarding the export/import activity?

Recently, we have done exported the data from 8i(version 8.1.5) and imported into 10g(version 10.2.0.1). It is exported from 8i database but it is not imported into 10g database.
I am getting the error of 'About to enable constraints...' and the Import is not moving.
I have done the schema level export from 8i database by connecting to the user XXX and tried to import into 10g database.
I have given the parmeters during import like:

imp d:\expdat.dmp full=y commit=y ignore=y grants=n log=impXXX.log

While importing the tables, it is hanging at "About to enable constraints..."
and hanging there.

Please do the needful accordingly ASAP.


Regards,
Kiran
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 03:42 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.