| Problems importing [message #305055] |
Fri, 07 March 2008 20:38  |
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
|
Senior Member |
|
|
Hi,
I have taken a dump from my 9i database with following command
exp advant/mse file=d:\new.dmp full=y
and tried to import into my 10g database with the following command
imp advant/mse file=d:\new.dmp fromuser=advant touser=advant
It just imports the tables then gives the following message and stops
| Quote: | About to enable constraints....
Import terminated successfully with warnings
|
There are no warnings on the screen...what can be the problem?
- Das
|
|
|
|
|
|
| Re: Problems importing [message #305057 is a reply to message #305056] |
Fri, 07 March 2008 21:18  |
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
|
Senior Member |
|
|
There is no error.. the beginning looks like this
| Quote: | export file created by export : v09.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
importing advant's objects into advant
..importing table
..importing table
..
About to enable constraints....
Import terminated successfully with warnings
|
Any idea why this is happening?
- Das
|
|
|
|
|
|
| Re: Problems importing [message #305059 is a reply to message #305058] |
Fri, 07 March 2008 21:43 |
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
|
Senior Member |
|
|
sorry guys...just checked 10g database and all the objects are intact...I thought they have not been imported as it did not show on the screen..
thanks
- Das
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
