exp error
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: exp error

  1. #1
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    Hi, all
    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.

  2. #2
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    What version of Oracle are you using ?

    Did you run catalog.sql as user sys before running export ?

    - Rajeev

  3. #3
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    oracle 8.1.5 E.E, yes, I run catalog.sql when I created the database under user sys.

  4. #4
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    could you try the following at sql/plus --

    select object_name, owner, status from dba_objects where object_name = 'DBMS_REPCAT_RGT_EXP'



  5. #5
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    When I do the query you advised, it shows
    no rows returned.


  6. #6
    Join Date
    May 2000
    Location
    Alex, Egypt
    Posts
    41
    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.
    Amir Magdy

  7. #7
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    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 !

    - Rajeev

  8. #8
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    I did run catalog.sql under user sys again. But it still gives me the same error message.....

  9. #9
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    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 ?

    - Rajeev

  10. #10
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width