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

Question #63224
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.
1
Expert's answer
2017-04-14T09:19:05-0400
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');

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS