Exporting a standard set of tables data in PDE format

[lukeb]

I regularly use the export tables function(in PDE format) feature to move different sets of tables between DBs, however, I generally select a subset of 10 to 50 tables from a set of 200 tables wihtin a user. Doing this manually is very time consuming and each time I forget one table.

Is it possible to automate a PDE export of a list of tables - or even just automate the selection of tables in the export window ?

 

[admin]

Originally posted by lukeb:
I regularly use the export tables function(in PDE format) feature to move different sets of tables between DBs, however, I generally select a subset of 10 to 50 tables from a set of 200 tables wihtin a user. Doing this manually is very time consuming and each time I forget one table.

Is it possible to automate a PDE export of a list of tables - or even just automate the selection of tables in the export window ?

You may define a browser filter for the schema you connect.
In 'Where clause' of Define Browser Filters define your filter, for instance:
owner=user
and object_type = 'TABLE' and object_name LIKE 'REPORT%'.
It works fine for me.

 

[Marco Kalter]

In the current 5.1.1 version you can save and load Object Selection files. After making your selection of 10 to 50 tables, right click on it and select "Save Object Selection". For subsequent export operations you can right-click on the object selector and select "Load Object Selection".

------------------
Marco Kalter
Allround Automations

 

[admin]

Originally posted by mkalter:
In the current 5.1.1 version you can save and load Object Selection files. After making your selection of 10 to 50 tables, right click on it and select "Save Object Selection". For subsequent export operations you can right-click on the object selector and select "Load Object Selection".

Nice feature - even you can modify .osf text file outside PL/SQL Developer in text editor (add/delete object from the list) and it still works fine.

 

[lukeb]

Just upgraded to 5.1.1 thank you it is exactly what I was after.