Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: imp/exp and stored procedure
Hans Forbrich wrote:
> Jaret Lafoudravecmonhnez wrote:
>
>> 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.
>
> What database version and what kind of export? (For example - will
> the 9i R2 TABLESPACE export help?)
>
> If not 9iR2, are you exporting by userid? and how flexible is the
> ownership of the SP? (eg: 3rd party app?)
Oracle 8.1.6, in user mode. SP are in the user sheme. Received on Thu Jun 26 2003 - 03:56:17 CDT
![]() |
![]() |