Oracle Tablespace Configuration

Step 1 Step 2 Step 3 Step 4 Step 5


Step 3: Create an Oracle User for SAMPLE Tablespace

  • Create an Oracle user named wsdemo, with a password of wsdemo1, for the SAMPLE tablespace.

      Using the Oracle command line interface, type:
    1. CREATE USER "WSDEMO" PROFILE "DEFAULT" IDENTIFIED BY "wsdemo1" DEFAULT TABLESPACE "SAMPLE" QUOTA UNLIMITED ON SAMPLE ACCOUNT UNLOCK;
    2. GRANT CONNECT TO WSDEMO;

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


Take Note!
  • Be sure to user all lower case letters to create the password, wsdemo1.