OraFAQ Forum: SQL & PL/SQL » ORA-04043: object SYS.dba

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-04043: object SYS.dba_tables does not exist.

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

ORA-04043: object SYS.dba_tables does not exist. [message #1456]

Thu, 02 May 2002 07:23

manemang
Messages: 5
Registered: May 2002

Junior Member

Hello Fellas,
I just created a test database and ran the catalog, catproc and pupbld scripts. When I launch SQL Plus however, I'm not able to access the dictionary views.
Take for example;
Desc dba_tables gets the ERROR:
ORA-04043: object SYS.dba_tables does not exist.
When I log into SQL Plus as SYSTEM, I'm able to access the dictionary/performance views. When I log in as a user I created and had granted the sysdba and Sysoper priviledges, I still come up with the errors. I'm running on NT4.0 with Oracle 8.0.4. Please help.

Report message to a moderator

Re: ORA-04043: object SYS.dba_tables does not exist. [message #1458 is a reply to message #1456]

Thu, 02 May 2002 07:46

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

did you give dba privelege?
grant dba to user;

Report message to a moderator

Re: ORA-04043: object SYS.dba_tables does not exist. [message #1471 is a reply to message #1456]

Fri, 03 May 2002 16:57

manemang
Messages: 5
Registered: May 2002

Junior Member

Yes Mahesh I did grant the sysdba and sysoper privileges to the user I created. when i log as system in the schema, i'm able to pull the views.

Report message to a moderator

Re: ORA-04043: object SYS.dba_tables does not exist. [message #1483 is a reply to message #1456]

Mon, 06 May 2002 05:40

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

you gave SYSDBA only.
but did u grant the DBA role?
both are different!!
login as a user with sysdba(sys or system) and

grant dba to scott;

Report message to a moderator

Re: ORA-04043: object SYS.dba_tables does not exist. [message #1486 is a reply to message #1456]

Mon, 06 May 2002 07:19

Grant
Messages: 578
Registered: January 2002

Senior Member

It appears you ran the scripts as SYSTEM and not SYS. All scripts must be run connected as INTERNAL (SYS) except pupbld (run as SYSTEM).

Report message to a moderator

Re: ORA-04043: object SYS.dba_tables does not exist. [message #1493 is a reply to message #1456]

Mon, 06 May 2002 11:55

Munish
Messages: 21
Registered: November 2001

Junior Member

Hi..

Check to see..if the synonym has been created for those tables.

eg.
select owner,synonym_name from all_synonyms
where table_name = 'DBA_TABLES'

answer should be :-

OWNER SYNONYM_NAME
------------------------------ -----------------------
PUBLIC DBA_TABLES

Report message to a moderator

Previous Topic:	Re: Calculate days between dates.
Next Topic:	Oracle9i personal edition download

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 04:06:24 CDT 2024