2,037 reputation
833
bio website
location Ottawa.Ontario, Canada
age 56
visits member for 3 years, 8 months
seen 9 hours ago

Oracle DBA and programmer with 10 years experience maintaining mission-critical applications. Lots of PL/SQL, C# and the usual glue, vbscript, DOS


Feb
27
comment split string into multiple rows with multiple columns
what have you tried?
Feb
26
comment Why am I able to query a remote database without a dblink?
Please show us what script the users use to do this
Feb
26
answered BLObs – Should I Store In Database Or in Directory Structure?
Jan
29
comment IMPDP twice with same Oracle EXPDP dumpfile with different results?
are you using the consistent parameter in the export? "The exp utility used the CONSISTENT=Y parameter to indicate the export should be consistent to a point in time"
Jan
28
comment How to normalize a table that contains a CK not included in the PK?
I question your assumption that modelName is unique. They can change and are outside your control. Why not just stick with a primary key?
Jan
28
comment optimizing init.ora oracle database server
It's unclear what you are asking. What is the problem?
Jan
23
answered Error in trigger: table X is mutating, trigger/function may not see it
Jan
21
comment Trying to Figure out an ER Diagram for a set of instructions
you need to show what are the one to one and one to many relationships
Jan
21
revised Auditing Specifications for SQL Server 2012
corrected formatting, removed redundant words
Jan
21
suggested approved edit on Auditing Specifications for SQL Server 2012
Jan
16
comment Restoring an Oracle Backup Properly
I hope for your sake that this is development.
Jan
15
comment Large sequence cache in Oracle
don't suppose you can use SYS_GUID() for your primary key? No caching required then...
Jan
14
comment What storage engines work with Oracle?
learn something new every day with Oracle..
Jan
9
comment where is oracle session timezone set?
@JoshuaHuber Thanks, that is correct for Java and Oracle databases, no more three letter abbreviations, use 'America/New_York' docs.oracle.com/cd/E11882_01/server.112/e10729/…
Jan
7
revised SQLDeveloper.exe itself is getting access denied
added 180 characters in body
Jan
7
answered SQLDeveloper.exe itself is getting access denied
Dec
17
revised Enforce a constraint problem
deleted 16 characters in body
Dec
16
revised berkeley-db wiki description
added 723 characters in body
Dec
16
revised berkeley-db wiki excerpt
added 116 characters in body
Dec
16
wiki created berkeley-db description