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?
I wouldn't think that the new table would be partitioned. All you are copying over is the data, nothing else like indexes, partitions, analyzed statistics, etc. will come over with it.
The only special consideration I could possibly imagine would be that when the table is created, it will use the database default extent parameters (Initial, next, pctincrease, etc.). Other than that, it's pretty cut and dry.