This content has been marked as final. Show 7 replies
Quite often an interval of 60 seconds or less is too often.
And refreshing an MV every minute looks pretty undesirable to me, especially when it is not a fast refresh.
You would be better off with a database link.
And,no, 'not working' does call for webcams and crystall balls, does it.
Without any status info, or explicit error message, you would even better not post this at all.
Senior Oracle DBA
When I run into problems I do analysis myself. As opposed to just dumping my problem in a forum of volunteers, and sitting back with my feet on my desk, waiting until the replies come in.
It seems you are more talented in flaming, than setting up information systems properly. A 1 minute refresh interval is pretty daft, and likely the rest of your system is as clunky as this part, just because you refuse to read documentation, and play the role of 'DBA' with as little effort as possible.
Maybe you should seek a profession where your talents to insult people, at the same time being lazy, is more appreciated.
Senior oracle DBA
how did you come up with all this nonsense... the forum is there to share usefull information and experience ... and most of the time, it gives just one hint that the other might have just misread.
never take others ideas as daft, because it imply how untalented, unexperianced you are.
i will forward your behaiviour to oracle forum managment, and soon you're no longer existent in this forum.
and for your information, i have been successful in sharing my experiance in this branch and the rewards were granted.