Oracle DBA Tutorial

Members Login
Username 
 
Password 
    Remember Me  
Post Info TOPIC: What is a Schema Object and its rules?
Anonymous

Date:
What is a Schema Object and its rules?
Permalink   


Schema Object Naming Rules

The following rules apply when naming schema objects:

  1. Names must be from 1 to 30 bytes long with these exceptions:

     

    • Names of databases are limited to 8 bytes.

       

    • Names of database links can be as long as 128 bytes.

       

  2. Names cannot contain quotation marks.

     

  3. Names are not case sensitive.

     

  4. A name must begin with an alphabetic character from your database character set unless surrounded by double quotation marks.
All the rules can be read at http://oracleonline.info/schema_objects.html

__________________
Page 1 of 1  sorted by
Quick Reply

Please log in to post quick replies.



Create your own FREE Forum
Report Abuse
Powered by ActiveBoard