network profile
| bio | website | |
|---|---|---|
| location | Idaho Falls, ID | |
| age | ||
| visits | member for | 2 years, 2 months |
| seen | May 18 at 22:56 | |
| stats | profile views | 26 |
|
Mar 22 |
awarded | Yearling |
|
Mar 22 |
answered | Materialized view log not updating |
|
Mar 22 |
revised |
Materialized view log not updating edited tags |
|
Mar 22 |
revised |
Materialized view log not updating edited tags |
|
Mar 22 |
revised |
Materialized view log not updating added 44 characters in body |
|
Mar 22 |
asked | Materialized view log not updating |
|
Dec 28 |
comment |
RMAN backup script failing I think it should work. Try it and see. You don't even need to actually run the backup stuff to examine the environment variables. |
|
Dec 28 |
answered | RMAN backup script failing |
|
Aug 19 |
comment |
Oracle startup error: “end-of-file on communication channel” Have you checked the alert log for the database? |
|
Apr 17 |
answered | ORA-39142: incompatible version number 3.1 error work-around |
|
Mar 17 |
awarded | Yearling |
|
Dec 22 |
comment |
What is Utility_DSN? Better late than never! Thanks for the reply. I have not consciously made use of any connections to non-oracle databases that I know of. Perhaps something was installed on these servers that caused this entry to be created. At any rate, I now have something to look for. This is a Windoze shop, so /etc/oratab isn't in play. Good info, thanks again. |
|
Dec 22 |
accepted | What is Utility_DSN? |
|
Dec 21 |
comment |
How does an alter work? Thanks for the correction, Mark. I've changed my answer to reflect this. |
|
Dec 21 |
comment |
How does an alter work? Even if no row chaining occurs, the bottom line is that at a minimum, every row needs modification to add the new columns. But yes, row chaining would make the effect worse. |
|
Dec 21 |
answered | How does an alter work? |
|
Jul 23 |
comment |
Error updating a master table of a materialized view Unless I'm reading the docs wrong, it's pretty clear that it's a fast refresh that's done. Would you really want a complete refresh of your MV on every commit on the master? That would really slow down any commits. I just don't see how that would work. |
|
Jul 22 |
comment |
Error updating a master table of a materialized view It is a fast refresh: REFRESH ON COMMIT (from the docs): "Specify ON COMMIT to indicate that a fast refresh is to occur whenever the database commits a transaction that operates on a master table...". |
|
Jul 22 |
comment |
Oracle Grid Control Notification for Data Guard failures And, today, I got notification that Data Guard was having trouble, so this has solved my problem. Thanks Leigh and Kerri for your help. |
|
Jul 21 |
answered | Error updating a master table of a materialized view |
