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
|
Mar 9 |
comment |
How can I allow an Oracle database to be accessed remotely? and the database is installed on windows or linux? |
|
Jan 18 |
comment |
Oracle 10g express database link to Oracle 8i I can now verify that Oracle 10 XE can connect to Oracle 8i with a database link. Those of you with legacy databases can still keep in touch from 11g at no cost |
|
Dec 30 |
comment |
Is there an Oracle rdbms monitoring API? what are the other important metrics you wish to monitor |
|
Oct 31 |
comment |
function based index as a conditional unique key? A composite index will do the job thank you! |
|
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 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 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 11 |
comment |
Revenue Assurance database creation More information is required: type of data that will typically be entered (VARCHAR2, NUMBER, CLOB), type of transactions (data entry, reporting), version of database would be helpful |
|
Aug 28 |
comment |
How to make a duplicate field cheap? How is the information entered in each table? Does one process write to each table consecutively? Or does the second entry get created later? |
|
Aug 26 |
comment |
Can you trigger an action when a view is created? this is how you can comment on a view: comment on table aschema.myview is 'number of issues by calendar year'; (notice how even if it is a view you have to say table) SELECT * FROM all_tab_comments WHERE owner = 'aschema'; but you will need privileges to query these system data views |
|
Aug 25 |
comment |
Can you trigger an action when a view is created? A good idea but I wish to add a descriptive comment about what the view is for so I need a table for that anyway. |
|
Aug 25 |
comment |
Can you trigger an action when a view is created? That works! I can't see how to accept this as an answer. Maybe it's my browser. |
|
Aug 15 |
comment |
Is there a Storage-Engine/DB that logs all changes and allows selective rollback of specific changes? I don't think you can get a good answer to #8 until you put some more business logic around it. For example, User A member of group #1 makes an edit on Monday. Tuesday User A leaves group #1 and becomes a member of group #2. Wednesday you want to roll back all the edits for members of group #1. Tell us what you think should happen. Then make it more complex and tell us what you think should happen. This is an unusual requirement and just the sort of thing hand coding is required for. |
|
Aug 14 |
comment |
When should you denormalize? I denormalize when I am creating reports or analysis and I want speedy results. All the indexes in the world with multiple joins are never so fast as a denormalized table that represents cached data that is not going to change. |
