- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Export/import procedures....
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-18-2007 10:35 PM
тАО10-18-2007 10:35 PM
Export/import procedures....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-19-2007 12:09 AM
тАО10-19-2007 12:09 AM
Re: Export/import procedures....
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
Or could you clarify a little more....
Rgrds,
Rita
...but it's early and I haven't half finished my first cup of coffee...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-19-2007 01:18 AM
тАО10-19-2007 01:18 AM
Re: Export/import procedures....
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-19-2007 01:28 AM
тАО10-19-2007 01:28 AM
Re: Export/import procedures....
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-19-2007 06:24 PM
тАО10-19-2007 06:24 PM
Re: Export/import procedures....
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2007 04:01 AM
тАО11-26-2007 04:01 AM
Re: Export/import procedures....
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 =
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2007 04:20 AM
тАО11-26-2007 04:20 AM
Re: Export/import procedures....
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