大型數據庫系統中往往要用到查詢統計
以oracle
設置數據表空間的SQL語句如下
CREATE TABLESPACE WXGL_DATA
增加系統臨時表空間和回滾段表空間的SQL語句如下
ALTER TABLESPACE TEMPORARY_DATA ADD DATAFILE
ALTER TABLESPACE ROLLBACK_DATA ADD DATAFILE
將數據空間設置在指定的數據文件的SQL語句如下
CREATE USER ZBGL IDENTIFIED BY ZBGL;
GRANT DBA TO ZBGL;
ALTER USER ZBGL DEFAULT TABLESPACE WXGL_DATA
SELECT SEGMENT_NAME FROM DBA_ROLLBACK_SEGS WHERE INITIAL_EXTENT <
UPPPER(OWNER) =
SELECT UPPER(STATUS) FROM DBA_ROLLBACK_SEGS WHERE UPPER(SEGMENT_NAME) =
ALTER ROLLBACK SEGMENT RB
ALTER ROLLBACK SEGMENT RB
ALTER ROLLBACK SEGMENT RB
ALTER ROLLBACK SEGMENT RB
ALTER ROLLBACK SEGMENT RB
DROP ROLLBACK SEGMENT RB
DROP ROLLBACK SEGMENT RB
DROP ROLLBACK SEGMENT RB
DROP ROLLBACK SEGMENT RB
DROP ROLLBACK SEGMENT RB
CREATE PUBLIC ROLLBACK SEGMENT RB
STORAGE (INITIAL
CREATE PUBLIC ROLLBACK SEGMENT RB
STORAGE (INITIAL
CREATE PUBLIC ROLLBACK SEGMENT RB
STORAGE (INITIAL
CREATE PUBLIC ROLLBACK SEGMENT RB
STORAGE (INITIAL
CREATE PUBLIC ROLLBACK SEGMENT RB
STORAGE (INITIAL
ALTER ROLLBACK SEGMENT RB
ALTER ROLLBACK SEGMENT RB
ALTER ROLLBACK SEGMENT RB
ALTER ROLLBACK SEGMENT RB
ALTER ROLLBACK SEGMENT RB
COMMIT;
KCB=
+
+
+
+
+
+
+
+
QCFL =
+
+
+
+
From:http://tw.wingwit.com/Article/program/Oracle/201311/18984.html