DB_NAME specifies a database identifier of up to 8 characters.
The following characters are valid in a database name: alphanumeric
characters,
underscore (_), number sign (#), and dollar sign ($). No other
characters are valid.
Oracle removes double quotation marks before processing the database
name.
Therefore you cannot use double quotation marks to embed other
characters in the
name. The database name is case insensitive. In fact cannot use
non-ASCII characters in a database name and in the create database
statement. For example cannot use special characters from european \
asian character sets like characters with umlauts.
- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, June 30, 2003 21:19
: What are the restriction in naming an Oracle SID/Database?
:
: 1. Can I have special character in SID/Database name? e.g. Is a SID
name 'emp_prod' is allowed?
:
: 2. What is the maximum size of a SID/Database name in Unix?
:
: 3. What is the maximum size of a SID/Database name in Windows?
:
: 4. Is there any other restrictions?
:
:
:
: Thanks,
: Ashoke
:
: --
: Please see the official ORACLE-L FAQ: http://www.orafaq.net
: --
: Author: Mandal, Ashoke
: 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).
:
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
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).
Received on Mon Jun 30 2003 - 17:46:48 CDT
