Misc Oracle Commands

# To create users:
SQL> create user dswkim identified by password ;
user created
SQL> grant connect, resource, create view to dswkim ;
Grant successful
SQL> quit

# To create tablespace manually:
$ sqlplus system/manager@dbserver
SQL> '/u01/oracle/oradata/sqlora/db_data01.dbf' size 300M;
SQL> '/u01/oracle/oradata/sqlora/db_temp01.dbf' size 100M;
SQL> create user dswkim identified by password default tablespace
SQL> db_data temporary tablespace db_temp
SQL> grant connect, resource to dswkim ;