Re: imp/exp and stored procedure

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 25 Jun 2003 07:13:51 -0700
Message-ID: <2687bb95.0306250613.6b48a50e@posting.google.com>

"Jaret Lafoudravecmonhnez" <toto_at_toto.com> wrote in message news:<bdbl4v$gth$1_at_reader1.imaginet.fr>...
> Hello,
>
>
> Can I use the imp/exp utility but not include stored procedure in the dump,
> I need to imp/exp all the object but the SP.
>
> Any idea ?

Prepare a drop script for the procedures; run the export; perform the import; and then run the drop script on the target database. This is probably the easiest route to take.

IMO -- Mark D Powell -- Received on Wed Jun 25 2003 - 09:13:51 CDT