Scribd
Upload
17 views1 page

UNDO스페이스증가스크립트

The document discusses creating and managing temporary and undo tablespaces in an Oracle database. It shows SQL commands for creating temporary tablespaces with tempfiles of different sizes, setting the default temporary tablespace, and dropping tablespaces. It also shows commands for creating undo tablespaces of different sizes and setting the undo tablespace.

Uploaded by

Yangsun Jung
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
17 views1 page

UNDO스페이스증가스크립트

The document discusses creating and managing temporary and undo tablespaces in an Oracle database. It shows SQL commands for creating temporary tablespaces with tempfiles of different sizes, setting the default temporary tablespace, and dropping tablespaces. It also shows commands for creating undo tablespaces of different sizes and setting the undo tablespace.

Uploaded by

Yangsun Jung
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

############ ���� ��� ############

select tablespace_name, bytes/1024/1024 "Mbytes" from dba_temp_files;

CREATE TEMPORARY TABLESPACE temp2


TEMPFILE '/home/oracle/oradata/orcl/temp02.dbf' size 1024M REUSE
AUTOEXTEND ON NEXT 1M MAXSIZE unlimited EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2;

DROP TABLESPACE TEMP INCLUDING CONTENTS AND DATAFILES;

CREATE TEMPORARY TABLESPACE temp


TEMPFILE '/home/oracle/oradata/orcl/temp1_1.dbf' size 512M REUSE
AUTOEXTEND ON NEXT 1M MAXSIZE unlimited EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP;

DROP TABLESPACE TEMP2 INCLUDING CONTENTS AND DATAFILES;

############# UNDO size ��� ##############

create undo tablespace undotbs2 datafile


'/home/oracle/oradata/orcl/undotbs02.dbf' size 10m;

alter system set undo_tablespace=undotbs2;

drop tablespace undotbs1 including contents and datafiles;

create undo tablespace undotbs1 datafile


'/home/oracle/oradata/orcl/undotbs01.dbf' size

500m;

alter system set undo_tablespace=undotbs1;

drop tablespace undotbs2 including contents and datafiles;

[��ó] ���Ŭ UNDO��������� / TEMP ������ ���|�‫ ���ۼ‬x1478

You might also like