Re: How do you change an SID

barry.roomberg_at_compudata.com (BARRY ROOMBERG) writes:
:
: Depends. If you have O7, then a simple CREATE CONTROLFILE with
: the change name option will doit.
:
: If O6, then you gotta recreate and import.

I think you are confusing the Database Name and the SID. They are not the same thing.
The SID(at least on Unix ports) can be changed quite easily. Simply shutdown the db, change it in /etc/oratab, and change the name of your init file to init<new_sid>.ora.
The SID is simply used to locate a default INIT file(if pfile is not used on startupe), and the default control file names(if control_files parameter does not exist in your INIT file).

To change the database name, the above is correct.

--
regards,
Carl
+-----------------------------------------------------------------------------+
Carl Gohringer, European Development Centre 
Oracle Park, Bittams Lane, Chertsey, Surrey, England, KT16 9RG
Internet   : cgohring_at_uk.oracle.com    
+-----------------------------------------------------------------------------+