Sunday, February 7, 2010

Oracle Administration

1. Create new schema
a. Open command prompt, change to C:\oracle\product\10.2.0\db_1\BIN>
b. set ORACLE_SID=cms
c. sqlplus / as sysdba;
d. create user identified by ;
e. grant create session, connect, resource to emp_role, mgr_role;
f. Use sqldeveloper to connect to the schema to create table/view/store...