WenJunjie Blog

sysadmin

Oracle Tips

| Comments

sqlplus sqlplus USERNAME/PASSWORD@HOSTNAME

select * from v$dbfile select * from v$tablespace create tablespace NAME datafile ‘FILENAME.dbf’ size 20M; (Create DB)

create user USERNAME identified by PASSWORD; grant connect to USERNAME; grant resource to USERNAME; conn USERNAME/PASSWOD; create table t1 (c1 int); insert into t1 values(1); commit;

http://www.cnblogs.com/chinafine/articles/1755405.html

Comments