《Oracle数据库对象管理—表管理》由会员分享,可在线阅读,更多相关《Oracle数据库对象管理—表管理(6页珍藏版)》请在金锄头文库上搜索。
1、SQL create tablespace OrclTBS012 datafile C:appAdministratororadataorclOrclTBS02.dbf size 50m3 extent management local autoallocate;alter tablespace Orcltbs01 rename to Orcltbs03;select * from v$tablespace;create temporary tablespace temtbs tempfile C:appAdministratororadataorcltmptbs.dbf size 20m r
2、euse extent management local uniform size 16m;alter tablespace temtbs add tempfile C:appAdministratororadataorcltmptbs01.dbf size 20m;alter tablespace orcltbs03 offline;select tablespace_name,contents,status from dba_tablespaces;alter tablespace orcltbs03 online;alter tablespace orcltbs03 read only;
3、alter tablespace orcltbs03 read write;Drop tablespace orcltba03;Col 回滚段数 for A20Select SEGMENT_NAME 回滚段名,TABLESPACE_NAME 所在表空间,bytes 大小From dba_select where select_type=rollback;COL NAME FOR A12 SELECT S.USN,N.NAME,S.RSSIZE,S.STAYUS FROM V$ROLLSTAT S,V$ROLLNAME N WHERE S.USN=N.USN;ALTER SYSTEM SET U
4、NDO_MANAGENMENT=MANUAL SCOPE=SPFILE;SHOW PARAMENTER UNDO_MANAGEMENT;SQL CREATE ROLLBACK SEGMENT ORCLRS012 TABLESPACE UNDOTBS13 STORAGE (INITIAL 5M NEXT 2M MAXEXTENTS UNLIMITED);SQL ALTER ROLLBACK SEGMENT ORCLRS01 ONLINE;SELECT NAME,STATUS FROM V$ROLLNAME,V$ROLLSTAT WHERE V$ROLLSTAT.USN=V$ROLLNAME.USN;ALTER ROLLBACK SEGMENT ORCLRS01 SHRINK TO 1M;ALTER ROLLBACK SEGMENT ORCLRS01 OFFLINE;DROP ROLLBACK SEGMENT ORCLRS01;