Search the web
Sign In
New User? Sign Up
oo4ole · Oracle Objects for OLE (OO4O) Users List
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Schema Object Naming Rules   Message List  
Reply | Forward Message #1809 of 1863 |

Schema Object Naming Rules

In order to know the schema objects please have a look at http://arjudba.blogspot.com/2008/06/database-objects-in-oracle.html
There are some rules to name a schema objects which are defined below.

•Schema name as well as database objects name can be specified within double quotes and without quotes.

•DB_NAME, GLOBAL_NAME, and database link names are always case insensitive and are stored as uppercase. So if you specify these names as quoted identifiers, then the quotation marks are silently ignored.

•Database name can have maximum 8 bytes.

•Database Link name can have maximum 128 bytes.

•Schema name other than DB_NAME and database link name can be 1 to 30 bytes long.

•If an identifier includes multiple parts then each attribute can be up to 30 bytes long.

To know more visit http://arjudba.blogspot.com/2008/07/schema-object-naming-rules.html


Not happy with your email address?
Get the one you really want - millions of new email addresses available now at Yahoo!

Thu Jul 3, 2008 7:37 am

a_arju
Online Now Online Now
Send Email Send Email

Forward
Message #1809 of 1863 |
Expand Messages Author Sort by Date

Schema Object Naming Rules In order to know the schema objects please have a look at http://arjudba.blogspot.com/2008/06/database-objects-in-oracle.html There...
m arju
a_arju
Online Now Send Email
Jul 3, 2008
7:37 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help