Creating Tablespaces

The following instructions assist you in creating table spaces:

  1. Connect to Oracle as the SYS user.
  2. Create table spaces for the Lawson tables and indexes.

    For example, to create two different 1 MB table spaces named dataspace and indexspace, type the following in sqlplus:

    CREATE TABLESPACE dataspace DATAFILE ‘\oradata\datts.dbf' size 1 M;

    CREATE TABLESPACE indexspace DATAFILE ‘\oradata\idxts.dbf' size 1 M;

  3. Assign the newly created table spaces to the Lawson table owner. For example, if lawson is the Lawson table owner, type the following in sqlplus:

    ALTER USER lawson DEFAULT TABLESPACE dataspace

    TEMPORARY TABLESPACE temp

    QUOTA UNLIMITED ON dataspace

    QUOTA UNLINITED ON indexspace;