PDE Import Failing with No Errors

[GRAYTech]

I exported a number of tables from an Oracle 10G database and saved the export log. 3 of the tables are bigger than the rest with several million rows in them.

When I import into a 9.2 database the import works as expected until I get to the first large table, About 10% of the rows are imported and then the import quits, skipping the remaining rows in the large table and all other tables that follow.

No error message is produced. The tables are identical and have enough space. I'm not sure where to look to resolve it.

Exporting table DOT1CHEO.DT_CHEMS_EQP_AUDT...
4346486 records exported
---
Import table dot1cheo.DT_CHEMS_EQP_AUDT
320052 Records loaded, 0 errors

PL/SQL Dev 8.0.4.1514 used for both the export and import.

 

[Roeland]

How big are the files?

 

[GRAYTech]

The export that contains all files is just a little less than 1GB. I've also tried exporting/importing just one of the larger files and it was around 200 MB.

 

[GRAYTech]

I split up the import into 5 parts and got better results but still not 100%. The issue does appear to be related to the size of the export.pde file generated. If I limit the export file to something less than 200MB it appears to work ok in all cases.

1> 70MB, 100+ tables - worked as expected
2> 56MB, 3 Tables - Worked as expected
3> 208MB, 1 Table - Worked as expected

4> 252MB, 1 Table - Failed no errors, not all rows import
5> 456MB, 1 Table - Failed no errors, not all rows import

 

[GRAYTech]

I used version 9.0.0.1601 for both the export/import and got similar results. If the PDE file is too large the import fails as in version 8.x.

Will there be a resolution to this?

 

[Marco Kalter]

We'll try to reproduce this. Can you check how large the files are when they are not compressed?

 

[GRAYTech]

Size of the uncompressed file is 3.4GB.

I tried a export/import using uncompressed files and got different results. It appears not only the size of the .pde file matters but also what's in it.

A single uncompressed .pde file with a single table 171MB failed yet a single uncompressed .pde file with three tables in it 437MB worked.

Due to time contraints I didn't try 2 of the larger exports uncompressed. The one I did try (3.4GB) failed. More rows imported than the compressed version, no errors produced.

1> 300MB Uncomp - 70MB comp, 100+ tables - worked as expected
2> 437MB Uncomp - 56MB comp, 3 Tables - Worked as expected
5> 3.4GB Uncomp - 456MBcomp , 1 Table - Failed, not all rows import

PL/SQL Developer version 9.0.0.1601

 

[Marco Kalter]

Okay, we'll check it out.

 

[GRAYTech]

Did anything ever come of this ? Is the latest version capable of importing large tables ?