Re: imp/exp and stored procedure

#1

There is no parameters to include everything, yet exclude some objects.
About the best you can do is to export just tables and indexes. You
won't get the stored proc, but you also won't get views, functions,
sequences....

Is there a reason why you don't want this SP in the dump file?

HTH,
Brian

Jaret Lafoudravecmonhnez wrote:

Quote:

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 ?

--
================================================== =================

Brian Peasland
oracle_dba (AT) remove_spam (DOT) peasland.com

Remove the "remove_spam." from the email address to email me.

"I can give it to you cheap, quick, and good. Now pick two out of
the three"

#2

"Jaret Lafoudravecmonhnez" <toto (AT) toto (DOT) com> wrote

Quote:

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 --

#3

Brian Peasland wrote:

Quote:

There is no parameters to include everything, yet exclude some
objects. About the best you can do is to export just tables and
indexes. You won't get the stored proc, but you also won't get views,
functions, sequences....

Is there a reason why you don't want this SP in the dump file?

Yes, we have a very large amount of SP and they take ages to import/export.

#4

Typically, it is the size of the data, not the amount of stored procs
that influence the export/import runtimes.......

Is it possible to just export the tables? You'll get indexes,
constraints, and triggers on those tables as well. But like I said
before, you won't get views, functions, etc.

HTH,
Brian

Jaret Lafoudravecmonhnez wrote:

Quote:

Brian Peasland wrote:
There is no parameters to include everything, yet exclude some
objects. About the best you can do is to export just tables and
indexes. You won't get the stored proc, but you also won't get views,
functions, sequences....

Is there a reason why you don't want this SP in the dump file?

Yes, we have a very large amount of SP and they take ages to import/export.

--
================================================== =================

Brian Peasland
oracle_dba (AT) remove_spam (DOT) peasland.com

Remove the "remove_spam." from the email address to email me.

"I can give it to you cheap, quick, and good. Now pick two out of
the three"

#5

Hans Forbrich wrote:

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: imp/exp and stored procedure

comp.databases.oracle.misc comp.databases.oracle.misc

Re: imp/exp and stored procedure - 06-25-2003 , 09:07 AM

Re: imp/exp and stored procedure - 06-25-2003 , 09:13 AM

Re: imp/exp and stored procedure - 06-25-2003 , 10:32 AM

Re: imp/exp and stored procedure - 06-25-2003 , 11:03 AM

Re: imp/exp and stored procedure - 06-26-2003 , 03:56 AM