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
Printable View
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
In general, how are exp and imp invoked? Via the command line. If in a script, depending on the language/shell/OS, how do you access other executables on the file system? In a UNIX shell script, for example, you can run/call any command. From within a programming language, you generally need to "host" out to the OS (open a door into the OS, do what you need to do, then exit, which brings you back inside your program). Start from here for your research.
Thanks for your answer, but my question is that:
create or replace procedure sp_exp()
as
begin
...... <How to exp here? >....
end sp_exp;
-Thanks again.
dbms_pipe, calling an external program (Pro*C will do). Or if 10g, dbms_scheduler.
May be you are looking for
dbms_datapump
dbms_metadata
http://www.devx.com/dbzone/Article/30355/0/page/2