OraFAQ Forum: Backup & Recovery » select * from SYS.V$ARCHIVED

Home » RDBMS Server » Backup & Recovery » select * from SYS.V$ARCHIVED_LOG no rows selected

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

select * from SYS.V$ARCHIVED_LOG no rows selected [message #154834]

Tue, 10 January 2006 21:21

quytc
Messages: 81
Registered: November 2005
Location: Viet Nam

Member

Hi ALL,

I have a database in Archivelog mode.

SQL> select * from SYS.V$ARCHIVED_LOG
no rows selected
Can anybody tell me why??

Thanks,

Report message to a moderator

Re: select * from SYS.V$ARCHIVED_LOG no rows selected [message #154946 is a reply to message #154834]

Wed, 11 January 2006 08:16

DanielRey
Messages: 11
Registered: January 2006
Location: Mendoza, Argentina

Junior Member

Hi quytc

If I try
SQL> select * from SYS.V$ARCHIVED_LOG;

The respoonse is:
select * from SYS.V$ARCHIVED_LOG
*
ERROR at line 1:
ORA-00942: table or view does not exist

But,
SQL> select * from V$ARCHIVED_LOG;
works fine.

Why? V$ARCHIVED_LOG is a SYNONYM and the owner is PUBLIC.

Try without "SYS."

Regards.
Daniel

[Updated on: Wed, 11 January 2006 08:16]

Report message to a moderator

Re: select * from SYS.V$ARCHIVED_LOG no rows selected [message #155041 is a reply to message #154946]

Wed, 11 January 2006 19:38

quytc
Messages: 81
Registered: November 2005
Location: Viet Nam

Member

Hi,

I try to run
select * from V$ARCHIVED_LOG;
the result: No rows selected:

Even if my database in archivelog mode

Report message to a moderator

Previous Topic:	import error
Next Topic:	TableSpace Point In Time Recovery & Extend Management Dictionary

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 11:02:03 CDT 2024