ORA-19712: table name exceeds maximum length of string

Cause : The table name string exceeds maximum length.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Retry the operation with a shorter table name.

update : 21-08-2017
ORA-19712

ORA-19712 - table name exceeds maximum length of string
ORA-19712 - table name exceeds maximum length of string

  • ora-14050 : invalid ALTER INDEX MODIFY PARTITION option
  • ora-16247 : DDL skipped on internal schema
  • ora-02061 : lock table specified list of distributed tables
  • ora-12415 : A column of another datatype exists on the specified table
  • ora-32320 : REFRESH FAST of "string"."string" unsupported after container table PMOPs
  • ora-13151 : failed to remove exception record
  • ora-13380 : network not found
  • ora-30553 : The function is not deterministic
  • ora-39048 : Unable to start all workers; only string worker(s) available.
  • ora-01172 : recovery of thread string stuck at block string of file string
  • ora-31076 : required attribute "string" not specified
  • ora-17626 : ksfdcre: string file exists
  • ora-06534 : Cannot access Serially Reusable package string
  • ora-15067 : command or option incompatible with diskgroup redundancy
  • ora-19500 : device block size string is invalid
  • ora-28508 : invalid value string for Heterogeneous Services initialization parameter string
  • ora-01557 : rollback segment extents must be at least string blocks
  • ora-10563 : Test recovery had to corrupt data block (file# string, block# string) in order to proceed
  • ora-31203 : DBMS_LDAP: PL/SQL - Init Failed.
  • ora-01303 : subordinate process error: number. Check alert and trace logs
  • ora-12827 : insufficient parallel query slaves available
  • ora-28668 : cannot reference mapping table of an index-organized table
  • ora-12841 : Cannot alter the session parallel DML state within a transaction
  • ora-19608 : %s is not a backup piece
  • ora-27162 : thread creation failed
  • ora-16023 : system string destination cannot be the same as session string destination
  • ora-29552 : verification warning: string
  • ora-12435 : invalid audit success: string
  • ora-00117 : PROTOCOL, ADDRESS or DESCRIPTION must be specified
  • ora-29315 : tablespace 'string' has been recreated
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.