topic Export/import procedures.... in Operating System - HP-UX

Export/import procedures....

Ramana.Sv — Fri, 19 Oct 2007 05:35:15 GMT

How do you export/import a stored procedure/function/package? Is it possible?

Re: Export/import procedures....

Rita C Workman — Fri, 19 Oct 2007 07:09:12 GMT

Maybe I'm missing something here.

export/import is generally the term for what is done with volume groups and making them available to other nodes.

Procedures/functions - that sounds like programming and obviously you can move all or parts of a program/scripts.

Package - try MC/SG and it's called cmhaltpkg and cmrunpkg -n pkgname to move it from node to node.

Or could you clarify a little more....

Rgrds,
Rita

...but it's early and I haven't half finished my first cup of coffee...

Re: Export/import procedures....

Hein van den Heuvel — Fri, 19 Oct 2007 08:18:21 GMT

Hi Rita!

The question Ramana asks has nothing to do at all with HPUX and everything and only with Oracle. That's why it was put under the database category.

I just don't get it though.
I recognize that we are an extremely nice and helpful bunch here, but why would anyone in their right mind not go to Oracle/Oracle Forums/Oracle newsgroups/Oracle support to ask a question which is 100% Oracle dependent and has 0% platform contents.

By all means, if you'd like to know how to best create an Oracle datafile under hpux, or how to use LVM to set up a specific structure for Oracle, by all means do ask here. And more power to you if you can stick it in the database category, not general, but please let there be some hpux, or even just hp, component to this!

Ramana, don't take this personal, it's just a generic comment which I reserve for every 100th time someone asks a pure, and obvious 100% non-hpux related question in the hpux forum. The other 99 times I just answer and score some easy points (or not).

Just please realize that you are shortchanging yourself, your boss, and most importantly your customers by asking Oracle questions to well meaning HPUX helpers.

'nuff said!

Regards,
Hein.

Re: Export/import procedures....

Rita C Workman — Fri, 19 Oct 2007 08:28:30 GMT

Well Good Morning Hein,

Totally snoozing past that point. See - I really do need my coffee in the morning.

Ramana...agree with Hein, you will get far better answers from an Oracle Forum. But, we'll be here when you need some HPUX or SAN help.

Regards,
Rita

Re: Export/import procedures....

Yogeeraj_1 — Sat, 20 Oct 2007 01:24:12 GMT

Hi Ramana,

One way would be to:

exp userid=old_user/pw owner=old_user rows=n

imp userid=new_user/pw fromuser=old_user touser=new_user

That would do a structural copy of the old_user to the new_user but not pull any data over. Now you can drop anything you don't want.

hope this helps!
kind regards
yogeeraj

Re: Export/import procedures....

Jeff Crew — Mon, 26 Nov 2007 12:01:44 GMT

My preference to "Reverse Engineer" Oracle stored code would be the following:
1) Use a GUI tool like Quest S/w TOAD or Oracle SQL developer. Then copy and paste the code (Pkg, Procedure, Function, Trigger, etc) into an editor.
2) Write a query to extract the code from the table DBA_SOURCE to grab the data in TEXT where the NAME = and TYPE = and be sure to order by the NUMBER column too.

You will need to add a "CREATE OR REPLACE

 " line at the beginning of the query to update or import the exported code. And set you linesize huge since TEXT is a varchar2(4000).

desc dba_source
Name     Null     Type                                                                                                                                                                                          
-------- -------- --------------
OWNER             VARCHAR2(30)                                                                                                                                                                                  
NAME              VARCHAR2(30)                                                                                                                                                                                  
TYPE              VARCHAR2(12)                                                                                                                                                                                  
LINE              NUMBER                                                                                                                                                                                        
TEXT              VARCHAR2(4000)

Re: Export/import procedures....

Geoff Wild — Mon, 26 Nov 2007 12:20:46 GMT

And speeking of points....

Ramana, has assigned points to 25 of 214 responses to questions.

http://forums1.itrc.hp.com/service/forums/pageList.do?userId=CA1502188&listType=unassigned&forumId=1

Rgds...Geoff