Answer to Question #63224 in Databases | SQL | Oracle | MS Access for jonney

Question

by oracle sql*plus
2- a range-based partitioning table named p_student with attributes empno,empname,job,salary,department no. Make sure that the data entry of the each department goes to its own provided tablespaces such as the cs department goes to the dept10ts tablespace, the data entry of the cis department goes to the dept20ts tablespace, OTHERS goes to other_dept tablespace. specify the storage size parameter .
3- have the parallel query option, then the fastest method to create a table that has the same columns as the p_STUDENT table, but only for those student in department CS.

Answer 1

create table P_STUDENT (
EMPNO number,
EMPNAME varchar2(64),
JOB varchar2(64),
SALARY number(9, 2),
DEPARTMENT_NO varchar2(5)
)
partition by list (DEPARTMENT_NO) (
partition q_cs values ('CS') tablespace dept10ts,
partition q_cis values ('CIS') tablespace dept20ts,
partition q_others values (DEFAULT) storage (initial 2M) tablespace other_dept
);

create table P_STUDENT_CS as
(select * from P_STUDENT where DEPARTMENT_NO = 'CS');