All geek questions in one place

Table name with more than 30 characters

I have a table in a MySQL database. The table name is more than 30 characters. and I want to make the same table in Oracle 11g, but Oracle only allows you to use tables with a name of no more than 30 characters.
I can’t change the name of the table to make it less than 30 charachters, because the system is based on these tables, and it will cost a lot if I change the name, so changing the name of the table is not the answer I'm looking for.

There is a table called user_tables , and when I describe the table, it says that the table_name field has the data type varchar2(30) , so I tried to change the table and make table_name varchar2(255) , but I couldn’t, this leads to an error :

ORA-00942: table or view does not exist

I connect as sys .

Does anyone know how to solve my problem?

+4
source share
2 answers

All Oracle identifiers are limited to 30 characters. There is no option that allows you to change this.

+15
source

Synonyms will NOT work: source . The limits of 30 are tough and fast.

EDIT: After continuing research on oracle docs. If java is not present here in the comments, even a synonym will not work to exceed 30 characters.

Long story: you cannot do what you want to do in the oracle environment. A.

+3
source

Source: https://habr.com/ru/post/1388931/

More articles:


All Articles