- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Advice on Export/Import from 9iR1 to 9iR2
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
тАО07-18-2007 04:01 AM
тАО07-18-2007 04:01 AM
We are moving from Oracle 9iR1 (on HP-UX 11i) to Oracle 9iR2 (on Red Hat Enterprise Linux 4). I'm wondering about the best method to accomplish the migration. It seems I have two choices:
1) USER EXP/IMP: Since the production data is only in 3 schemas, I could just export those 3 users and import them on the new db. However, I guess is not that simple. I'll need to create the user accounts (and other stuff residing in the sys/system schema).
2) FULL EXP/IMP: My only issue with this is that I'm coming from 9iR1 to 9iR2. I'm pretty sure the import won't overwrite already created objects on the sys/system schema but I'm not sure on importing a full dump from an earlier release. I have a different filesystem layout on the destination machine so I guess I'll need to create tablespaces manually before doing the full import. Is it really safe to perform this full import (even though is from an earlier release)?
What do you think is the best method? I'll appreciate your comments/suggestions.
Thanks,
Jorge
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-18-2007 04:20 AM
тАО07-18-2007 04:20 AM
Solutioni would definitely go for option 1.
i am currently doing the same but migrating from HP to an linux environment.
if you wish i can post some detailed guidelines.
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-18-2007 06:28 AM
тАО07-18-2007 06:28 AM
Re: Advice on Export/Import from 9iR1 to 9iR2
Yes, I'll appreciate any guidelines. So far I gathered a script I found (do a Google search on stub.sql oracle) that you run on the source DB and it will create a sql file with instructions for creating tablespaces etc...(all the infrasturcture). I need to verify the script since it's for 8i.
I was planning to do so manually but if you know of any script to prepare the target DB please let me know.
Are you moving from HP-UX to RHEL? and any change on database release?
Thanks!
Jorge
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-19-2007 02:11 AM
тАО07-19-2007 02:11 AM
Re: Advice on Export/Import from 9iR1 to 9iR2
- you can can make a full export
- Create the different tablespace and you 3 user in your new database.
- make import of each user
- compute the system stat on your new database.
We have made this way, and we was no trouble.
You should find that on Linux the import time is quit better
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2007 03:32 AM
тАО07-30-2007 03:32 AM