Oracle 9.2.0 on Solaris 2.8 - I've got global_name = FALSE and db_domain = "" - however I mistakenly issued the command alter database rename global_name to instance.world, and now I cannot get rid of it.
I've found the following on Metastink, but am wondering if there is any other method of getting the global_name back to instancename (without the .world) This problem doesn't happen in 9i because a value NULL for db_domain is allowed, therefore if you set in 9i db_domain="", then you have a GLOBAL_NAME with only db_name and you can rename global_name to include domain and after rename it back without including domain. Updating props$ manually is not a supported workaround. Any help would be appreciated. TIA, mb __________________________________________________ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Barger INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
