This discussion is archived
4 Replies Latest reply: Sep 7, 2011 7:37 AM by gerhard2001 RSS

Problem with table export

gerhard2001 Newbie
Currently Being Moderated
Hello!

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!

Gerhard
  • 1. Re: Problem with table export
    Gary Graham Expert
    Currently Being Moderated
    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.

    Regards,
    Gary Graham
    SQL Developer Team
  • 2. Re: Problem with table export
    johnnied Explorer
    Currently Being Moderated
    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.
  • 3. Re: Problem with table export
    526763 Newbie
    Currently Being Moderated
    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.
  • 4. Re: Problem with table export
    gerhard2001 Newbie
    Currently Being Moderated
    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!!!!

    Gerhard

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points