Exforsys.com
 
Home Tutorials Oracle 10g
 

Oracle 10g Free Training - Managing Tablespaces

 

Oracle 10g Free Training - Managing Tablespaces - Page 2

Page 2 of 3


Creating an ‘Undo’ tablespace


a) Using SQL Plus:

1. Type the following command on the SQL prompt (figure 5):


CREATE SMALLFILE UNDO TABLESPACE "TESTTBLSPCE" DATAFILE 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\testfl' SIZE 100M;



Figure -5 Creating Undo Tablespace using SQL Plus


b) Using iSQL Plus:

1. On the ‘Workspace’ tab (figure 6), enter the following command:


CREATE SMALLFILE UNDO TABLESPACE "TESTTBLSP" DATAFILE 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\testfl' SIZE 100M



Figure -6 Creating Undo Tablespace using iSQL Plus


c) Using Enterprise Manager :

Undo tablespaces are special tablespaces used solely for storing undo information. You cannot create any other segment types in undo tablespaces. For more details on offline tablespaces, refer to the section ‘Creating Tablespaces using Enterprise Manager > Type’

An undo tablespace can be created by following the steps given in the section ‘Creating Tablespaces using Enterprise Manager’ and selecting the ‘Undo’ option under the ‘Type’ region (figure 12).


Renaming a Tablespace


a) Using SQL Plus:

1. Type the following command on the SQL prompt (figure 7):
ALTER TABLESPACE "TESTTBLSPCE" RENAME TO "TESTTBLSPEC";



Figure -7 Renaming Tablespace using SQL Plus


b) Using iSQL Plus:

1. On the ‘Workspace’ tab (figure 8), enter the following command:
ALTER TABLESPACE "TESTTBLSPC" RENAME TO "TESTTBLSPEC"



Figure -8 Renaming Tablespace using iSQL Plus


c) Using Enterprise Manager :

To rename an existing tablespace,


1. Navigate to ‘Administration > Tablespaces’ in Enterprise Manager.
2. Enter the name of the tablespace that you want to rename and click ‘Go’ (figure 15).
3. In the ‘Results’ region, select the tablespace name and click ‘Edit’ (figure 15).
4. Enter a new name for the tablespace in the ‘Name’ field.
5. Click ‘Apply’ to modify the availability for the selected tablespace.

Note: You can rename only tablespaces from databases with a version number greater than 10g.




Next Page: Oracle 10g Free Training - Managing Tablespaces - Page 3


Read Next: Oracle 10g Free Training - Managing Roles and Privileges



 

 

Comments


emmanuel said:

  i read the training and also i learn some from it and thank to you.
October 31, 2008, 12:20 pm

Post Your Comment:

Members Please Login
Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe    

Sponsored Links

 

Subscribe via RSS


Get Daily Updates via Subscribe to Exforsys Free Training via email


Get Latest Free Training Updates delivered directly to your Inbox...

Enter your email address:


 

Subscribe to Exforsys Free Training via RSS
 

 
Partners -  Privacy and Legal Policy -  Site News -  Contact   Sitemap  

Copyright © 2000 - 2009 exforsys.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape