三句话创建oracle数据库

1.创建数据库表空间

create tablespace [表空间名字] datafile '[\存放的路径\表空间文件名字]' size 50m

示例:

create tablespace mydata datafile 'D:\database\mydata' size 50m

2.创建用户

create user [用户米] identified by  [密码] default tablespace [表空间名字] quota 10m on users;

示例

create user zhangsan identified by wodemima default tablespace mydata quota 10m on users;

3.给用户分配权限

grant all privileges to [用户名];

示例

grant all privileges to zhangsan;