var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to perform an exp/imp within a stored procedure?
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
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.
I meant if there is any way to access OS shell so I could perform command-line utilities...
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.
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: .....