잘 까먹는 것들

> sqlplus "/as sysdba"

> startup

> conn sys/as sysdba

# SID 확인

> select name from v$database;

> create tablespace [이름] datafile '/home/oracle/data/dbName.dbf' size 100M autoextend on next 10M maxsize unlimited

> create user [이름] identified by [암호] default tablespace [이름];

> grant resource, connect to [이름];

> alter profile default limit password_life_time unlimited;

> @createtable.sql

> @insertdata.sql

> lsnrctl [start|status|stop]