-
DB Name Changing
How can i change the database name in oracle8i of Windows 2k Server.
-
I'll give you two hints and then you can go read up on it.
oradim.
backup control file to trace.
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
Hi,
You can atleast make an effort to search this question within this forum or do you want us to do all the work for you?
Here's one of those links that might help you.
http://www.dbasupport.com/forums/sho...+database+name
-
Change of database name
Hi,
You cannot change the database name without re-creating the database as of now and per my knowledge.
Regards,
Jigar D Pota
************
Oracle Certified DBA
98791 88534
(We Live On !!)
-
Re: Change of database name
Originally posted by jigarpota
Hi,
You cannot change the database name without re-creating the database as of now and per my knowledge.
Regards,
Jigar D Pota
************
Oracle Certified DBA
98791 88534
(We Live On !!)
I would say recreate controlfile and not the database. You can rename a database by recreating the control files.
Amar
"There is a difference between knowing the path and walking the path."
-
Hi,
You cannot change the database name without re-creating the database as of now and per my knowledge.
Regards,
Jigar D Pota
************
Oracle Certified DBA
98791 88534
(We Live On !!)
Another example of why my Signature says what it says.
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
You don't even have to recreate the controlfile for changing database name. A simple ALTER DATABASE sql statement would be sufficient.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Originally posted by jmodic
You don't even have to recreate the controlfile for changing database name. A simple ALTER DATABASE sql statement would be sufficient.
U sure Jurij, did we not have an argument on when to recreate control files. AFAIK alter database is used to rename the GLOBAL_NAME and not the database name. You need to recreate control file to do that in Oracle8i and DBNEWID in Oracle9i and above.
Amar
"There is a difference between knowing the path and walking the path."
-
Re: Change of database name
Originally posted by jigarpota
Hi,
You cannot change the database name without re-creating the database as of now and per my knowledge.
Regards,
Jigar D Pota
************
Oracle Certified DBA
98791 88534
(We Live On !!)
OCP
proof that they are giving these away with Christmas crackers now
-
I think jurij agreed in old post regarding the same.In windows u are forced to use ORADIM to create a new service apart from control file recreation.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|