Home » RDBMS Server » Server Utilities » Export Error
Export Error [message #185222] Mon, 31 July 2006 11:06 Go to next message
faiz_hyd
Messages: 294
Registered: February 2006
Senior Member
Hi,
While Exporting i am getting the following error, i tried from Unix Prompt /DBartisian same error,from command promp it worked successfully, Strange!, Not getting what is wrong. Any clues what is wrong in the datatype it shows, the column which this error is pointing is having varchar2(4000) as datatype.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
Enter array fetch buffer size: 4096 > 
 
Export file: expdat.dmp > DBC_31JULY06.DMP
 
(2)U(sers), or (3)T(ables): (2)U > 
 
Export grants (yes/no): yes > 
 
Export table data (yes/no): yes > 
 
Compress extents (yes/no): yes > 
 
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user DBC 
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user DBC 
About to export DBC's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export DBC's tables via Conventional Path ...
. . exporting table                            APP          1 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table                        APPROLE          3 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                          DBCHG        601 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table                     DBCHG_STMT
EXP-00015: error on row 42391 of table DBCHG_STMT, column STMT_TX, datatype 1
EXP-00002: error in writing to export file
EXP-00002: error in writing to export fileerror closing export file DBC_31JULY06.DMP
EXP-00000: Export terminated unsuccessfully



Thanks
Re: Export Error [message #185225 is a reply to message #185222] Mon, 31 July 2006 11:24 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Are you hitting the 2g filesize limit?
else
Make sure you have enough space in the device.
Is the concerned table in a healthy?
try exporting only that table.
if nothing works,
Look into NLS settings.
and
In general, Do not user COMPRESS=y.
Re: Export Error [message #185248 is a reply to message #185225] Mon, 31 July 2006 13:58 Go to previous message
faiz_hyd
Messages: 294
Registered: February 2006
Senior Member
Thanks Mahesh for Response,

No it is not exceeding 2 g limit.
there was enough space on disk, But Thanks for pointing on it, i went and checed and space was the problem,
because there was some batch loading of files which was taking space,

It worked Thanks a Lot

But why it gave generic ORA error # ora-00015.

Thanks Again.

[Updated on: Mon, 31 July 2006 14:00]

Report message to a moderator

Previous Topic: exporting database objects without tables
Next Topic: SQL Loader
Goto Forum:
  


Current Time: Tue Dec 06 00:27:32 CST 2016

Total time taken to generate the page: 0.16071 seconds