Results 1 to 5 of 5

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

  1. #1
    Join Date
    Jul 2005
    Posts
    35

    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

  2. #2
    Join Date
    Oct 2005
    Posts
    2,557
    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.

  3. #3
    Join Date
    Jul 2005
    Posts
    35
    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.

  4. #4
    Join Date
    Oct 2005
    Posts
    2,557
    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.

  5. #5
    Join Date
    Jan 2006
    Posts
    1
    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
  •