Results 1 to 2 of 2

Thread: Oracle Names

  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: Oracle Names

    I'd like ot know what is the maximum length for the Oracle Object Names, such as

    Database Name - can be no more than 30 characters long.
    Table Name - can be no more than ?___? characters long.
    View Name - can be no more than ?___? characters long.
    Synonym Name - can be no more than ?___? characters long.
    Alias Name - can be no more than ?___? characters long.
    Sequence Name - can be no more than ?___? characters long.
    Index Name - can be no more than ?___? characters long.
    Column Name - can be no more than ?___? characters long.
    Schema Name -- can be no more than ?___? characters long.

    Thank you.
    Alexandra

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    Schema objects must be from 1 to 30 characters long
    A database name is limited to 8 characters
    A database link can be as long as 128 characters

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •