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

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

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

2、euseextentmanagementlocaluniformsize16m;altertablespacetemtbsaddtempfile'C:appAdministratororadataorcltmptbs01.dbf'size20m;altertablespaceorcltbs03offline;selecttablespace_name,contents,statusfromdba_tablespaces;altertablespaceorcltbs03online;altertablespaceorcltbs03readonly;alterta

3、blespaceorcltbs03readwrite;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;ALTERSYSTEMSETUNDO_MANAGENMENT=MANUALS

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

5、KTO1M;ALTERROLLBACKSEGMENTORCLRS01OFFLINE;DROPROLLBACKSEGMENTORCLRS01;