- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle 7.3.4: How to change the database name
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
тАО12-27-2006 01:04 AM
тАО12-27-2006 01:04 AM
I have a oracle 7.3.4 database. I want to make clone this database and start with another name on same server. Is it possible ? if yes How ?
Thanks
Sunil
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-27-2006 01:12 AM
тАО12-27-2006 01:12 AM
Re: Oracle 7.3.4: How to change the database name
The easiest way is to create an empty database with another name on another location (directory).
Once this is done you can import the data from an export you have taken from the other database.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-27-2006 01:38 AM
тАО12-27-2006 01:38 AM
SolutionWow, what a question. Yes, it's absolutely possible to clone a database on the same host. I've done just many times, and have found these directions to be invaluable:
http://www.dba-oracle.com/oracle_tips_db_copy.htm
Note that the directions are for Oracle 8i, but should still be of use to you.
PCS
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-27-2006 04:14 PM
тАО12-27-2006 04:14 PM
Re: Oracle 7.3.4: How to change the database name
the only way to achieve this is through an export/import. You will need to create a new database with the desired new name and do the import on it.
I would also suggest that you migrate to a higher version. 8.1.7.4 should work as good as the 7.3.4. In 8i you have rman which facilitate these types of operations.
good luck!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-27-2006 10:27 PM
тАО12-27-2006 10:27 PM
Re: Oracle 7.3.4: How to change the database name
Sunil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-27-2006 11:41 PM
тАО12-27-2006 11:41 PM
Re: Oracle 7.3.4: How to change the database name
I'm sorry, but I disagree. The clone can be accomplished by copying the datafiles and configuration files, and then executing a controlfile creation script. I've done this many times.
PCS
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-28-2006 05:07 AM
тАО12-28-2006 05:07 AM
Re: Oracle 7.3.4: How to change the database name
Recreate the controlfile, and set the database name there. Make sure it matches in the init.ora file, and you're all done. It's pretty simple really.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-28-2006 06:52 PM
тАО12-28-2006 06:52 PM
Re: Oracle 7.3.4: How to change the database name
I am really sorry about what I wrote. I should not have said "only"! I more often think in terms of availability and keeping the database always UP. That's why I thought only about the exp/imp solution as being the best. same for rman.
You are both right. Your methods are the easiest to implement.
thank you for correcting me here!
wish best wishes for New year 2007
kind regards
yogeeraj