SQL Developer Select * from All ... Stopped AutoComplete

[Renato Menezes Viana]

Personnel:

Holy ignorance ... I was using the Oracle SQL Developer and he was autocompletting, for example, a SELECT command.

Select all

SELECT * FROM ALL_

Shortly after entering ALL_ He showed all tables that contained ALL_ for me to select

Select all

ALL_USERS 
ALL_VIEWS 
ALL_PROCEDURES 
ALL_SOURCES 
...

How to return this great ease? Better I reinstall?

Thanks

[Renato Menezes Viana]

Personnel: Run miraculously.

It turns out that now I can not put in the simple code of a procedure the Select below:

Select all

CURSOR MELECA IS SELECT * FROM DBA_DEPENDENCIES;

I attached the screen of the Error:

Select all

Erro(21,32): PL/SQL: ORA-00942: table or view does not exist

Holy ignorance.

[Renato Menezes Viana]

Personal: I used ALL_DEPENDENCIES instead of DBA_DEPENDENCIES is the same thing?

[dr_gori]

All_dependencies only shows the objects that you are allowed to see.
DBA_Dependencies shows all objects of the bank.

[fbifabio]

@Renato Menezes Viana

only to complement the last response. DD visions can be consulted on 3 levels:

1 - USER_*
All objects that the user owns.
2 - ALL_*
All objects that the user owns + objects from other users that he has access privilege.
3 - DBA_*
All BD objects.

If you are not a DBA user or with administrative privileges you will only be allowed to see the first 2.