Oracle的学习

1、系统的安装

2、使用工具。

3、操作命令

查询数据库版本

select * from v$version;

 4、创建表空间，创建用户，进行授权

create tablespace hospital_data_ts datafile 'D:\app\Administrator\oradata\orcl\yyjh_jl.dbf' size 20M autoextend on;

create user yyjh_jl identified by hik12345 default tablespace hospital_data_ts;
grant create session,create table,create view,create sequence,unlimited tablespace to yyjh_jl;
grant connect to yyjh_jl;
grant resource to yyjh_jl;
grant dba to yyjh_jl;