EXP-00024 error during export

[rehan khan]

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,

[gtcol]

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

[rehan khan]

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,

[gtcol]

Open the DB, log in as SYS, run the catexp.sql. Run the scripts as a user with SYSDBA privs.

HTH,
gtcol

[rehan khan]

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

[muhdnur]

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