OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Export Error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export Error [message #185222]

Mon, 31 July 2006 11:06

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

Report message to a moderator

Re: Export Error [message #185225 is a reply to message #185222]

Mon, 31 July 2006 11:24

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: Export Error [message #185248 is a reply to message #185225]

Mon, 31 July 2006 13:58

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 00:08:21 CST 2024