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
it seams, that you luck the ability to work with Oracle Server without ORA- message.
if you can't analyse problems, then you would even better not post your reply at all.
save your time and efforts next time, before you you attempt to reply.
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
Perhaps a quick review on asktom.oracle.com on how to present a failing use case might be of use to the OP
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.
i think the user require some more privilegen granted, especially execute to be granted explicitly.
in case someone is forced to use Windows OS and setup dbms_scheduler in DB, then make sure you start OracleJobSchedulerSID before OracleServiceSID or rebounce the DB.