Re: Launching IMP or EXP from within Stored Procedure

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 04 Jul 2002 23:25:26 +0200
Message-ID: <o3f9iu8kf2j7aqrjm1v9pmibl0rrnecga1@4ax.com>

On Thu, 04 Jul 2002 20:15:42 GMT, "Xoxo" <simbaleroi_at_hotmail.com> wrote:

>Any one knows how to EXPORT or IMPORT from within the body of a Stored
>Procedure.
>

Why do it? Export and Import are separate tools requiring a second connection to the database. You would need to call them to an external procedure using the system call to start up a separate shell environment. In short, you are going to create havoc. And you don't want an end-user to be capable to export the database to their own system, do you.
There are numerous facilities available to process export through batch-mechanisms, please use those.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jul 04 2002 - 16:25:26 CDT