VERY FRUSTRATING to use sql developer.
In SQL DEVELOPER 3.1.07:
WHAT WORKS: select sequence# from v$archived_log
WHAT DOESN'T WORK : select * from v$archived_log
You've got to be kidding me.
I wish I can show a screenshot, but can't in this forum. Here's my description:
When I run the query, in the bottom frame for Query Results, it just says: Executing: select * from v$archived_log in 0 seconds.
Then there's no result grid.
Do you get the same result when running those queries in SQL*Plus (if you have it available to test)?
If so, then this seems more like a privilege issue. For example, read the following: how to hide table or column on table ?
I do not believe anyone else has reported the behavior you describe as an bug in the product.
SQL Developer Team
This was when connected to a standby db that's in mount state
Is this a 'manual' standby db? Are you using Data Guard?
Post the results for what Gary ask of running the queries in sql*plus. If those queries give the same result then this is NOT a sql developer issue.
Review the following thread and post back with what information in it applies to your use case. Re: V$ARCHIVED_LOG returns no rows on manual standby
If you are using Data Guard you may want to cross-post in that forum.