Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    370

    Question Unanswered: 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
    Sep 2004
    Location
    London, UK
    Posts
    565
    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.

  3. #3
    Join Date
    Mar 2004
    Posts
    370
    Thanks William,
    I meant if there is any way to access OS shell so I could perform command-line utilities...
    -Regards

  4. #4
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    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

  5. #5
    Join Date
    May 2002
    Location
    Osnabrueck Germany
    Posts
    59
    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: .....
    Juergen Ladwig

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •