创建表空间:
create tablespace nanr
datafile 'D:\oracletablespace\nanr.DBF'
size 50M
autoextend on
next 10M
创建用户
create user drms
identified by drms
default tablespace nanr
授权
grant dba to drms ;
切换用户(使用这个用户创建表)
create table DEPF_P(
DEPT_ID varchar2(40) not null,
DEP_NAME varchar2(40),
constraint PK_DEPT_P primary key (DEPT_ID)
)
开机自启动: /etc/rc.d/rc.local 下添加
su oracle -lc "/opt/oracle/app/product/11.2.0/dbhome_1/bin/lsnrctl start"
su oracle -lc /opt/oracle/app/product/11.2.0/dbhome_1/bin/dbstart