Oracle创建表空间与创建用户

    -- 创建表空间
create tablespace xxx
-- xxx为表空间
datafile 'D:\data\xxx.dbf'
size 100M
autoextend on;

-- 创建用户
create user lsq
identified by lsq
default tablespace xxx;

-- 赋予权限
grant dba to lsq;

-- 创建表
create table stu(
             sno int(20) primary key,
             name varchar(20),
             gender varchar(2) default '男',
             birthday date
);
insert into stu values('01','张三','男',to_date('1999-01-20','yyyy-MM-dd'));
insert into stu(sno,name,gender,birthday) values('02','李四','女',to_date('1999-02-20','yyyy-MM-dd'));
select * from stu;