表格名称超过30个字符 [英] Table Name with more than 30 characters

问题描述

我在MySQL数据库中有一个表.表格名称超过30个字符 并且我想在Oracle 11g中创建相同的表，但是Oracle仅允许名称中最多包含30个字符的表.
我不能将表的名称更改为少于30个字符，因为系统是基于这些表的，如果更改名称，这将花费我很多钱，所以更改表名称不是我的答案正在寻找.

有一个名为user_tables的表，当我描述该表时，它说table_name字段的数据类型为varchar2(30)，因此我试图更改该表并制成table_name varchar2(255)，但我无法t，它给我一个错误，说:

ORA-00942:表或视图不存在

我以sys身份连接.

有人知道如何解决我的问题吗?

解决方案

所有Oracle标识符均限制为30个字符.没有选项可以更改.

I have a table in a MySQL database. The name of the table is more than 30 characters long and I want to make the same table in Oracle 11g, but Oracle only allows tables with a maximum of 30 characters in the name.
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 me a lot if I change the name, so changing the table name is not the answer I am looking for.

There is a table called user_tables, and when I describe the table it says the the table_name field has a datatype varchar2(30), so I tried to alter the table and make the table_name varchar2(255) but I couldn't, it gives me an error saying:

ORA-00942: table or view does not exist

I am connect as sys.

Does anyone know how to solve my problem?

解决方案

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

这篇关于表格名称超过30个字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！