Export PL/SQL Developer mode extremely slow to start

[armando]

I am trying to export several thousand tables, but not much data from a nearly empty, customized, PeopleSoft database. Even when I select only a few tables to export, Export Tables "hangs" while displaying "Analyzing table dependencies...". Last time, I let it try for one hour and finally killed it. Are there know limitations precluding exporting from schemas with so many tables or is there some trick I should know? I don't have "export" privs to the database, so that is why I can't use exp/dp.

Thanks. BTW, I have used PL/SQL Dev on and off for nearly 10 years. It is still the best for coding PL/SQL.

 

[armando]

It finally initiated an export of several hundred tables after 2 hours. I didn't trace the session but it looks like the "dependency analysis" needs to be optimized. Oracle 10.2.0.4 Plsqldev 8.0.2. Peoplesoft has around 50,000 tables so I won't be able to use this type of export, even in chunks.

 

[Marco Kalter]

We'll check it out.