| Export Import Problem [message #61324] |
Wed, 14 April 2004 10:38  |
gulshan
Messages: 19
Registered: January 2004
|
Junior Member |
|
|
Hi All,
I had taken export of a particular user schema. That user contains approx. 40 tables and each table contains approx. 25000 records. When I was taking export, it shows me the exported tables and rows, triggers, functions, indexes etc.
But in other database when I import it in a particular user's schema. It exports all the tiriggers, functions etc but did not import any table. What would be the reason for this. This database has installed Oracle 9i release 1 and the database from which i have taken export has Oracle 9i release 2. Should i need to migrate it. Please help me out.
Thanks
|
|
|
|
|
|
|
|
| Cases In Export Import Problem [message #61353 is a reply to message #61324] |
Fri, 16 April 2004 01:07  |
khuram
Messages: 4
Registered: February 2003
|
Junior Member |
|
|
hi
these can be reasons for not importing tables.
1) you cannot import table to a upper version from a lower version.
2) if u are importing only one user data then that user schema should exist.
3) you are selecting no to 'import tables' option.
Khuram Shahzad.
Developer:
ShifaSoft
Islamabad. Pakistan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
