Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    2

    Unanswered: Schema name length

    Is there a restriction on the length of a schema name in Oracle 9i? What is the maximum allowable length?

    I am making calls from ProC and what appears to be happening is that Oracle is accessing the shared pool for the another schema on the same database (there are 4 schemas currently on this database). The username/password is correct. This is an intermittent problem that seems only to occur when the shared pool begins to fill up with entries from the various schemas and the ProC/Oracle identifies the incorrect schema.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Maximum schema name length is 30 bytes.

    Check this document to read more about schema objects naming rules.

  3. #3
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Maximum length of any object name (including schemas) in Oracle is 30 chars.

Posting Permissions

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