This content has been marked as final. Show 2 replies
user625850 wrote:FILESIZE = maximum size of each dump file
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?
Try to run export without filesize and compress parameter
also increase your buffer size like buffer=10240000
since you're on 10g so you can also use expdp.