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 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 |
|
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 |
