-
Hello on my 816 hp unix environment
i received the following error messages.
EXP-00015: error on row 630912 of table HI_FGI_BAL_HISTORY, column HI_AVAIL_ON_HAND, datatype 2
EXP-00002: error in writing to export file
EXP-00002: error in writing to export fileerror closing export file
EXP-00000: Export terminated unsuccessfully
can anybody give me ideas on how to possibly resolve this?I am new at this.
thanks
Jigar
-
You have an error writing to your export file. Usually, this is because of permissions, you have filled up a filesystem, or you have reached the maximum file size for your OS.
-
Isnt there a way to export a full database compressed by itself?
not compress the extents but compress the .exp.Z itself.
thanks
Jigar
-
Hello...i actually meant inline compression.
-
Any ideas from moderators?
-
check these links:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=1057099.6
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=1038222.6
-
As far as I know you cannot compress a file that is being written, not just UNIX I dont think it's possible in any OS
-
If you are reaching your OS's file size limit or if disk space is scarce you can split your exports to make it smaller. you have 2 or more files to deal with but hey....you gotta do what you gotta do. If this is a backup you're creating I suggest you just do an online backup of the datafiles, it's faster and it solves your file size limit problem.
-
hi
why not try to export directly to a tape device??