111 reputation
2
bio website
location New Mexico
age
visits member for 2 years, 6 months
seen Mar 26 at 19:16

Jun
5
comment Are there tips for writing Oracle DDL Triggers for auditing? Or should I just use AUDIT?
Generally this is not really doable because ddl does not always generate events. - but here is along discussion on Ask Tom about ddl triggers. Please read on to the bottom to get modern db information: asktom.oracle.com/pls/asktom/…
May
24
comment Is shrink a safe online operation?
Nice answer +1 @David Aldridge
Jul
25
awarded  Teacher
Apr
25
answered Changing TimeZone of an Oracle Database
Apr
25
comment Changing TimeZone of an Oracle Database
What do you mean - go to daylight time, or move from something like GMT to something remote like US Mountain. Dates in Oracle are stored as seconds since Jan 1 4712 BCE, and are subsequently translated into whatever TZ you want. Usually oracle uses the servers' TZ.
Dec
28
awarded  Supporter