1.1、查看資料庫狀態
select open_mode from v$database;
1.2、查看資料庫日志
select * from v$diag_info;
1.3、查看當前資料庫路徑
select name from v$datafile;
1.4、創建表空間
create tablespace test datafile 'C:\app\Administrator\oradata\orcl\test01.dbf' size 10m;
1.5、創建用戶
create user hi identified by man default tablespace test; grant dba to hi;
1.6、創建表
conn hi/man; create table emp01 (id number(12) primary key,name varchar(20));
1.7、資料插入
insert into emp01 values (1,'Zhangsan'); insert into emp01 values (2,'Lisi'); commit;
1.8、查詢表
select * from emp01;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/106730.html
標籤：其他