How to perform an exp/imp within a stored procedure?

Ach · #1 (**permalink**) 01-21-06, 11:17

Hi all,
Is there any way to perform an exp/imp from within a stored procedure? Any built-in package or script?
-Thanks in advance for your attention

WilliamR · #2 (**permalink**) 01-21-06, 11:34

exp and imp are standalone command-line utilities.

In 10g you may be able to unload data using the ORACLE_DATAPUMP access driver, which is not quite the same thing, but is similar.

Ach · #3 (**permalink**) 01-21-06, 11:41

Thanks William,
I meant if there is any way to access OS shell so I could perform command-line utilities...
-Regards

AlanP · #4 (**permalink**) 01-21-06, 17:27

Go to asktom he has a java stored procedure to call the OS, I seem to remember it being called rc(). We use it to call the export utility in win2000 and it seems to work well.

Alan

ladwig · #5 (**permalink**) 01-23-06, 02:33

Hi,
it is possible to write a *.bat. This *.bat you can start within any other script or program. *.bat contents: exp usr/pwd@sid file: .....

Internet Services

Web Development

Digital Marketing

Consumer Tech