Re: ORACLE_SID - how many characters?
Date: Tue, 22 Mar 1994 07:44:39 CST
Message-ID: <1994Mar22.074439.12213_at_amoco.com>
In article 29221_at_metagen.co.uk, sjs_at_metagen.co.uk ( Simon Stearn BT group) writes:
-->In article <19940321.064641.996_at_almaden.ibm.com>, alanb_at_vnet.IBM.COM (Alan Beal) writes:
-->|> I have seen some Oracle manuals state that ORACLE_SID must be 4
-->|> characters or less. But it appears that it can be longer. What
-->|> exactly is the maximum length for ORACLE_SID on UNIX systems?
-->|>
-->|> Alan Beal alanb_at_vnet.ibm.com
-->|> (607)751-2026
-->ORACLE_SID is an environment variable - it can be as long as a long thing. The
-->thing is, Oracle only looks at the first 4 characters.
Not True. We have multiple instances called PROJECT1 , PROJECT2 ...PROJECT5
If Oracle only looked at the first 4 chars then we'd have problems with these, and we don't have problems , so you're statement is inaccurate.
8 characters is the max for Unix AFAIK
--- ------------------------------------------------------------------------------ David Crowson =%^) |"For my part, I travel not to go anywhere, but to go. Oracle DBA(Ver.4,5,6,7)| I travel for travel's sake. The great affair is to Amoco Exploration | move, to get down off this featherbed of civilisation Ealing, London, UK. | and to find the globe granite underneath and strewn "My views not Amoex's" | with cutting flints" : Robert Louis StevensonReceived on Tue Mar 22 1994 - 14:44:39 CET