-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|