-
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
-
you might not be having the sysdba privileges.
SQL>connect sys as sysdba
Sam
Thanx
Sam
Life is a journey, not a destination!
-
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
-
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]
-
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.
-
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
-
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 ?
-
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
-
Check your sys.v$fixed_table view - if "x$kcbrbh" table exists in the "name" col then you will find it otherwise ..............
-amar
-
Any GURU can look into this plz ????
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|