1,897 reputation
732
bio website
location Ottawa.Ontario, Canada
age 56
visits member for 3 years, 4 months
seen 2 days ago

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


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
Oct
2
answered What are the real life cases for using Oracle advanced queuing?
Sep
27
comment How to install Oracle 10g Express and 11g Enterprise on same machine
I could create a folder on the 8i machine and then map that as a directory for the 11g database and then write csv files to it but this is not an optimal solution. You would need extra tables to log what was entered. Unfortunately I have views of tables on the 8i database that I did not mention that are used for other transactions on the 11g.
Sep
25
comment how do I configure a new Oracle 11g instance to match the configuration of the old Oracle 10g server
before you think about changing parameters what are the problems you are trying to address? A default install of Oracle does a pretty good job for many uses.
Sep
21
comment How to install Oracle 10g Express and 11g Enterprise on same machine
It's easier if they run on the same machine. It could be done with a regular 10g and 11i so it seems possible with express.
Sep
18
revised How to install Oracle 10g Express and 11g Enterprise on same machine
added 222 characters in body
Sep
17
revised Can this business logic be enforced by a conditional database constraint?
deleted 8 characters in body
Sep
17
revised Can this business logic be enforced by a conditional database constraint?
final answer
Sep
17
asked How to install Oracle 10g Express and 11g Enterprise on same machine