1,817 reputation
730
bio website
location Ottawa.Ontario, Canada
age 55
visits member for 3 years, 1 month
seen Aug 29 at 14:35

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


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.
Sep
13
comment Can this business logic be enforced by a conditional database constraint?
1646 represents the only stage that has this requirement for a case recommendation. Splitting the table would break the ORM and require an extensive rewrite of the application so it is not feasible. @Erwin- no deletes are allowed from CASE_STAGE or CASE_RECOMMENDATION
Sep
13
comment Can this business logic be enforced by a conditional database constraint?
Thank you, a great answer that I will be able to use for other "rules", just not this one.
Sep
13
comment Can this business logic be enforced by a conditional database constraint?
Unfortunately not. A case stage can have one or more recommendations at multiple stages. There can be zero to many stages with CASE_STAGE.STAGE_ID=1646
Sep
13
revised Can this business logic be enforced by a conditional database constraint?
added for clarity
Sep
13
asked Can this business logic be enforced by a conditional database constraint?