| EXPORT import error [message #323758] |
Thu, 29 May 2008 06:40  |
tannad
Messages: 43
Registered: January 2008
Location: mumbai
|
Member |
|
|
-->Hi I exported data from oracle10 g by imp utility.on the same server
Now I want to import the dump file on the oracle 9i user.
when I give command on linux server
c:\> imp username/password@oracle9i ..
It will give mi error as
UDI-00008: operation generated ORACLE error 6550
ORA-06550: line 1, column 52:
PLS-00201: identifier 'SYS.DBMS_DATAPUMP' must be declared
ORA-06550: line 1, column 52:
PL/SQL: Statement ignored
Can you tell mi what is this error ?
2-->After that I tried to export data of oracle10g user from oracle 9i exp utility
but in some tables it give mi error as
. . exporting table QRTZ_JOB_DETAILS
EXP-00003: no storage definition found for segment(17, 31315)
.
whts the error ?
3-How Can I create the replica of schema from oracle10g to oracle 9i.?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
