創(chuàng)建表空間 SQL>?create?tablespace?soe datafile?'/u01/app/oracle/oradata/wallet/soe01.dbf' size?1024M extent?management?local uniform?size?1M; 擴(kuò)展表空間 方法一：在表空間中增加數(shù)據(jù)文件 SQL>?alter?tablespace?soe add?datafile?'/u01/app/oracle/oradata/wallet/soe02.dbf' size?2048M; 方法二：數(shù)據(jù)文件自動(dòng)擴(kuò)展 SQL>?alter?database?datafile?'/u01/app/oracle/oradata/wallet/soe01.dbf'?autoextend?on; 方法三：增加表空間中數(shù)據(jù)文件的大小 SQL>?alter?database?datafile?'/u01/app/oracle/oradata/wallet/soe01.dbf'?resize?2048M; 移動(dòng)表空間數(shù)據(jù)文件 SQL>?alter?tablespace?soe?offline;? SQL>?host?cp?/u01/app/oracle/oradata/wallet/soe02.dbf?/u02/app/oracle/oradata/wallet SQL>?alter?tablespace?soe rename?datafile?'/u01/app/oracle/oradata/wallet/soe02.dbf' to?'/u02/app/oracle/oradata/wallet/soe02.dbf'; SQL>?alter?tablespace?soe?online; SQL>?host?rm?-rf?/u01/app/oracle/oradata/wallet/soe02.dbf 刪除表空間 SQL>?drop?tablespace?soe?including?contents?and?datafiles;

創(chuàng)新互聯(lián)公司成立于2013年，是專業(yè)互聯(lián)網(wǎng)技術(shù)服務(wù)公司，擁有項(xiàng)目成都做網(wǎng)站、網(wǎng)站建設(shè)網(wǎng)站策劃，項(xiàng)目實(shí)施與項(xiàng)目整合能力。我們以讓每一個(gè)夢(mèng)想脫穎而出為使命，1280元薩迦做網(wǎng)站,已為上家服務(wù),為薩迦各地企業(yè)和個(gè)人服務(wù),聯(lián)系電話:18980820575創(chuàng)建臨時(shí)表空間 SQL>?create?temporary?tablespace?temp01 tempfile?'/u01/app/oracle/oradata/wallet/temp01.dbf' size?1024M extent?management?local uniform?size?1M; 擴(kuò)展臨時(shí)表空間 SQL>?alter?tablespace?temp01??????? add?tempfile?'/u01/app/oracle/oradata/wallet/temp02.dbf' size?1024M; 查詢數(shù)據(jù)庫(kù)默認(rèn)臨時(shí)表空間 SQL>?col?property_name?for?a40 SQL>?col?property_value?for?a40 SQL>?col?description?for?a40 SQL>?select?*?from?database_properties?where?property_name='DEFAULT_TEMP_TABLESPACE'; PROPERTY_NAME????????????????????????????PROPERTY_VALUE???????????????????????????DESCRIPTION ----------------------------------------?----------------------------------------?---------------------------------------- DEFAULT_TEMP_TABLESPACE??????????????????TEMP?????????????????????????????????????Name?of?default?temporary?tablespace 修改數(shù)據(jù)庫(kù)默認(rèn)臨時(shí)表空間 SQL>?alter?database?default?temporary?tablespace?temp01; SQL>?select?*?from?database_properties?where?property_name='DEFAULT_TEMP_TABLESPACE'; PROPERTY_NAME????????????????????????????PROPERTY_VALUE???????????????????????????DESCRIPTION ----------------------------------------?----------------------------------------?---------------------------------------- DEFAULT_TEMP_TABLESPACE??????????????????TEMP01???????????????????????????????????Name?of?default?temporary?tablespace 刪除臨時(shí)表空間 SQL>?drop?tablespace?temp?including?contents?and?datafiles;

創(chuàng)建UNDO表空間 SQL>?create?undo?tablespace?undotbs2 datafile?'/u01/app/oracle/oradata/wallet/undotbs02.dbf' size?2048M; 查詢活動(dòng)UNDO表空間 SQL>?show?parameter?undo_tablespace NAME?????????????????????????????????TYPE??????????????????????????????VALUE ------------------------------------?---------------------------------?------------------------------ undo_tablespace??????????????????????string????????????????????????????UNDOTBS1 SQL>?select?count(*)?from?dba_undo_extents?where?status?=?'ACTIVE'?and?tablespace_name?=?'UNDOTBS1'; ??COUNT(*) ---------- ?????????6 修改活動(dòng)UNDO表空間 SQL>?alter?system?set?undo_tablespace=undotbs2; SQL>?show?parameter?undo_tablespace NAME?????????????????????????????????TYPE??????????????????????????????VALUE ------------------------------------?---------------------------------?------------------------------ undo_tablespace??????????????????????string????????????????????????????UNDOTBS2? 刪除UNDO表空間 SQL>?select?count(*)?from?dba_undo_extents?where?status?=?'ACTIVE'?and?tablespace_name?=?'UNDOTBS1'; ??COUNT(*) ---------- ?????????0 ????????? SQL>?drop?tablespace?undotbs1?including?contents?and?datafiles;

SQL>?@dba_tablespaces.sql +------------------------------------------------------------------------+ |?Report???:?Tablespaces?????????????????????????????????????????????????| |?Instance?:?wallet??????????????????????????????????????????????????????| +------------------------------------------------------------------------+ Tablespace?Name????????????????Status????TS?Type?????????Ext.?Mgt.??Seg.?Mgt.????????TS?Size?(MB)??????????Used?(MB)?Pct.?Used ------------------------------?---------?---------------?----------?----------?------------------?------------------?--------- SYSAUX?????????????????????????ONLINE????PERMANENT???????LOCAL??????AUTO????????????????????2,048????????????????482????????24 UNDOTBS1???????????????????????ONLINE????UNDO????????????LOCAL??????MANUAL??????????????????1,024????????????????114????????11 TEMP???????????????????????????ONLINE????TEMPORARY???????LOCAL??????MANUAL??????????????????1,024?????????????????28?????????3 SYSTEM?????????????????????????ONLINE????PERMANENT???????LOCAL??????MANUAL??????????????????2,048????????????????738????????36 SOE????????????????????????????ONLINE????PERMANENT???????LOCAL??????AUTO????????????????????4,096??????????????1,035????????25 USERS??????????????????????????ONLINE????PERMANENT???????LOCAL??????AUTO????????????????????1,024??????????????????1?????????0 ???????????????????????????????????????????????????????????????????????????????------------------?------------------?--------- Average?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????16 Total??????????????????????????????????????????????????????????????????????????????????????11,264??????????????2,398 6?rows?selected. SQL>?@dba_file_space_usage.sql +------------------------------------------------------------------------+ |?Report???:?File?Usage??????????????????????????????????????????????????| |?Instance?:?wallet??????????????????????????????????????????????????????| +------------------------------------------------------------------------+ Tablespace?Name??????Filename??????????????????????????????????????????????FILE_ID?????File?Size?(MB)??????????Used?(MB)?Pct.?Used --------------------?--------------------------------------------------?----------?------------------?------------------?--------- SOE??????????????????/u01/app/oracle/oradata/wallet/soe01.dbf????????????????????5??????????????2,048????????????????522????????25 SOE??????????????????/u01/app/oracle/oradata/wallet/soe02.dbf????????????????????6??????????????2,048????????????????513????????25 SYSAUX???????????????/u01/app/oracle/oradata/wallet/sysaux01.dbf?????????????????2??????????????2,048????????????????482????????23 SYSTEM???????????????/u01/app/oracle/oradata/wallet/system01.dbf?????????????????1??????????????2,048????????????????738????????36 TEMP?????????????????/u01/app/oracle/oradata/wallet/temp01.dbf???????????????????1??????????????1,024?????????????????28?????????2 UNDOTBS1?????????????/u01/app/oracle/oradata/wallet/undotbs01.dbf????????????????3??????????????1,024????????????????114????????11 USERS????????????????/u01/app/oracle/oradata/wallet/users01.dbf??????????????????4??????????????1,024??????????????????1?????????0 ???????????????????????????????????????????????????????????????????????????????????------------------?------------------?--------- Average?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????17 Total??????????????????????????????????????????????????????????????????????????????????????????11,264??????????????2,398 7?rows?selected.

另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無(wú)理由+7*72小時(shí)售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國(guó)服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡(jiǎn)單易用、服務(wù)可用性高、性價(jià)比高”等特點(diǎn)與優(yōu)勢(shì)，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場(chǎng)景需求。

本文名稱：【OracleDatabase】數(shù)據(jù)庫(kù)表空間管理-創(chuàng)新互聯(lián)
標(biāo)題鏈接：http://vcdvsql.cn/article28/hdjjp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供Google、網(wǎng)站營(yíng)銷、ChatGPT、手機(jī)網(wǎng)站建設(shè)、自適應(yīng)網(wǎng)站、搜索引擎優(yōu)化

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)