X Dollors !!!!!!!!

[mrvajrala]

Hello,
I would like to query the x$ tables ( ex: x$kcbrbh ), I logged in as "SYS", i couldnt query the table. What could be the cause ???.

Any way to get the acceess...

Thanks in advance;
Madhu

[sambavan]

you might not be having the sysdba privileges.

SQL>connect sys as sysdba


Sam

[ashley75]

this could be stupid question but I am not clear. What is the difference between SYS and SYSDBA ??? How do I log in as SYSDBA ???

Could someone give me the full syntax since I tried what Sam advise on the above message and it's not working

[Raminder]

SYS is a user whereas SYSDBA is a special role.

Ashley, have you created the password file? Which Oracle version are you using?

[Edited by Raminder on 02-28-2002 at 05:29 AM]

[julian]

SYS is a user whereas SYSDBA is a special role.

SYSDBA is not a "special role". SYSDBA is a special privilege, one among the two main administrative privileges in Oracle.

[mrvajrala]

Guys,
I have connected as INTERNAL, even then I can see the following errors:

from sys.x$kcbrbh
*
ORA-00942: table or view does not exist
from sys.x$kcbrbh
*
ORA-00942: table or view does not exist

Pl suggest me what i have to do ?????

Thanks,
Madhu

[JChiappa]

This object is ** NOT ** created by default in 8i databases :

SQL*Plus: Release 3.3.4.0.0 - Production on Thu Feb 28
15:06:15 2002

Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.


Conectado a:
Personal Oracle7 Release 7.3.4.0.0 - Production
With the distributed, replication and parallel query options
PL/SQL Release 2.3.4.0.0 - Production

sys@po7:SQL> desc sys.x$kcbrbh
Name Null? Type
------------------------------- -------- ----
ADDR RAW(4)
INDX NUMBER
COUNT NUMBER
............

SQL*Plus: Release 8.1.7.0.0 - Production on Qui Fev 28 15:06:35 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Conectado a:
Personal Oracle8i Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

sys@po8i:SQL> desc sys.x$kcbrbh
ERROR:
ORA-04043: o objeto sys.x$kcbrbh não existe

--->> EXACTLY what you want to do here ?

[mrvajrala]

I really want to query this x$kcbrbh , And I ma unable to find it, as you said it might not be created by default, So which script to run to create this in my instance.

Will it have any ide effects ???

I donno, Pl let me know.

Thanks again,
Madhu

[amar]

Check your sys.v$fixed_table view - if "x$kcbrbh" table exists in the "name" col then you will find it otherwise ..............

-amar

[mrvajrala]

Any GURU can look into this plz ????