日期:2014-05-16 浏览次数:20428 次
DROP TABLE tab01; SELECT * FROM tab01; CREATE TABLE tab01 (ID NUMBER NOT NULL PRIMARY KEY, NAME VARCHAR2(50) ); SELECT index_name,a.status FROM User_Indexes a WHERE index_name IN ('SYS_C0098887','IDX_NAME'); ALTER TABLE tab01 MOVE; INSERT INTO tab01 SELECT object_id,object_name FROM user_objects WHERE object_id IS NOT NULL; INSERT INTO tab01 SELECT 1,'a' FROM dual; INSERT INTO tab01 SELECT 2,'b' FROM dual; ALTER INDEX SYS_C0098885 REBUILD; CREATE INDEX idx_name ON tab01(name); SELECT * FROM tab01; UPDATE tab01 SET NAME='aaaa' WHERE NAME ='SRC_PROV';