DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: EXP-00024 error during export

  1. #1
    Join Date
    Sep 2007
    Posts
    47

    EXP-00024 error during export

    hi, Iam getting the following errors during export.

    EXP-00024:Export views not installed, please notify your DBA.

    Question: What are export views and how to install export views ?


    thanks,

  2. #2
    Join Date
    Oct 2006
    Posts
    175
    did u run the required packages i.e., catexp.sql from rdbms folder? this package will create all the necessary views for export, EXP_FULL_DATABASE ROLE and assigns privileges to EXP_FULL_DATABASE role and DBA role.

    HTH,
    gtcol

  3. #3
    Join Date
    Sep 2007
    Posts
    47

    EXP-00024 error during export

    hi, I have not run catexp.sql.

    Question: Do I need to mount the database to run this script or I can do it normally? Can I run this script by logging as system user?


    thanks,

  4. #4
    Join Date
    Oct 2006
    Posts
    175
    Open the DB, log in as SYS, run the catexp.sql. Run the scripts as a user with SYSDBA privs.

    HTH,
    gtcol

  5. #5
    Join Date
    Sep 2007
    Posts
    47

    EXP-00024 error during export

    hi, I log in as sysdba and run the script catexp.sql. But when I give command to export i get the following error. (Note:The database is up)

    About to export the entire database ...
    . exporting tablespace definitions
    . exporting profiles
    . exporting user definitions
    . exporting roles
    . exporting resource costs
    . exporting rollback segment definitions
    . exporting database links
    . exporting sequence numbers
    . exporting directory aliases
    . exporting context namespaces
    . exporting foreign function library names
    . exporting PUBLIC type synonyms
    . exporting private type synonyms
    . exporting object type definitions
    . exporting system procedural objects and actions
    . exporting pre-schema procedural objects and actions
    EXP-00008: ORACLE error 3113 encountered
    ORA-03113: end-of-file on communication channel
    EXP-00008: ORACLE error 1041 encountered
    ORA-01041: internal error. hostdef extension doesn't exist
    EXP-00000: Export terminated unsuccessfully

  6. #6
    Join Date
    Aug 2009
    Posts
    1
    Dear if you have Oracle9i Release 2 (9.2.0.1.0) and updated with 9206 patch please run the catpatch.sql from Oracel_Home/rdbms/admin/, as follows

    1. Shutdown the database
    2. startup the database with Migrate option
    SQL > startup migrate
    3. Then run the catpatch.sql from with the above said path
    SQL> @Oracel_Home/rdbms/admin/catpatch.sql
    4. Shutdown the database
    5. Start the database normally

    You can verify the version before and after the dba_registry

    SQL> select comp_id,version from dba_registry;

    Now you can run exp utility with out any problems, for more clarification please read readme file of the above said patch

    Take care

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