Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

inserting data into partition table

Harikanth KonetiFeb 6 2018 — edited Feb 6 2018

HI Folks,

i have 1 TB size table i.e. tbl_vpn which is not partitioned. i'm trying to create the table tbl_sub like below, it's taking more than 24 hours to create it

CREATE TABLE tbl_sub

NOLOGGING AS

SELECT /*+ PARALLEL(a,6,6) PARALLEL(b,6,6)*/

       A.INTER, A.ROW_ADDED_DT,

       TO_CLOB(A.NOTES) NOTES

  FROM tbl_vpn a,

       tbl_act b

WHERE a.id = b.id;

now my query is, if i create the tbl_sub table as partitioned then i try to inserting data into table with the same select statement will it improve the performance of data insertion?

Many thanks in advance,

Harikanth.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 6 2018
Added on Feb 6 2018
7 comments
311 views