create table as select
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: create table as select

  1. #1
    Join Date
    Oct 2000
    Posts
    90
    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?

  2. #2
    Join Date
    Mar 2001
    Posts
    63
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width