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;
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;