DB/Oracle
잘 까먹는 것들
hani^___^
2012. 7. 3. 17:02
> 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]