Oracle Error Exp 00028
Utilities. EXP-00000 Export terminated unsuccessfully Cause: Export encountered an Oracle error. Action: Look up the accompanying Oracle message in the ORA message chapters of this manual, and 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 Oracle 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, 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 Oracle 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: 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 Oracle 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 Oracle Customer Support. EXP-00008 ORACLE error number encountered Cause:
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 4 of 4 Thread: exp-00028 Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 10-31-2005,01:33 PM #1 israel05 View Profile View Forum Posts Junior Member Join Date Aug 2005 Posts 12 exp-00028 Hello, https://docs.oracle.com/cd/A87860_01/doc/server.817/a76999/expus.htm For some reason I am getting the exp-00028 failed to open sysconfig2.log for write error. I am using an hp-ux system I am calling this par file and it has read/write access. FILE=./opt/app/wlgrad/oracle/oradata/SPARE/backupdaily/sysconfig_2.dmp LOG=./home/oracle/backup/sysconfig2.log DIRECT=Y GRANTS=Y INDEXES=Y TRIGGERS=Y CONSTRAINTS=Y TABLES=CDRCALLTYPES,CDRCALLTYPESETUP,CDRFIELDSPEC, CDRFIELDVALXLAT,CDRHOLIDAYS Reply With Quote 10-31-2005,02:04 PM #2 tamilselvan View Profile View Forum Posts Visit Homepage Moderator Join Date May 2000 Location ATLANTA, GA, USA Posts 3,135 Do you http://www.dbasupport.com/forums/showthread.php?49384-exp-00028 have write permission on /home/oracle/backup/ dir? Tamil Reply With Quote 10-31-2005,02:18 PM #3 israel05 View Profile View Forum Posts Junior Member Join Date Aug 2005 Posts 12 yes, it has read and write permission. Reply With Quote 10-31-2005,03:52 PM #4 davey23uk View Profile View Forum Posts Senior Advisor Join Date Sep 2002 Location England Posts 7,334 you have a . in front of the path, remove them Reply With Quote Quick Navigation Oracle Database Administration Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Oracle Forums Oracle Database Administration Oracle Applications DBA Oracle Development Oracle Certification Oracle : How To Oracle Careers Oracle Positions Available Oracle Job Wanted Archives Forum Archives Other Feedback and Questions regarding the forums Obfuscation Unlimited « Previous Thread | Next Thread » Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On [VIDEO] code is On HTML code is On Forum Rules Contact Us DBAsupport.com Home Page Top Click Here to Expand Forum to Full Width All times are GMT -4. The time now is 01:21 PM.
FAQ by clicking the link above. You may have to register before you can http://www.dbforums.com/showthread.php?1200718-exp-00028 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 http://www.orafaq.com/usenet/comp.databases.oracle.server/2006/01/12/0574.htm 5 of 5 Thread: exp-00028 Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid oracle error Mode Switch to Threaded Mode 10-31-05,13:31 #1 israel05 View Profile View Forum Posts Registered User Join Date Aug 2005 Posts 40 Unanswered: exp-00028 Hello, For some reason I am getting the exp-00028 failed to open sysconfig2.log for write error. I am calling this par file and it has read/write access. FILE=./opt/app/wlgrad/oracle/oradata/SPARE/backupdaily/sysconfig_2.dmp LOG=./home/oracle/backup/sysconfig2.log oracle error exp DIRECT=Y GRANTS=Y INDEXES=Y TRIGGERS=Y CONSTRAINTS=Y TABLES=CDRCALLTYPES,CDRCALLTYPESETUP,CDRFIELDSPEC, CDRFIELDVALXLAT,CDRHOLIDAYS Reply With Quote 10-31-05,13:45 #2 LKBrwn_DBA View Profile View Forum Posts Registered User Join Date Jun 2003 Location West Palm Beach, FL Posts 2,713 I SUSPECT IT IS BECAUSE OF THE DOT (.) BEFORE THE FILE NAMES -- REMOVE THEM. The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb Reply With Quote 10-31-05,14:20 #3 israel05 View Profile View Forum Posts Registered User Join Date Aug 2005 Posts 40 i did and it still gave me the error. i am running on a hp-ux system. Reply With Quote 10-31-05,14:56 #4 beilstwh View Profile View Forum Posts Registered User Join Date Jun 2004 Location Liverpool, NY USA Posts 2,508 What are the permissions on the /home/oracle/backup directory and are you running as a user that owns the directory or belongs to the same group? You can find out the permission on th
Date: 12 Jan 2006 05:54:01 -0800 Message-ID: <1137074041.072269.26660@f14g2000cwb.googlegroups.com> No such luck -- tail -f shows nothing.... Session monitor shows there is an export going. And IO on the session is changing (consistent gets, etc.), so the export session is active. For some reason, though, it is unable to write to a file. It goes through the entire export, and fails at the end, still unable to write to the file: About to export specified tables via Direct Path ... . . exporting table mytablename ........................................................................... ........................................................................... ........................................................................... ........................................................................... ........... EXP-00002: error in writing to export file EXP-00002: error in writing to export fileerror closing export file FIFO.dmp EXP-00000: Export terminated unsuccessfully Jeff wrote: > Alex, > It's been a little while since I've used named pipes in Unix. If I > remember correctly, the writing process will be blocked until another > process reads from the FIFO pipe. Can you do a "tail -f