Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle exp error

user625850Oct 29 2012 — edited Oct 29 2012

Hi I am trying to export a table with 2 million records and getting below error.

exp user1/user1 buffer=8192 compress=y file=Test_table.dmp tables=test_table filesize=8192000000

Export: Release 10.2.0.1.0 - Production on Mon Oct 29 12:49:23 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table TEST_TABLE
EXP-00065: Error writing lob to the dump file.error closing export file Test_table.dmp
Export terminated successfully with warnings.

How to calculate what's the filesize I should give during export?

Thanks