Out of memory error

[rsarwar]

PL/SQL Developer version: 5.1.6.747
Oracle: 9iR2 and above
Windows XP SP1 with 1GB RAM

We have more then 28000 objects for a particular user (select count(*) from user_objects). When I try to Tools -> Export User Objects..., plsqldev session sucks upto 650MB of memory off my machine and then throws "Out of memory" error. I have an object selection file (.osf) and want to only export about 50 objects but there is no way I can ONLY load those objects from the file without having to load all 28000+ objects.

Is this a bug or is there a workaround for this?

Regards
/Rauf

 

[Oren]

Try using the EXP command line utility.

 

[Marco Kalter]

Or version 6.0, which fixes this resource problem.

 

[rsarwar]

As I mentioned in my post, I just want to export source for about 50 packages out of few 1000's and, AFAIK, you cannot do that using exp/imp. If you know of any undocumented exp feature then I am all ears.

Cannot upgrade to 6.0 on my own unless it is company wide. Looks like I have to create a sql script (which I was trying to avoid) to spool from user_source.

Thanks for the info. anyways.

Regards