meta user
network profile
| bio | website | |
|---|---|---|
| location | Ottawa.Ontario, Canada | |
| age | 54 | |
| visits | member for | 1 year, 10 months |
| seen | yesterday | |
| 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
|
Oct 7 |
comment |
How do you document your databases? requires .NET Framework 4.0 and only works with SQL Server and SQL Express |
|
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. |
|
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 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 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 |
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 |
|
Jul 24 |
comment |
ORA-00379 no free buffers You could tell us what version of Oracle you are using and what DB_BLOCK_BUFFERS is set to. That would help. |
|
Jul 10 |
comment |
Unable to mount oracle instance I don't suppose a reboot fixes this? |
|
Jun 8 |
comment |
Remote to a remote oracle server and get running instances? Run scripts without a password? Sounds like a security risk |
|
May 8 |
comment |
Error while importing a “.sql” file in database what kind of database? |
|
Apr 27 |
comment |
Creating Indexes to optimize query what indexes do you have on MYTAB1 and MYTAB2? This is difficult to answer without more information on the table structure |
|
Mar 22 |
comment |
Import Oracle full dump file to fresh Oracle installation Sorry I missed that you had a 9i source. You will be forced to use exp and imp commands and physically copy your dump files from one machine to another |
