Shulou(Shulou.com)06/01 Report--

SQL > conn system/oracle

-- create tablespaces managed by manual segments

SQL > altersystem set db_create_file_dest ='/ oradata'

SQL > createtablespace tbs_manualsegs segment space management manual

-- determine the existence of the new tablespace

SQL > selecttablespace_name, segment_space_management from dba_tablespaces

Wheretablespace_name='TBS_MANUALSEGS'

-- create tables and indexes in the tablespace

SQL > createtable t_mantab (C1 number) tablespace tbs_manualsegs

SQL > createindex i_mantab on t_mantab (C1) tablespace manualsegs

-- New automatic segment tablespace

SQL > createtablespace tbs_autosegs

-- move objects to a new tablespace

SQL > altertable t_mantab move tablespace tbs_autosegs

SQL > alterindex i_mantab rebuild online tablesapcetbs_autosegs

-- delete the original tablespace

SQL > droptablespace tbs_manualsegs including contents and datafiles

Rename the new table space to its original name. (application software needs)

SQL > altertablesapce tbs_autosegs rename to tbs_manualsegs

To clean up by deleting the tablespace, first use the following command

SQL > droptablespace tbs_manualsegs

Because the tablespace is not empty, an error will be raised and should be corrected.

SQL > drop tablespace tbs_manualsegs including contents and datafiles

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.