oracle虚拟表的创建,Oracle建表

1.

//创建临时表空间

create temporary tablespace datawsyj_temp

tempfile 'C:\app\system_orcl\oradata\orcl\datawsyj_temp.dbf'

size 256m

autoextend on

next 500m maxsize 20000m

extent management local;

//创建数据表空间

create tablespace datawsyj

logging

datafile 'C:\app\system_orcl\oradata\orcl\datawsyj.dbf'

size 1024m

autoextend on

next 500m

extent management local;

//创建用户并指定表空间

create user xjwsyj identified by xjwsyj

default tablespace datawsyj

temporary tablespace datawsyj_temp;

//给用户授予权限

grant connect,resource to xjwsyj;

grant connect,dba to xjwsyj;

2.建立第一个表

create table student(

sno  varchar2(3) not null,

sname varchar2(9) not null,

ssex  varchar2(3) not null,

sbirthday date,

sclass varchar2(5