|
Step 2: Create the Sample Tablespace
- Create the SAMPLE Tablespace.
Use Oracle's GUI or SQLPlus Worksheet.
Using Oracle's SQLPlus Worksheet, type:
- CREATE TABLESPACE "SAMPLE" LOGGING DATAFILE '<Some_Dir>/SAMPLE.dbf' SIZE 5M EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
- 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.
 
- 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.
|