Converting Company Schema

SQL> -- Create T24 User
SQL> create user t24 identified by t24
  2  default tablespace T24DATA
  3  quota unlimited on T24DATA
  4  quota unlimited on T24INDEX;
User created.
SQL> grant connect            to t24;
SQL> grant resource           to t24;
SQL> grant query rewrite      to t24;
SQL> grant create synonym     to t24;
SQL> grant drop any procedure to t24;
SQL> grant create any table to t24;
SQL> grant select any table to t24;
SQL> grant update any table to t24;
SQL> grant insert any table to t24;
SQL> grant delete any table to t24;
SQL> grant drop any table to t24;
SQL> grant create any index to t24;
SQL> grant alter any index to t24;
SQL> grant drop any index to t24;
SQL> grant create any view to t24;
SQL> grant drop any view to t24;
SQL> grant select_catalog_role to t24;
SQL> revoke unlimited tablespace from t24; 

SQL> -- Create FBNK User
SQL> create user fbnk identified by fbnk
  2  default tablespace FBNKDATA
  3  quota unlimited on FBNKDATA
  4  quota unlimited on FBNKINDEX;
SQL> grant connect            to fbnk;
SQL> grant resource           to fbnk;
SQL> grant query rewrite      to fbnk;
SQL> grant create synonym     to fbnk;
SQL> grant drop any procedure to fbnk;
SQL> grant create any table to fbnk;
SQL> grant select any table to fbnk;
SQL> grant update any table to fbnk;
SQL> grant insert any table to fbnk;
SQL> grant delete any table to fbnk;
SQL> grant drop any table to fbnk;
SQL> grant create any index to fbnk;
SQL> grant alter any index to fbnk;
SQL> grant drop any index to fbnk;
SQL> grant create any view to fbnk;
SQL> grant drop any view to fbnk;
SQL> grant select_catalog_role to fbnk;
SQL> revoke unlimited tablespace from fbnk; 
 

SQL> CREATE TABLESPACE T24DATA LOGGING DATAFILE
  2  '/home/oracle/T24/R6/T24DATA1.dbf' SIZE 1000M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
  3  EXTENT MANAGEMENT LOCAL
  4  SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> CREATE TABLESPACE T24INDEX LOGGING DATAFILE
  2  '/home/oracle/T24/R6/T24INDEX1.dbf' SIZE 300M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
  3  EXTENT MANAGEMENT LOCAL
  4  SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.

SQL> CREATE TABLESPACE FBNKDATA LOGGING DATAFILE
  2  '/home/oracle/T24/R6/FBNKDATA1.dbf' SIZE 1400M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
  3  EXTENT MANAGEMENT LOCAL
  4  SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> CREATE TABLESPACE FBNKINDEX LOGGING DATAFILE
  2  '/home/oracle/T24/R6/FBNKINDEX1.dbf' SIZE 800M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
  3  EXTENT MANAGEMENT LOCAL
  4  SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.