Oracle中关于恢复unused列的方法
2 -----------------------系统的字段数目也发生了变化 SQL> update col$ set col#=intcol# where obj#=52717;3 rows updated.
SQL> update tab$ set cols=cols+1 where obj#=52717;
1 row updated.
SQL> update col$ set name='AGE' where obj#=52717 and col#=3;
1 row updated.
SQL> update col$ set property=0 where obj#=52717;
3 rows updated.
SQL> commit;
Commit complete.
SQL> startup force; -----------这一步是必不可少的
页:
[1]