I have a table called NURSE that is partitioned. I want to create another table called DOCTOR as select from the table NURSE. My question is since the NURSE table is partitioned, after I have created the DOCTOR table, is it going to contain the partitions as the NURSE table?
This is the method I intend to use:
create table DOCTOR as select patient_name, doctor_name, illness from
NURSE where doctor_name = 'JOHNSON';
Are there any special things that I have to take into consideration when creating this table?
Click Here to Expand Forum to Full Width