-
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,
-
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
-
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,
-
Open the DB, log in as SYS, run the catexp.sql. Run the scripts as a user with SYSDBA privs.
HTH,
gtcol
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|