Inserting Data into Partitioned Tables
Posted: Fri May 08, 2009 1:23 am
Hi,
I am trying to insert data into a partitioned table which has a partition name based on one of the primary key columns of the table. e.g if the value of the key column is PN GBRTEST the partition name is PN_GBRTEST. So my insert statement should look like
insert into <table_name> partition (<partition_name_from_key>) values (<key>,'DATA1') etc
I am trying to generate the partition name dynamically while inserting using the Oracle Enterprise Stage. Any thoughts on how I will be able to achieve this? So far I've tried using the transformer but I get Insert Prepare Failed ORA-00928: missing SELECT keyword
I would be grateful for any pointers in this issue.
Thanks,
Hema
I am trying to insert data into a partitioned table which has a partition name based on one of the primary key columns of the table. e.g if the value of the key column is PN GBRTEST the partition name is PN_GBRTEST. So my insert statement should look like
insert into <table_name> partition (<partition_name_from_key>) values (<key>,'DATA1') etc
I am trying to generate the partition name dynamically while inserting using the Oracle Enterprise Stage. Any thoughts on how I will be able to achieve this? So far I've tried using the transformer but I get Insert Prepare Failed ORA-00928: missing SELECT keyword
I would be grateful for any pointers in this issue.
Thanks,
Hema