Solved

Oracle, Timestamp, partition

Posted on 2012-04-13
3
475 Views
Last Modified: 2012-04-13
if i have a table where the timestamp column is populated with a trigger on insert, can i partition on that column?
0
Comment
Question by:Rao_S
3 Comments
 
LVL 73

Assisted Solution

by:sdstuber
sdstuber earned 250 total points
ID: 37842222
yes,  the existence or absence of a trigger has no impact on whether it can be partitioned


note, an update trigger might require you to enable row movement if the trigger would cause data to need moved from one partition to another.
0
 
LVL 8

Accepted Solution

by:
Christoffer Swanström earned 250 total points
ID: 37842223
Yes you can. If your trigger is defined to be fired before insert, you don't need to do anything else. If the trigger fires after insert, you will need to enable row movement.
0
 

Author Closing Comment

by:Rao_S
ID: 37842526
thank you very much!
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to recover a database from a user managed backup

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question