-
How to perform an exp/imp within a stored procedure?
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.
Last edited by stecal; 01-21-2006 at 05:57 PM.
-
May be you are looking for
dbms_datapump
dbms_metadata
http://www.devx.com/dbzone/Article/30355/0/page/2
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|