1,897 reputation
731
bio website
location Ottawa.Ontario, Canada
age 56
visits member for 3 years, 3 months
seen yesterday

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


Nov
5
revised Best practice for a DBA to login to a database
added 631 characters in body
Nov
5
comment Pitfalls of creating a foreign key constraint on a system table?
@Phil please submit your comment as an answer and I'll do so
Nov
5
revised Periodic Oracle restarts…intentionally
added 238 characters in body
Nov
5
answered Best practice for a DBA to login to a database
Nov
3
revised Derive Attributes in Tables?
added 330 characters in body
Nov
3
accepted Pitfalls of creating a foreign key constraint on a system table?
Nov
3
answered Pitfalls of creating a foreign key constraint on a system table?
Nov
3
answered Derive Attributes in Tables?
Nov
2
revised Periodic Oracle restarts…intentionally
added 432 characters in body
Nov
1
answered Periodic Oracle restarts…intentionally
Oct
30
revised Pitfalls of creating a foreign key constraint on a system table?
added 278 characters in body
Oct
29
asked Pitfalls of creating a foreign key constraint on a system table?
Oct
29
revised How to trigger an action without using triggers
added 7848 characters in body
Oct
25
comment Oracle Enterprise Manager 11g dbconsole “Internet Explorer cannot display the webpage”
Is it possible that the required apex tables or users have removed or have locked accounts
Oct
25
comment oracle how to call procedure
Create new schema, import the data into that schema using the old export/import or the datapump which I think will work from self to self. Then, in the new schema, redefine your fields and do the ORM from there. But if you continue to work with the original schema you will have pain later. Best way is to redefine the original schema but this must be tested!
Oct
25
comment oracle how to call procedure
better yet ask another question about migrations
Oct
25
revised oracle how to call procedure
added 821 characters in body
Oct
25
revised oracle how to call procedure
added 821 characters in body
Oct
25
answered oracle how to call procedure
Oct
25
answered Storing summed values