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;

原文链接：https://www.f2er.com/oracle/213549.html