Exforsys.com
 
Home Tutorials Oracle 10g
 

Oracle 10g Free Training - Managing Tablespaces

 

Oracle 10g Free Training - Managing Tablespaces

Page 1 of 3

Oracle 10g Free Training - Managing Tablespaces : This tutorial provides detailed steps about Managing Tablespaces, Altering Tablespace , Creating an ‘Undo’ tablespace and Renaming a Tablespace using SQL Plus, Using iSQL Plus and Enterprise Manager.


Oracle 10g Free Training - Managing Tablespaces

Altering Tablespace Availability


a) Using SQL Plus:

1. Type the following command on the SQL prompt (figure 3):
ALTER TABLESPACE "TESTTBLSPC" OFFLINE NORMAL;



Figure -3 Altering Tablespace Availability using SQL Plus


b) Using iSQL Plus:

1. On the ‘Workspace’ tab (figure 4), enter the following command:
ALTER TABLESPACE "TESTTBLSPC" OFFLINE NORMAL



Figure -4 Altering Tablespace Availability using iSQL Plus


c) Using Enterprise Manager :


Oracle Enterprise Manager can be used to take an online tablespace offline so that a portion of the database is temporarily unavailable for general use. The rest of the database is open and available for users to access data. Conversely, you can bring an offline tablespace online to make the schema objects within the tablespace available to database users.

Availability of a tablespace can be changed using the following steps:

1. In the Enterprise Manager, navigate to ‘Administration > Tablespaces’.

2. Enter the name of the tablespace that you want to alter and click ‘Go’ (figure 15). For more details on offline tablespaces, refer to the section ‘Creating Tablespaces using Enterprise Manager > Status’.



Figure -15 Search Tablespace Window


3. In the ‘Results’ region, select the tablespace name and click ‘Edit’ (figure 15).

4. In the status region, select the ‘Offline’ option (figure 16).



Figure -16 Edit Tablespace Window


5. Click ‘Apply’ to modify the availability.


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


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