oracle_10g建表 建空间

Oracle 10g 建空间,建库,建表     1.--连接 conn hu/aaa; --创建表空间 Create tablespace computer2005 nologging datafile 'd:/JAVA_system/computer.dbf' size 50m blocksize 8192 extent management local uniform size 256k segment space management auto; --创建学生基本信息表 create table student(学号varchar2(20 byte) not null,                          姓名varchar2(8 byte),                          性别varchar2(4 byte),                          民族varchar2(8 byte), constraintpk_stud primary key(学号) using index tablespace computer2005 pctfree 10 initrans 2 maxtrans 255); --创建课程信息表 create table course(课程编号varchar2(5 byte) not null,                      课程类型varchar2(6 byte),                      课程名varchar2(20 byte),                      周学时integer,                      任课教师varchar2(10 byte),                      开设学期integer,                      考核方式varchar2(4 byte), constraintpk_cour primary key(课程编号) using index tablespace computer2005 pctfree 10 initrans 2 maxtrans 255); --创建学生成绩表 create table score(学号varchar2(20 byte) not null,                      课程编号varchar2(5 byte) not null,                      成绩number, constraintpk_sc primary key(学号,课程编号) using index tablespace computer2005 pctfree 10 initrans 2 maxtrans 255); --添加外键 alter table score add constraint fk_stud_score foreign key(学号) references student(学号); alter table score add constraint fk_cour_score foreign key(课程编号) references course(课程编号); --移动表到工作表空间 alter table student move tablespace computer2005; alter table course move tablespace computer2005; alter table score move tablespace computer2005; --使用SQL loader导入数据 host sqlldr hu/aaa control=d:/oracle/insert4.ctllog=d:/oracle/4.log host sqlldr hu/aaa control=d:/oracle/insert5.ctllog=d:/oracle/5.log host sqlldr hu/aaa control=d:/oracle/insert6.ctllog=d:/oracle/6.log 2.--创建用户 create user hu identified by aaa; --赋予权限 grant dba,connect to hu with admin option; --连接 conn hu/aaa; --创建表空间 create tablespace student_app nologging datafile 'd:/oracle/product/10.2.0/oradata/test/student.dbf' size 50m blocksize 8192 extent management local uniform size 256k segment space management auto; --创建学生基本信息表 create table学生基本信息(学号varchar2(20 byte) not null,                          姓名varchar2(8 byte),                          性别varchar2(4 byte),                          民族varchar2(8 byte), constraintpk_baseinfo primary key(学号) using index tablespace student_app pctfree 10 initrans 2 maxtrans 255); --创建课程信息表 create table课程信息(课程编号varchar2(5 byte) not null,                      课程类型varchar2(6 byte),                      课程名varchar2(20 byte),                      周学时integer,                      任课教师varchar2(10 byte),                      开设学期integer,                      考核方式varchar2(4 byte), constraintpk_course primary key(课程编号) using index tablespace student_app pctfree 10 initrans 2 maxtrans 255); --创建学生成绩表 create table学生成绩(学号varchar2(20 byte) not null,                      课程编号varchar2(5 byte) not null,                      成绩number, constraintpk_grade primary key(学号,课程编号) using index tablespace student_app pctfree 10 initrans 2 maxtrans 255); --添加外键 alter table学生成绩add constraint fk_info_grade foreign key(学号) references学生基本信息(学号); alter table学生成绩add constraint fk_course_grade foreign key(课程编号) references课程信息(课程编号); --移动表到工作表空间 alter table学生基本信息move tablespace student_app; alter table课程信息move tablespace student_app; alter table学生成绩move tablespace student_app; --使用SQL lpader导入数据 host sqlldr hu/aaa control=d:/oracle/insert1.ctllog=d:/oracle/1.log host sqlldr hu/aaa control=d:/oracle/insert2.ctllog=d:/oracle/2.log host sqlldr hu/aaa control=d:/oracle/insert3.ctllog=d:/oracle/3.log