Oracle学习笔记二：数据库操作与使用

select open_mode from v$database;

select * from v$diag_info;

select name from v$datafile;

create tablespace test datafile 'C:appAdministratororadataorcltest01.dbf' size 10m;

create user hi identified by man default tablespace test;
grant dba to hi;

conn hi/man;
create table emp01 (id number(12) primary key,name varchar(20));

insert into emp01 values (1,'Zhangsan');
insert into emp01 values (2,'Lisi');
commit;

select * from emp01;