Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > 调整表的CHAR/VARCHAR2字段的Byte为CHAR

调整表的CHAR/VARCHAR2字段的Byte为CHAR

WBOY
Release： 2016-06-07 17:18:46
Original
1378 people have browsed it

调整表的CHAR/VARCHAR2字段的Byte为CHAR,对于那些作为分区列的字段不能修改，会出现如下错误，并且会退出，所以最好是把命令输出

调整表的CHAR/VARCHAR2字段的Byte为CHAR

使用如下SQL脚本即可：

注：对于那些作为分区列的字段不能修改，会出现如下错误，并且会退出，所以最好是把命令输出到一个sql脚本里面，然后在sqlplus命令行里面去执行，，也可以写成存储过程然后捕获异常并继续。

ERROR at line 1:
ORA-14060: data type or length of a table partitioning column may not be changed
ORA-06512: at line 10

linux

Related labels：
Oracle基础 调整表的CHAR/VARCHAR2字段的B
source：php.cn
Previous article：ORA-15064 错误解决 Next article：重启数据库遇到PRCR-1079，CRS-2640
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
modal counter I'm trying to create a modal with a +/- counter. However, I think since the state is in th...
From 2024-04-03 14:16:44
0
1
298
Button activation causes hover effect to malfunction I've been trying to learn the basics of web development (HTML, CSS, and JS), so I've been ...
From 2024-04-01 21:51:26
0
1
396
Can't center text using CSS + HTML I'm trying to center text using CSS and HTML. I'm very new to web development so I'm just ...
From 2024-03-31 15:57:04
0
1
322
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template