meta user
network profile
| bio | website | |
|---|---|---|
| location | Ottawa.Ontario, Canada | |
| age | 54 | |
| visits | member for | 1 year, 10 months |
| seen | 12 hours ago | |
| stats | profile views | 36 |
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 |
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 |
|
Oct 25 |
comment |
Data archival strategy that handles schema changes? "a substantial schema change every quarter" Yikes! Could indicate that the existing schema is badly designed. I grant it's not relevant to your question though. |
