Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2005
    Posts
    67

    Unanswered: max length of sequences name

    Hi.

    I'm trying to move from MSSQL to Oracle and I realised that Oracle 9i doesn't support tabla names up to 30 chars. (MSSQL support up to 128).
    Does anybody known the max size of other objects ?
    - Triggers
    - Indexes
    - Sequences
    - etc

    I think all of them support up to 30 chacaraters name.
    Is that right?

    Thanks!

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Yes, it is 30 max for everything.

  3. #3
    Join Date
    Sep 2005
    Posts
    67
    And what if I use synonyms?
    the same problem?

    Quote Originally Posted by andrewst
    Yes, it is 30 max for everything.

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    A synonym is just another object name and has the same restrictions as other objects (30). Also oracle, without special handling will not support lower case. Be careful what you use as a description.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    However, you CAN create a synonym with a name longer than 30 characters, but can't use it:
    Code:
    SQL> create synonym a12345678901234567890123456789012345 for emp;
    
    Synonym created.
    
    SQL> select count(*) from a12345678901234567890123456789012345;
    select count(*) from a12345678901234567890123456789012345
                         *
    ERROR at line 1:
    ORA-00972: identifier is too long
    
    
    SQL> drop synonym a12345678901234567890123456789012345;
    
    Synonym dropped.
    
    SQL>

  6. #6
    Join Date
    Sep 2005
    Posts
    67
    Yes, that's right.
    I can create synoyms longer, but it doesn't make sense :-)

    Quote Originally Posted by Littlefoot
    However, you CAN create a synonym with a name longer than 30 characters, but can't use it:
    Code:
    SQL> create synonym a12345678901234567890123456789012345 for emp;
    
    Synonym created.
    
    SQL> select count(*) from a12345678901234567890123456789012345;
    select count(*) from a12345678901234567890123456789012345
                         *
    ERROR at line 1:
    ORA-00972: identifier is too long
    
    
    SQL> drop synonym a12345678901234567890123456789012345;
    
    Synonym dropped.
    
    SQL>

  7. #7
    Join Date
    Sep 2005
    Posts
    67
    And what about 10g?
    Does ti have same limitations?

  8. #8
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Yes it does.

  9. #9
    Join Date
    Sep 2005
    Posts
    67
    OK, thanks andrewst :-)

    Now I have a good reason to keep the name shorts.

    Quote Originally Posted by andrewst
    Yes it does.

Posting Permissions

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