| Neeraj |
Posted: Jan 25, 2008 06:32:54 AM |
Total Post: 228
Joined: Jan, 2007
|
HI,
I TOOK EXPORT BACKUP FROM 91 UTILITY OF 10G DATABSE, WHEN I IMPORT IT ON 10G DATABSE I GET STUCK ON "ENABLING CONSTRAINTS"
SO TELL Y M I GETTING THIS ERROR & HOW TO RESOLVE IT.
THXS |
|
|
 MOH_DBA |
| Posted: Jan 25, 2008 02:40:46 PM |  |
|
Total Post: 123
Joined: Nov, 2007
|
try to import without the data and with full option ( exp full=y rows=n) and then import the data (imp full=y ignore=yes).
|
|
|
|
|
| Mohammed Taj |
| Posted: Jan 26, 2008 03:43:56 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
>> STUCK ON "ENABLING CONSTRAINTS"
Did you receive any error becuase enable constraint take time.
|
|
|
|
|
| Neeraj |
| Posted: Jan 28, 2008 01:20:37 AM | |
|
Total Post: 228
Joined: Jan, 2007
|
hi,
u said i shud exp data w/o rows but i want that data of my database then i cud i ignore the data, plz describe in detail.
no i dont get any error , it goes for long time , i waited 2 days but it didnt comnpeted.
thxs
|
|
|
|
|
| Murtuja |
| Posted: Jan 28, 2008 03:27:09 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
Hi,
You need to follow little bit lengthy process in this case.
First export with rows=n and import this dump.So It will create schema for you.
Then disable all constraints from newly created schema
Import with constraints=n ignore=y (You have to use Full export dump here)
enable all constraints
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
