Oracle Tablespace Configuration

Step 1 Step 2 Step 3 Step 4 Step 5


Step 2: Create the Sample Tablespace

  • Create the SAMPLE Tablespace.

      Use Oracle's GUI or SQLPlus Worksheet.

      Using Oracle's SQLPlus Worksheet, type:

    1. CREATE TABLESPACE "SAMPLE" LOGGING DATAFILE '<Some_Dir>/SAMPLE.dbf' SIZE 5M EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
    2. ALTER DATABASE DATAFILE '<Some_Dir>/SAMPLE.dbf' AUTOEXTEND ON;

    Note:
    • <Some_Dir> should be an existing directory -- a common place is "<Oracle_Root>/ORADATA/ORCL" -- on the Oracle server. The command creates the file "SAMPLE.dbf" in the directory specified.
    • A SIZE of 5Mb should be sufficient for the SAMPLE tablespace.

Please see Oracle documentation for more information on GUI or command line options.


Take Note!
  • Alternatively, you can create a tablespace with any name you choose. Whatever name you give it, specify the same tablespace name in Step 4-Substep 3 when you create the corresponding DataSource object.