
Anonymous
Not applicable
2013-05-31
07:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
[resolved] Manage Partition/Truncate Partition
Hi,
I need to insert dat in oracle partitioned table (year-month), suppose we have created all the partitions necessary!
Before insert I need to truncate partition.
The only way I know is run a pre-job with tOracle_Row using variables where I have:
alter table tab_name truncate partition context.yearmonth
There's another simple and better way?
Because my solution suppose to have partition name saved into a variable, but if i have into data flow two months,
I must run pre_job and insert_job two times separatly. I want run one/two jobs only one time.
tOracleOutput have UPDATE/INSERT option but my performance decade so much, and I have around 30 millions of record each months.
Thanks in advance,
Gino.
I need to insert dat in oracle partitioned table (year-month), suppose we have created all the partitions necessary!
Before insert I need to truncate partition.
The only way I know is run a pre-job with tOracle_Row using variables where I have:
alter table tab_name truncate partition context.yearmonth
There's another simple and better way?
Because my solution suppose to have partition name saved into a variable, but if i have into data flow two months,
I must run pre_job and insert_job two times separatly. I want run one/two jobs only one time.
tOracleOutput have UPDATE/INSERT option but my performance decade so much, and I have around 30 millions of record each months.
Thanks in advance,
Gino.
253 Views
1 Solution
Accepted Solutions

Anonymous
Not applicable
2013-06-01
09:52 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There is currently no other way to execute database special SQL like yours.
As far as I know, you should not insert into a partition. You can simple insert into the main table and Oracle decided by the given field content in which partition is must be added.
It is always a matter of how fast is your storage. I would recommend to discuss the usage of table spaces with your database administrator. It could be a good thing to have for the most recent partitions dedicated table spaces.
For more performance you should take a look to the Oracle bulk input components.
As far as I know, you should not insert into a partition. You can simple insert into the main table and Oracle decided by the given field content in which partition is must be added.
It is always a matter of how fast is your storage. I would recommend to discuss the usage of table spaces with your database administrator. It could be a good thing to have for the most recent partitions dedicated table spaces.
For more performance you should take a look to the Oracle bulk input components.
253 Views
2 Replies

Anonymous
Not applicable
2013-06-01
09:52 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There is currently no other way to execute database special SQL like yours.
As far as I know, you should not insert into a partition. You can simple insert into the main table and Oracle decided by the given field content in which partition is must be added.
It is always a matter of how fast is your storage. I would recommend to discuss the usage of table spaces with your database administrator. It could be a good thing to have for the most recent partitions dedicated table spaces.
For more performance you should take a look to the Oracle bulk input components.
As far as I know, you should not insert into a partition. You can simple insert into the main table and Oracle decided by the given field content in which partition is must be added.
It is always a matter of how fast is your storage. I would recommend to discuss the usage of table spaces with your database administrator. It could be a good thing to have for the most recent partitions dedicated table spaces.
For more performance you should take a look to the Oracle bulk input components.
254 Views

Anonymous
Not applicable
2013-06-06
05:21 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi jlolling,
thanks for reply, sorry for the late but i work hard in these days.
thanks for reply, sorry for the late but i work hard in these days.
253 Views
