automate export user objects

[maxzsim]

Hi ,

I have a need to automate the "Export User Objects" for all the users connected to Oracle

how can i actually do that ?

pls advise

tks & rgds

 

[Marco Kalter]

No, this cannot be automated. You will have to connect as such a user, and explicitly export the objects.

 

[maxzsim]

Hi ,

What are the commands used to create these ddls so i can put into a procedures to automate it

tks & rgds

 

[maxzsim]

Hi Marco ,

I have thought that command lines is always more powerful than GUI ? if the GUI can export user objects then commandline will always be possibel to do it as well ?

will this be or going to be an enhancement in future releases ?

tks & rgds

 

[Marco Kalter]

We do indeed have an existing enhancement request to support commands like this from within the Command Window, which in turn can be executed from a Windows Command Line.

 

[maxzsim]

Hi,

Any idea when this enhancement will be out into place ?

Am able to use Oracle's own exp/imp from the command window but it's not as beautiful as using pl/sql's

tks & rgds

 

[Marco Kalter]

No, I don't have a concrete or planned date yet.