Learn Oracle


I have created this learn oracle "The step 10 process" Oracle Tutorial to help Database aspirants to accomplish their dream of working as Oracle Database administrator. I have tried to keep it simple and User friendly. Use NEXT and PREVIOUS Button to navaigate away and to a chapter. Since i myself had been a Database adminstrator trainer and has got real life experience of working as a Oracle DBA, I would welcome any sort of queries and doubts or modifications to webmaster@oracleonline.info.

Step 6 - Modifying a Tablespace

Learn Oracle - Modifying a Tablespace

With Enterprise Manager, Oracle DBA can modify a tablespace, such as extend it, set it to automatically extend, change its space thresholds, or change its status to offline. tablespace might need extending when Oracle DBA get a critical and warning alert. Oracle DBA might need to offline a tablespace to perform recovery operations on it.

This section shows you how to set a tablespace to automatically extend when it reaches its limit. To enable autoextend tablespace, do the following:

1. From the Administration page, click Tablespaces under Storage. This takes Oracle DBA to the Tablespaces page.

2. Select a tablespace to autoextend, such as USERS, and click Edit. The Edit Tablespace:USERS General property page appears.

3. Select the datafile associated with the tablespace, and click Edit. The Edit Datafile page appears.

4. Check Automatically extend datafile when full (AUTOEXTEND). Set a suitable increment, such as 1 M. Oracle DBA can optionally set a maximum file size or set file size to unlimited depending on your resources.

You can add datafiles and associate them with a tablespace with SQL statements. You can either specify the file specifications for the datafiles being created, or Oracle DBA can use the Oracle Managed Files feature to create files that are created and managed by the database server.

You can also use SQL statements to manually resize a datafile. This lets you add space to your database without adding datafiles, if you are concerned about reaching the maximum number of datafiles allowed in your database. Manually reducing the sizes of datafiles lets Oracle DBA reclaim unused space in the database. This is useful for correcting errors in estimates of space requirements.

5. Click Continue. This brings you back to the Edit Tablespace page. Click Apply. A confirmation message should appear.

Similarly, you can change tablespace thresholds by selecting a tablespace on the Tablespaces page and navigating to the Threshold property page. Here you can alter your space thresholds that generate the warning and critical alerts.

To offline a tablespace, on the Edit Tablespace page, under Status, select Offline and click Apply.
Oracle Tutorial - BLOGS

STEP 6 - Next Topics
This Step discusses management of the database's storage structure. Click on Oracle tuorial links below:
The Control FileControl file
Redo Log FilesRedo log file
Archive Log FilesArchive log file
Initialization Parameter FileParameter file
Password FilePassword file
Backup FilesBackup file
Viewing Tablespaces in your DatabaseTablespace
Creating a tablespacecreating tablespace
Modifying a TablespaceModifying tablespace
Dropping a Tablespace
Managing Undo for Your Database
Oracle Database - PODCASTS
More Tutorials on Oracle dba ...

Liked it ? Want to share it ? Social Bookmarking
Add to: Mr. Wong Add to: BoniTrust Add to: Newsider Add to: Digg Add to: Del.icio.us Add to: Reddit Add to: Jumptags Add to: StumbleUpon Add to: Slashdot Add to: Netscape Add to: Furl Add to: Yahoo Add to: Spurl Add to: Google Add to: Blinklist Add to: Technorati Add to: Newsvine Information

Source : Oracle Documentation | Oracle DBA

Want to share or request Oracle Tutorial articles to become a Oracle DBA. Direct your requests to webmaster@oracleonline.info