Do you want to change sid or db name?
select instance from v$thread; will return sid
select name from v$database; will return dbname

-----Original Message-----
From: Ahmed Baig [mailto:[Email Address Removed] Thursday, May 31, 2001 6:45 AM
To: LazyDBA.com Discussion
Subject: Changing Database SID


Hi List,

I need to change the SID of my database running on NT Box,would be glad if
anyone can send me the steps to do it ,i have tried using the ORADIM utility
by a creating a duplicate Init<sid>.ora file but unfortunately had no
success the Database is 8.0.3

TIA
Afaq Baig


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page