meta user
network profile
| bio | website | |
|---|---|---|
| location | Ottawa.Ontario, Canada | |
| age | 54 | |
| visits | member for | 1 year, 10 months |
| seen | 1 hour ago | |
| 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
|
Nov 27 |
asked | Decision tables in the database: a valid solution? |
|
Nov 25 |
answered | Advanced search engine or server for relational database |
|
Nov 6 |
answered | Recommended model for application level event logging |
|
Nov 1 |
accepted | function based index as a conditional unique key? |
|
Oct 31 |
revised |
function based index as a conditional unique key? clarified after justin caves answer |
|
Oct 31 |
comment |
function based index as a conditional unique key? A composite index will do the job thank you! |
|
Oct 31 |
asked | function based index as a conditional unique key? |
|
Oct 15 |
answered | Read Oracle BLOB type via SQL |
|
Oct 4 |
awarded | Enthusiast |
|
Oct 1 |
answered | Tool to monitor database data |
|
Sep 29 |
comment |
How to compare the database of a backup from another environment You don't normally need luck when you are using export or the data pump, they are very reliable. Have you had previous errors in backup? What were they? |
|
Sep 21 |
answered | Compare content of databases in Oracle |
|
Sep 20 |
awarded | Commentator |
|
Sep 20 |
comment |
Compare content of databases in Oracle are these databases supposed to be the same? Is this some variety of asynchronous replication? Or is only some of the data supposed to be the same in each database? And is the data numbers, CLOBS, XML? |
|
Sep 17 |
revised |
Is it safe to let application administrators look at v$session, v$process, and v$sql? replying to op's additional comment |
|
Sep 16 |
comment |
What to do with those invalid JAVA CLASS object type objects in SYS prior to the upgrade the oracle db from 10g to 11g? Then your next step is to remove and reinstall java. Or decide to do a fresh install of Oracle 11g and then do an import or data pump from the older version.I would add more but this expands the scope of the question beyond JAvA classes |
|
Sep 15 |
comment |
How do I correctly design this database? You should also have columns in the group and user tables for date created, date last modified, created by, last modified by and whether the group or user is disabled |
|
Sep 15 |
accepted | Consequences of changing NLS_TIMESTAMP_FORMAT |
|
Sep 14 |
asked | Consequences of changing NLS_TIMESTAMP_FORMAT |
|
Sep 12 |
awarded | Citizen Patrol |
