第四章Oracle数据库管理(管理一)讲述.ppt

* Dropping Tablespaces You can remove a tablespace from the database when the tablespace and its contents are no longer required with the following DROP TABLESPACE SQL command: DROP TABLESPACE tablespace [INCLUDING CONTENTS [AND DATAFILES] [CASCADE CONSTRAINTS]] where: tablespace: Specifies the name of the tablespace to be dropped INCLUDING CONTENTS: Drops all the segments in the tablespace AND DATAFILES: Deletes the associated operating system files CASCADE CONSTRAINTS: Drops referential integrity constraints from tables outside the tablespace that refer to primary and unique keys in the tables in the dropped tablespace * Dropping Tablespaces (continued) Using Oracle Enterprise Manager to Drop a Tablespace From the OEM Console: Navigate to Storage Tablespaces. Select the tablespace. Select Remove from the right-mouse menu. Select the “Delete associated datafiles from the OS” check box if you want to delete the data files. Note: This option only appears with Oracle9i Database Release 2. Click Yes to confirm drop. * Managing Tablespaces with OMF Creating OMF Tablespaces Creating tablespaces with OMF does not require a DATAFILE clause. Tablespaces omitting the DATAFILE clause take the defaults of a 100 MB data file set to AUTOEXTEND with an unlimited MAXSIZE. Optionally a file size can be specified. CREATE TABLESPACE tablespace [ DATAFILE [ filename ] [ SIZE integer [K|M] ] ]; Adding Data Files to OMF Tablespaces A data file can be added to an existing tablespace. The ADD DATAFILE command no longer requires file specification. Dynamically Changing Default File Locations DB_CREATE_ONLINE_LOG_DEST_n should be set to prevent log files and control files from being placed with data files. The destination can be changed dynamically using the ALTER SYSTEM SET command. Dropping OMF Tablespaces Data files from OMF created tablespaces are deleted at th