SYS.DBMS_SYS_SQL
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: SYS.DBMS_SYS_SQL

  1. #1
    Join Date
    Apr 2001
    Posts
    103

    Angry

    Hello,
    I am tring to do an export. I have error ora-04068 (SYS.DBMS_SYS_SQL has errors).
    I went to vrify the package SYS.DBMS_SYS_SQL, in the sys schema but I didn't find it.
    Because of this package, other packages references SYS.DBMS_SYS_SQL are invalid too.
    Does anybody know where I can get this package and How to impliment it.
    This is for the production database. Please help me.
    Naeem
    Naeem

  2. #2
    Join Date
    Mar 2001
    Posts
    314
    Run

    ORACLE_HOME/rdbms/admin/prvtssql.plb

    as user SYS to create(recreate) the DBMS_SYS_SQL package.

    -amar

  3. #3
    Join Date
    Apr 2001
    Posts
    103

    Angry SYS.DBMS_SYS_SQL

    Thanks Amar,
    Does this affect anyway my database.
    Because this is a production database I have to be sure that it will not affect the functioning of by base.
    naeem
    Naeem

  4. #4
    Join Date
    Mar 2001
    Posts
    314
    It should not. But check it out in a test system first please!

    -amar

  5. #5
    Join Date
    Apr 2001
    Posts
    103
    Thanks Amar,
    It was a great help, It works.
    Naeem
    Naeem

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