Oracle Error Exp-00024
error during export If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 6 of 6 Thread: EXP-00024 error during export Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 11-20-2007,01:10 AM #1 rehan khan View Profile View Forum Posts Junior Member 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, Reply With Quote 11-20-2007,02:21 AM #2 gtcol View Profile View Forum Posts Member 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 Reply With Quote 11-20-2007,02:44 AM #3 rehan khan View Profile View Forum Posts Junior Member 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, Reply With Quote 11-20-2007,03:08 AM #4 gtcol View Profile View Forum Posts Member 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 Reply With Quote 11-20-2007,03:38 AM #5 rehan khan View Profile View Forum Posts Junior Member 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 fo
take appropriate action. EXP-00001: data field truncation - column length=number, buffer size=number actual size=number Cause: Export could not fit a column in the data buffer. Action: Record the given size parameters and the accompanying messages and report this as an Export internal error to customer support. (Part of the table has been exported. Export will continue with the next table.) EXP-00002: error in writing to export file Cause: Export could not write to the export file, probably because of a device error. This message is usually followed by a device message from the operating system. Action: Take appropriate action to restore the device. EXP-00003: no storage definition found for segment(number, http://www.dbasupport.com/forums/showthread.php?56711-EXP-00024-error-during-export number) Cause: Export could not find the storage definitions for a cluster, index, or table. Action: Record the accompanying messages and report this as an Export internal error to customer support. EXP-00004: invalid username or password Cause: An invalid username or password was specified. Action: Retry with a valid username and password. EXP-00005: all allowable logon attempts failed Cause: Attempts were repeatedly made to log on with an invalid username or password. Action: http://docs.oracle.com/cd/E11882_01/server.112/e17766/expus.htm Shut down the utility, then restart and retry with a valid username and password. EXP-00006: internal inconsistency error Cause: Export's data structure was corrupted. Action: Record the accompanying messages and report this as an Export internal error to customer support. EXP-00007: dictionary shows no columns for string.string Cause: Export failed to gather column information from the data dictionary. The table may have been dropped. Action: Retry the export and, if this error recurs, report it as an Export internal error to customer support. EXP-00008: ORACLE error number encountered Cause: Export encountered the referenced Oracle error. Action: Look up the Oracle message in the ORA message chapters of this manual and take appropriate action. EXP-00009: no privilege to export string's table string Cause: An attempt was made to export another user's table. Only a database administrator can export another user's tables. Action: Ask your database administrator to do the export. EXP-00010: string is not a valid username Cause: An invalid username was specified. Action: Shut down the utility, then restart and retry with a valid username. EXP-00011: string.string does not exist Cause: Export could not find the specified table. Action: Retry with the correct table name. EXP-00012: string is not a valid export mode Cause: An invalid export mode was specified. Action: Retry with a vali
Michael Khan Messages: 2Registered: December 2003 Junior Member I am running oracle 9.2.0.3 on windows 2k server. I am exporting a user and is getting the following error message. 15:29:07.528 Program . exporting object type definitions for user CMM 15:29:07.538 Program About to export CMM's objects ... 15:29:07.558 Program . exporting database links 15:29:07.688 Program . exporting sequence numbers 15:29:10.081 Program . exporting cluster definitions 15:29:10.111 Program EXP-00056: ORACLE error 19206 encountered 15:29:10.121 Program ORA-19206: Invalid value for query or REF CURSOR parameter 15:29:10.131 Program ORA-06512: at "SYS.DBMS_XMLGEN", line 83 15:29:10.141 Program ORA-06512: at "SYS.DBMS_METADATA", line 345 15:29:10.151 Program ORA-06512: at "SYS.DBMS_METADATA", line 410 15:29:10.171 Program ORA-06512: at "SYS.DBMS_METADATA", line 449 15:29:10.181 Program ORA-06512: at "SYS.DBMS_METADATA", line 1156 15:29:10.191 Program ORA-06512: at "SYS.DBMS_METADATA", line 1141 15:29:10.201 Program ORA-06512: at line 1 15:29:10.211 Program EXP-00000: Export terminated unsuccessfully Any help will be appreciated. Thanks in advance. Michael Report message to a moderator Re: EXPORT ERROR [message #73394 is a reply to message #73393] Wed, 14 April 2004 00:40 ora9iDBA Messages: 31Registered: March 2003 Member Hi run following script @?/rdbms/admin/catmeta.sql by connecting as user sys and then take a export. This will resolve issue. Kishor Report message to a moderator Re: EXPORT ERROR [message #73538 is a reply to message #73393] Tue, 18 May 2004 20:40 Ngoc Long Nguyen Messages: 1Registered: May 2004 Junior Member Run: $ORACLE_HOME/rdbms/admin/catmeta.sql (under user SYS) Good luck! Report message to a moderator Re: EXPORT ERROR [message #73553 is a reply to message #73394] Thu, 20 May 2004 17:26 Jacky Rateng Messages: 1Registered: May 2004 Junior Member I had run the catmeta.sql ,but I don't use the command line export the user ,I may use dba tools to do above export. I get the following error message in the command line : About to export specified users ... . exporting pre-schema procedural objects and actions . exporting foreign function library names for user STIUSER5 . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user STIUSER5 EXP-00008: ORACLE error 942 encountered ORA-00942: table or view does not exist EXP-00024: Export views not installed, please notify your DBA EXP-00000: Expor