OCMÅàѵ¿Î³Ì-Server config Ö®¹ÜÀí±í¿Õ¼ä

OCM¿¼ÊÔ´ó¸ÙÕë¶Ô±í¿Õ¼äµÄÒªÇó£º

* Create and manage temporary, permanent, and undo tablespaces

* Create and manage bigfile tablespaces

Õâ¸ö»·½ÚµÄ¿¼µãÊÇÒªÇóÊìÁ·ÕÆÎÕ±í¿Õ¼ä¹ÜÀíµÄÓï¾ä£¬×îºÃÊǼÇÊ죬µ½Ê±²éÁª»úÎĵµ£¬Ê±¼ä¿ÉÄÜ»áºÜ½ôÕÅ¡£

1¡¢´´½¨ÆÕͨ±í¿Õ¼ä

sql> create tablespace ts1 datafile ¡®$ORACLE_BASE/oradata/orcl/datafile/ts1.dbf¡¯ size 100m

autoextend on next 10m maxsize 200m extent management local uniform size 128k

space segment space management auto;

-- extent management local¡¢space segment space management autoÊÇĬÈϵġ£

2¡¢´´½¨undo±í¿Õ¼ä

sql> create undo tablespace undo_ts2 datafile 'u01/app/oracle/oradata/orcl/datafile/undo_ts2.dbf' size 100m autoextend on next 10m maxsize 200m;

3¡¢´´½¨ÁÙʱ±í¿Õ¼ä

sql> CREATE TEMPORARY TABLESPACE temp2 TEMPFILE'u01/app/oracle/oradata/orcl/datafile/temp02.dbf'

SIZE 50M autoextend on next 10m maxsize 200m;

4¡¢´´½¨ÁÙʱ±í¿Õ¼ä×é

alter tablespace temp1 tablespace group temp_grp;

alter tablespace temp2 tablespace group temp_grp;

²é¿´Êý¾Ý¿âµ±Ç°Ä¬ÈÏÁÙʱ±í¿Õ¼ä£º

select property_name,property_value from database_properties where property_name like '%TEMP%'

-------------------------------------------------------------------------------------------

DEFAULT_TEMP_TABLESPACE TEMP

ÐÞ¸ÄÊý¾Ý¿âĬÈÏÁÙʱ±í¿Õ¼ä£º

alter database default temporary tablespace temp2;

Ö»ÐÞ¸ÄijÓû§µÄĬÈÏÁÙʱ±í¿Õ¼ä£º

alter user u1 temporary tablespace temp;

5¡¢´´½¨bigfile±í¿Õ¼ä

create bigfile tablespace bigts datafile '/u01/app/oracle/oradata/orcl/datafile/bigts.dbf' size 50G;

6¡¢ÐÞ¸Ädatafile´óС

sql> alter database datafile ''u01/app/oracle/oradata/orcl/datafile/ts1.dbf' resize 500m;

7¡¢ÖØÃüÃûdatafile

sql> alter tablespace datafile '''u01/app/oracle/oradata/orcl/datafile/ts1.dbf' to '''u01/app/oracle/oradata/orcl/datafile/ts1_new.dbf' ; »ò

sql> alter database file '''u01/app/oracle/oradata/orcl/datafile/ts1.dbf' to '''u01/app/oracle/oradata/orcl/datafile/ts1_new.dbf' ;