oracle建表空间和表

--oracle
--创建表空间
create tablespace VOTE datafile 'F:\oracle\product\10.2.0\oradata\wind\VOTE_0.1ORA' size 800m;
--创建临时表空间
create temporary tablespace vote_temp tempfile 'F:\oracle\product\10.2.0\oradata\wind\vote_temp_0.1ORA' size 128m;

--创建用户
create user liuhl identified by liuhl default tablespace VOTE temporary tablespace vote_temp;

--给用户授予权限
grant connect, resource to liuhl;


-- 创建自动递增的ID 号
create sequence user_sequence;


--增加语句
select user_sequence.nextval as id from dual;

create table tableinfo
(
id number(3) primary key not null,
question varcher2(200) not null,
answer1 varchar2(200) not null,
answer2 varchar2(200) not null,
answer3 varchar2(200),
answer4 varchar2(200)
);

create table tableinfo2
(
id number(3) primary key not null,
answer varchar2(200),
aid number(3),
count number(3),
foreign key(aid) references tableinfo(id)
);