Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Export -import error 'SYS.DBMS_DATAPUMP'

622118May 29 2008 — edited May 29 2008
1-->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.?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2008
Added on May 29 2008
2 comments
4,158 views