1,842 reputation
730
bio website
location Ottawa.Ontario, Canada
age 55
visits member for 3 years, 2 months
seen 45 mins 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
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
Sep
16
comment Can this business logic be enforced by a conditional database constraint?
Fabulous, I ran into this with another MV but only saw adding a constraint as a problem not a solution
Sep
16
accepted Can this business logic be enforced by a conditional database constraint?
Sep
14
comment Can this business logic be enforced by a conditional database constraint?
I will have to document this internal rule that other databases connecting to this one must use a database link with a custom user who only has rights to execute packages, not to insert directly. Thanks
Sep
14
comment Can this business logic be enforced by a conditional database constraint?
Excellent point, now I see why the application does not allow deletes on entries in CASE_STAGE or CASE_RECOMMENDATION after the stage is closed.
Sep
14
revised Can this business logic be enforced by a conditional database constraint?
clarification
Sep
14
comment Can this business logic be enforced by a conditional database constraint?
For all values of CASE_STAGE.STAGE_ID the value for PREVIOUS_STAGE_ID must be found in CASE_STAGE.ID
Sep
13
comment Can this business logic be enforced by a conditional database constraint?
I'm a great believer in packages and already have one that does CRUD operations and logging on these tables. However I cannot enforce the use of the package if another database attempts inserts through a link. I have to rely on the due diligence of the programmer. A constraint is cleaner, easier to discover and document but your answer would work if a package was used.