Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...


. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |


Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.



Lesson 01 | Lesson 02 | Lesson 03 | Lesson 04 | Lesson 05 | Lesson 06 | Lesson 07 | Lesson 08 | Lesson 09 | Lesson 10 | Lesson 11 | Lesson 12 | Lesson 13 | Lesson 14 | Lesson 15 | Lesson 16 |


Lesson 05

"Men have become the tools of their tools." - Henry David Thoreau (1817-1862)


Read first then play the video:

   OEM-VIDEO -Managing Tablespaces and Datafiles


Managing Tablespaces and Datafiles using OEM



As a DBA, you are responsible for managing Oracle tablespaces and datafiles. The following is a summary of your task:


Selecting a target database

Creating a tablespace

Creating a datafile

Changing the block size of a tablespace

Using the Locally Managed option

Adding an additional datafile to a tablespace

Using the automatically extend option

Obtaining a SQL statement syntax

Removing a tablespace



Expand the Database item.

Expand the DBS4RMAN database.

Expand the Storage item.

Expand the Tablespaces item.

Highlight the "Tablespaces" item, right click and select "Create."

Enter a new tablespace name, such as DATA.

Change the datafile name, if it is needed.

Change the File directory or the datafile size if it is needed.

Leave the tablespace status and type just as it is.

On the Storage tab, use the Locally Managed option with an automatic allocation.

Notice that the block size can be changed. Click "Create."

The tablespace was created.

Expand the datafile of the DATA tablespace.

Notice that the datafile size is 10 megabytes.

Let's add one more datafile to the DATA tablespace. Highlight Datafiles and create a new datafile.

Change the datafile name.

Change the datafile size to 10 megabytes.

In the Storage tab, select "Automatically extend datafile when is full" with 1 Megabyte of extend and not to exceed more than 10 Megabytes.

Click on "Show SQL" and browse through the SQL statement. Then click "Create."

The datafile was created. Notice that you now have two datafiles within the DATA tablespace.

Highlight "Tablespaces," and notice that the data tablespace size changed to 20 megabytes.

Highlight the Data tablespace, right click and remove the DATA tablespace.

Verify the remove request.

The data tablespace was removed.