oracle创建表空间以及用户角色Demo

前端之家收集整理的这篇文章主要介绍了oracle创建表空间以及用户角色Demo前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
drop tablespace myspace including contents and datafiles;
drop tablespace mytemp including contents and datafiles;
drop role rootrole;
drop user root cascade;


create tablespace myspace
datafile 'E:\app\Administrator\oradata\orcl\myspace.dbf'
size 100m
autoextend on;
create temporary tablespace mytemp
tempfile 'E:\app\Administrator\oradata\orcl\mytemp.dbf'
size 10m
autoextend on;
create role rootrole;
grant create session to rootrole;
grant create table to rootrole;
create user root
identified by root
default tablespace myspace
temporary tablespace mytemp
quota 5M on myspace;
grant rootrole to root;

grant unlimited tablespace to root;


drop table tb_user; create table tb_user( stu_num int primary key,stu_name varchar2(20) not null,stu_sex char(4) default('男')check(stu_sex in('男','女')), stu_birthday date ); insert into tb_user(stu_num,stu_name)values('1001','test'); select * from tb_user;

猜你在找的Oracle相关文章