oracle数据库对象管理—表管理

《oracle数据库对象管理—表管理》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、SQL>createtablespaceOrclTBS012datafile'C:appAdministratororadataorclOrclTBS02.dbf'size50m3extentmanagementlocalautoallocate;altertablespaceOrcltbs01renametoOrcltbs03;select*fromv$tablespace;createtemporarytablespacetemtbstempfile'C:appAdministratororadataorcltmptbs.db

2、f'size20mreuseextentmanagementlocaluniformsize16m;altertablespacetemtbsaddtempfile'C:appAdministratororadataorcltmptbs01.dbf'size20m;altertablespaceorcltbs03offline;selecttablespace_name,contents,statusfromdba_tablespaces;altertablespaceorcltbs03online;altertablespaceorclt

3、bs03readonly;altertablespaceorcltbs03readwrite;Droptablespaceorcltba03;Col回滚段数forA20SelectSEGMENT_NAME回滚段名，TABLESPACE_NAME所在表空间，bytes大小Fromdba_selectwhereselect_type=’rollback’;COLNAMEFORA12SELECTS.USN,N.NAME,S.RSSIZE,S.STAYUSFROMV$ROLLSTATS,V$ROLLNAMENWHERES.USN=N.USN;ALTERSYS

4、TEMSETUNDO_MANAGENMENT=MANUALSCOPE=SPFILE;SHOWPARAMENTERUNDO_MANAGEMENT;SQL>CREATEROLLBACKSEGMENTORCLRS012TABLESPACEUNDOTBS13STORAGE(INITIAL5MNEXT2MMAXEXTENTSUNLIMITED);SQL>ALTERROLLBACKSEGMENTORCLRS01ONLINE;SELECTNAME,STATUSFROMV$ROLLNAME,V$ROLLSTATWHEREV$ROLLSTAT.USN=V$ROLLNA

5、ME.USN;ALTERROLLBACKSEGMENTORCLRS01SHRINKTO1M;ALTERROLLBACKSEGMENTORCLRS01OFFLINE;DROPROLLBACKSEGMENTORCLRS01;