ORA-12988: cannot drop column from table owned by SYS
来源:互联网 发布:部落冲突刷钻石软件 编辑:程序博客网 时间:2024/04/24 14:48
在oracle中,sys用户下面的表中的列是不可用drop的,如果drop会报错:
SQL> desc test
Name Null? Type
------------------------------------------------- ----------------------------
ID NOTNULL NUMBER(38)
NAME VARCHAR2(20)
NAME1 CLOB
SQL> show user
USER is "SYS"
SQL> alter table test drop column name;
alter table test drop column name
*
ERROR at line 1:
ORA-12988: cannot drop column from tableowned by SYS
如果想删除sys表中的列,可以创建另一个表,与这个表的结构就差要删除的列,这样的话,如果表的数据量大,导数据会比较慢!
如需转载,请注明出处:http://blog.csdn.net/nanaranran/article/details/17281611
0 0
- ORA-12988: cannot drop column from table owned by SYS
- ORA-04089: cannot create triggers on objects owned by SYS
- DROP COLUMN ORA-12991 & ORA-12983
- ORA-01779: cannot modify a column which maps to a non-key-preserved table
- 解决错误ORA-01779: cannot modify a column which maps to a non-key-preserved table
- ORA-01779: cannot modify a column which maps to a non-key-preserved table分析
- ORA-01779: cannot modify a column which maps to a non key-preserved table
- ORA-01779: cannot modify a column which maps to a non key-preserved table
- ORA-01779: cannot modify a column which maps to a non-key-preserved table
- ORA-01653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
- 关于“ORA-01653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM”的错误
- ORA-01653:unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
- ora-01653: unable to extend table sys.aud$ by 8192 in tablespac system
- ora-01653: unable to extend table sys.aud$ by 8192 in tablespac system
- ORA-12032: cannot use rowid column from materialized view log on "DCS_BIZ"."TMP_12"
- Cannot send events to objects owned by a different thread
- java.sql.SQLSyntaxErrorException: ORA-01747: user.table.column, table.column
- ora-28014:cannot drop administrative users
- 11gR2 Ora2Ora 单向复制 GG
- try{} catch(…){}
- UML类图组成
- 【point-1】跨数据源的异构表数据的比较
- group by 还是 where
- ORA-12988: cannot drop column from table owned by SYS
- Nginx服务器,一段项目中的真实配置
- 生成APNS Service证书的步骤
- Windows环境下编译V8
- 配置 GG Manager process 配置
- 获取QRadioButton的值
- MySQL 中的树形数据处理示例
- 表值函数 fn_getTabStru ——获取某个表的表结构
- oracle 大数据 分页