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