2,037 reputation
833
bio website
location Ottawa.Ontario, Canada
age 56
visits member for 3 years, 8 months
seen 15 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


Mar
12
comment Continuous replication between Oracle Database and Microsoft Azure SQL
what oracle version, how much data are you synching every day?
Mar
7
comment Removing editioning from an Oracle user
Impressive, as they say, I should of thought of that...:)
Mar
7
revised unique-key wiki description
added 635 characters in body
Mar
5
revised unique-key wiki excerpt
added 124 characters in body
Mar
5
wiki created unique-key description
Mar
5
wiki created unique-key excerpt
Mar
5
suggested approved edit on unique-key tag wiki
Mar
5
suggested approved edit on unique-key tag wiki excerpt
Mar
4
comment Is it possible to upgrade Oracle 8i to 12c?
@Phil correct but without some idea of the number of users, size of the database files, type of application we are left to speculate
Mar
4
revised Is it possible to upgrade Oracle 8i to 12c?
added 114 characters in body
Mar
4
answered Is it possible to upgrade Oracle 8i to 12c?
Mar
4
suggested rejected edit on Trying to add a NULLable column to a table with over 90 million rows takes a very long time
Mar
4
revised Removing editioning from an Oracle user
added 390 characters in body
Mar
4
asked Removing editioning from an Oracle user
Mar
3
comment Clarification on usage of Serially Reusable Pragma for Oracle 10g
I was never able to get this to work using the Pragma or editioning. If you have a package that you cannot use here and here or here what good is it? I follow best practice and do all changes to production during a time period agreed on by the application owners
Feb
27
comment Best place to keep backup scripts
and in your documentation too with notes on how it works
Feb
27
comment Is EAV an appropriate design for a collection of coexisting metadata-rich “fact estimates” on objects?
double weird, link works in IE (!!!) but not direct from chrome
Feb
27
comment Is EAV an appropriate design for a collection of coexisting metadata-rich “fact estimates” on objects?
link is down for me
Feb
27
comment Why do I get this CMN_1021[ORA-03135: Connection lost to contact
Intermittent network issues?
Feb
27
comment split string into multiple rows with multiple columns
what have you tried?