TBS_P2: Changing table space characteristics

Sql>conn system/oracle

-- Create a table space for manual segment management

Sql>altersystem Set db_create_file_dest = '/oradata ';

Sql>createtablespace Tbs_manualsegs segment Space management manual;

-- determine the existence of a new table space

Sql>selecttablespace_name, segment_space_management from Dba_tablespaces

Wheretablespace_name= ' Tbs_manualsegs ';

-- Creating tables and indexes in a table space

Sql>createtable T_mantab (c1 number) tablespace Tbs_manualsegs;

Sql>createindex I_mantab on T_mantab (C1) tablespace manualsegs;

-- new auto Segment table Space

Sql>createtablespace Tbs_autosegs;

-- move an object into a new table space

Sql>altertable t_mantab move tablespace tbs_autosegs;

Sql>alterindex i_mantab rebuild Online tablesapcetbs_autosegs;

-- Delete the original table space

Sql>droptablespace Tbs_manualsegs including contents and datafiles;

-- Rename the new table space to its original name. (Need for application software)

Sql>altertablesapce tbs_autosegs Rename to Tbs_manualsegs;

-- by deleting the tablespace for cleanup, first use the following command

Sql>droptablespace Tbs_manualsegs;

 -- because the tablespace is not empty, an error is raised and should be corrected.

Sql>drop tablespace tbs_manualsegs including contents and datafiles;

This article is from the "struggle more than" blog, please be sure to keep this source http://peenboo.blog.51cto.com/2865551/1790370

Tbs_p2: Changing tablespace properties