Search notes:

ORA-00972: identifier is too long

The maximum length for identifiers (column names etc.) is 128. Exceeding this limit results in the error message ORA-00972: identifier is too long.

select
   dummy this_identifier_has_148_characters_which_is_more_than_the_maximum_of_128_and_will_therefore_throw_the_error_message_ORA_00972_identifier_is_too_long
from
   dual;

Tablespace names

The limit for tablespace names is 30 characters (23c):

create tablespace an_identifier_with_32_characters
   datafile '&db_files_path/tq84_sf_perm_ext_mgmt_local_def_seg_mgmt_auto.dbf'
   extent        management local
   segment space management auto;
--
-- ORA-00972: The identifier AN_IDENTIF...2_CHARACTE... exceeds the maximum length of 30 bytes.
--

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759612607, '216.73.216.149', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/errors/ORA-00972_identifier-is-too-long(54): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78

ORA-00972: identifier is too long

Tablespace names

See also