4 Replies Latest reply on Sep 7, 2011 2:37 PM by gerhard2001

    Problem with table export


      I'm using Ubuntu with OracleXE 10g and Oracle SQL Developer 3.0.04

      I tried to export with SQL Developer a table with it's data (ddl/data export)

      This table contains about 3500 records.

      Finally came up the message: "export ddl/data file was not opened because it exceeds the maximum automatic open size".

      I choose the way 'insert'.

      The created file has a size of 2.4 MB.

      But it doesn't contain all the necessary insert statements for the data import.

      Exists there any way to configure this export procedure to fix the problem?

      Thanks for any help!

        • 1. Re: Problem with table export
          Gary Graham-Oracle
          Hi Gerhard,

          It appears that the "maximum automatic open size" is hard-coded to a value of 500000 (bytes, I believe) with no way to override it. By limiting this, we nip in the bud any potential complaints of Java OutOfMemory upon trying to open a huge file.

          To view the file from within SQL Developer despite this limitation, just use the File|Open menu. For those huge files, please use an external editor. And if you don't want to open files automatically in order to suppress the warning dialog, use Tools|Preferences|Database|Export/View DDL Options and un-check the "Open Sql File When Exported" box.

          Are you certain the export file does not contain all the insert rows? That would be a bug unless you hit an OutOfMemory or disk full condition. I just tried your scenario on at 55000 row table that produced an export.sql of about 20MB. All rows were included.

          Gary Graham
          SQL Developer Team
          1 person found this helpful
          • 2. Re: Problem with table export
            johnnie d
            If you don't mind me saying, hard coding it is a very poor idea.

            You shouldn't code for bugs unless they're actually likely to happen. I've got a reasonable spec machine and never had any problems - there was no need to 'nip ii in the bud for me', thanks. Now I'll have to revert to a previous version.

            Now I can't export even a modestly sized database because somebody decided that such-and-such was an appropriate limit.
            1 person found this helpful
            • 3. Re: Problem with table export
              Maybe your method is not the best way to export a table's data! Oracle Data Pump Export/Import Tool is ofter the best tool to do this.
              1 person found this helpful
              • 4. Re: Problem with table export
                Hi Gary!

                Thanks for that useful info!

                My files didn't contain the complete data!

                Actually, for customers needs, I work with different Oracle XE Databases.

                So, things like Import, Export, Comparing, Synchronizing and so on are important things for me and I think, after reading the other comments,
                that Sql Developer is not the best tool for that!

                Thanks to all for your comments!!!!