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

发布时间：2020-12-12 16:16:10 所属栏目：百科来源：网络整理

导读：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:appAdministratororadataorclmyspace.dbf

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:appAdministratororadataorclmyspace.dbf'
size 100m
autoextend on;
create temporary tablespace mytemp
tempfile 'E:appAdministratororadataorclmytemp.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;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!