2 Replies Latest reply: Oct 29, 2012 4:55 AM by Sunny kichloo RSS

    Oracle exp error

    user625850
      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
        • 1. Re: Oracle exp error
          kuljeet singh -
          user625850 wrote:
          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
          FILESIZE = maximum size of each dump file
          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.
          • 2. Re: Oracle exp error
            Sunny kichloo
            Better you use expdp and also you can estimate the dump size

            Export Dump Size

            http://arjudba.blogspot.in/2009/02/estimate-dumpfile-size-before-taking.html