conn system/oracle SQL>CREATE TABLESPACE tbs_peenboo DATAFILE /oradata/tbs_peenboo_01.dbf size 10m EXTENTMANAGEMEN..."/>
您好,登錄后才能下訂單哦!
SQL>conn system/oracle SQL>CREATE TABLESPACE tbs_peenboo DATAFILE'/oradata/tbs_peenboo_01.dbf' size 10m EXTENTMANAGEMENT LOCAL AUTOALLOCATE SEGMENTSPACE MANAGEMENT AUTO; SQL>create table t_newtab(c1 date)tablespace tbs_peenboo; SQL>select extent_id,bytes from dba_extents Where owner='system' and segment_name='T_NEWTAB'; SQL>ALTER TABLE t_newtab ALLOCATE EXTENT; SQL>ALTERTABLESPACE T_PEENBOO OFFLINE; SQL>INSERT INTO T_NEWTAB VALUES (SYSDATE); ----ora-00376:file 6 cannot be read at this time SQL>ALTER TABLESPACE T_PEENBOO ONLINE; SQL>INSERT INTO T_NEWTAB VALUES (SYSDATE); ----1 rowcreated SQL>alter tablespace tbs_peenboo read only; SQL>INSERT INTO T_NEWTAB VALUES (SYSDATE); ----ora-00372: file 6 cannot be modified atthis time SQL>droptable t_newtab; ----tabledropped; SQL>alter tablespace tbs_peenboo read write; ----啟用OMF來創(chuàng)建數(shù)據(jù)文件 SQL>alter system set db_create_file_dest = '/oradata'; --用最少的語法創(chuàng)建表空間 SQL>create tablespace tbs_omfnew; --確定OMF文件的特性 SQL>selectfile_name,bytes, autoextensible,maxbytes,increment_by Fromdba_data_files where tablespace_name ='TBS_OMFNEW'; --調(diào)整OMF 文件,使特性趨于合理。 SQL>alter database datafile '/oradata/ORACLE11G/datefile/o1_mf_tbs_omfnew_3olpn462.dbf' Resize500m; SQL>alter database datafile '/oradata/ORACLE11G/datefile/o1_mf_tbs_omfnew_3olpn462.dbf' Autoextendon next 100m maxsize 2G; --刪除表空間 SQL>droptablespace tbs_omfnew including contents and datafiles;
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。