I am trying to do an exp from my newly setup database, I have the following error:
PLS-00201: identifier 'SYS.DBMS_REPCAT_RGT_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_RGT_EXP.schema_info_exp
. exporting cluster definitions
What should I do about EXP-00083, please help. Thanks.
What version of Oracle are you using ?
Did you run catalog.sql as user sys before running export ?
oracle 8.1.5 E.E, yes, I run catalog.sql when I created the database under user sys.
could you try the following at sql/plus --
select object_name, owner, status from dba_objects where object_name = 'DBMS_REPCAT_RGT_EXP'
When I do the query you advised, it shows
no rows returned.
We faced a simliar error before
this was because we created a table called SYS,
so look for any object called sys *you can do so by select from DBA_OBJECTS where name ='SYS'
if any object is found rename it.
or may be you ran catalog scripts as user system not user SYS, for example, while you were running the scripts that creates the replication repository, you logged as system, or as another user.
I hope this will solve your problem.
I would recommend logging in as sys and running catalog.sql again.
Also because it's a long scrtipt, Oracle put comments like "This is the end of the script..." at the end of the script so that you know that the script finished without any error.
Hope this helps !
I did run catalog.sql under user sys again. But it still gives me the same error message.....
well, could you run EXP at all ? I mean can you export a small table owned by YOU ?
I am trying to figure out if the problem is with the Export or with permission ?
What are you trying to export (full_database, user or table) ?
Are they in your schema or someone else's ?
Do you have the permissions to export someone else's objects ?
I am trying to export the whole database under user system,
according to log file, the db was exported but unsuccessfully.
The last five lines are:
. exporting referential integrity constraints
. exporting synonyms
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00000: Export terminated unsuccessfully
My other database, which is also new install, works perfectly though.
Click Here to Expand Forum to Full Width