Shulou(Shulou.com)05/31 Report--

This article mainly explains how to add, delete and change Oracle tablespaces. Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "Oracle tablespace add, delete, change operation is how" it!

-- 1. Create 3 types of tablespaces

-- New tablespace

CREATE TABLESPACE APPS_TABS DATAFILE'/ u02 autoextend on next autoextend on next 50M maxsize 20480m

-- New temporary tablespace

CREATE TEMPORARY TABLESPACE APPS_TEMP3 TEMPFILE'/ u02According to test _ SIZE _

-- New UNDO tablespace

CREATE UNDO TABLESPACE APPS_UNDOTS2 DATAFILE'/ u02According to TestUniverse dbUnix data Ligand appsaries undots2 percent 1.dbf' SIZE 50m

-2. Query tablespace

Select * from dba_tablespaces d where d.TABLESPACE_NAME in ('APPS_TABS','APPS_TEMP3','APPS_UNDOTS2')

3. Add data files for tablespaces

-- add data files for permanent tablespaces

ALTER TABLESPACE APPS_TABS

ADD DATAFILE'/ u02According to TestUniverse dbUniverse dataLigand appsaries tabsmakers 2.dbf'

SIZE 10G

AUTOEXTEND on

Next 50M maxsize 20480M

-add data files for UNDO tablespaces

ALTER TABLESPACE APPS_UNDOTS2

ADD DATAFILE'/ u02According to TestUniverse dbUnix data Ligand appsaries undots2percent 2.dbf'

SIZE 10G

AUTOEXTEND on

Next 50M maxsize 20480M

-add data files for temporary tablespaces

ALTER TABLESPACE APPS_TEMP3

ADD TEMPFILE'/ u02According to TestUniverse dbUniverse dataLigand appspromotemp3percent 2.dbf'

SIZE 10G

AUTOEXTEND on

Next 50M maxsize 16g

4. Resize the newly added data files

-- resize the permanent tablespace to 150m

Alter database datafile'/ u02According to TestUniverse dbUniverse dataLigand appsaries tabs2.dbf' resize 150m

-- resize the UNDO tablespace to 150m where resize may not succeed when something is running in the current instance

Alter database datafile'/ u02According to TestUniverse dbUnix data Ligand appsaries undots2percent 2.dbf' resize 150m

-resize the temporary tablespace to 150m

Alter database tempfile'/ u02According to test _ resize _

-- 4. View data files

Select * from dba_data_files d where d.TABLESPACE_NAME in ('APPS_TABS','APPS_UNDOTS2')

Select * from dba_temp_files d where d.TABLESPACE_NAME = 'APPS_TEMP3'

-5. Delete tablespace

Drop tablespace APPS_TABS

Drop tablespace APPS_UNDOTS2

Drop tablespace APPS_TEMP3

At this point, I believe that everyone on the "Oracle tablespace add, delete, change operation is how" have a deeper understanding, might as well to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.