1,943 reputation
732
bio website
location Ottawa.Ontario, Canada
age 56
visits member for 3 years, 6 months
seen 4 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


1d
comment How to normalize a table that contains a CK not included in the PK?
double post from programmers programmers.stackexchange.com/questions/271422/…
1d
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?
1d
comment optimizing init.ora oracle database server
It's unclear what you are asking. What is the problem?
Jan
26
comment Can't check out TFS scripts in Oracle
what version of Toad, what version of Team Foundation Server? Did you go through the steps in Toad and confirm that all settings are showing green checkmarks?
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
Dec
16
wiki created berkeley-db excerpt
Dec
16
suggested approved edit on berkeley-db tag wiki