1,765 reputation
627
bio website
location Ottawa.Ontario, Canada
age 55
visits member for 2 years, 9 months
seen Apr 1 at 18:18

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


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.
Oct
25
answered How to trigger an action without using triggers
Oct
23
answered Oracle dump import
Oct
15
comment Why an object became invalid in oracle databse.
changing the parameters in procedures and functions in packages or just recompiling stand alone procedures will do it to.
Oct
14
answered Oracle 10 to 11: charset issue
Oct
7
comment How do you document your databases?
requires .NET Framework 4.0 and only works with SQL Server and SQL Express
Oct
3
revised What are the real life cases for using Oracle advanced queuing?
deleted 1 characters in body
Oct
3
revised What are the real life cases for using Oracle advanced queuing?
added 7650 characters in body
Oct
2
comment What are the things need to be considered while creating tablespace?
why not use the default tablespace until you can show there is a problem? When you create a database the Oracle default settings are quite reasonable and it makes it much easier to administer a database created this way. Said another way "If it's not broken, don't fix it."
Oct
2
comment Trying to copy a schema using impdp
Quite right, the data pump should work, but doesn't for the OP. They noted "I'm also open to other ways to clone a schema." and this answer will do the job.
Oct
2
revised Trying to copy a schema using impdp
added 16 characters in body
Oct
2
answered Trying to copy a schema using impdp