Export Import Problem

[Chittaranjan Mohapatra]

All tables were exported into one file using PLSQL Developer Export (.pde) file. While importing the list of table window does not display any table. What could be the reason. What is the solution?

 

[Marco Kalter]

Did you already select a previously exported .pde file? The table list will only be populated when a file is selected.

 

[Sail Lee]

After selected a previously exported .pde file.

The same situation I met too.

Why and HOW can I do?

 

[Sail Lee]

Follow my system infomation:

PL/SQL Developer
Version 6.0.5.926 (MBCS)
18253.6320 - Unlimited user license
Windows 2000 version 5.0 (build 2195) Service Pack 4

Physical memory : 1,047,788 kB (727,548 available)
Paging file : 2,522,040 kB (2,199,072 available)
Virtual memory : 2,097,024 kB (2,015,036 available)

Parameters
D:\Program Files\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Plug-Ins

Aliases
227
228
CDMA
CDMA_TEST
CDMA2
...

Homes
OraHome92 (d:\oracle\ora92)

DLLs
d:\oracle\ora92\bin\oci.dll

TNS File
d:\oracle\ora92\Network\Admin\tnsnames.ora

Using
Home: OraHome92
DLL: d:\oracle\ora92\bin\oci.dll
OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.1.0
Character size: 2 byte(s)

 

[Sail Lee]

I guest something wrong with the compression procedure?

 

[Marco Kalter]

In 6.0.5 there could be problems if the file was larger than 2GB. This is fixed in 6.0.6 though.

 

[Sail Lee]

But my .pde file is less then 400M!

Is another problem？

 

[Marco Kalter]

I am not aware of any other problems, only the 2GB limit. Can you send me the first 100KB of this pde file?

 

[Sail Lee]

Send to you by email?

 

[Marco Kalter]

Yes, please send it to support@allroundautomations.com.

 

[Sail Lee]

Mail was send to you, any problem found？

 

[Marco Kalter]

I don't think I received it. Can you re-send it?