DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: X Dollors !!!!!!!!

  1. #1
    Join Date
    Feb 2001
    Posts
    290
    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

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    you might not be having the sysdba privileges.

    SQL>connect sys as sysdba


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jan 2002
    Posts
    474
    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


  4. #4
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    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]

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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.

  6. #6
    Join Date
    Feb 2001
    Posts
    290
    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

  7. #7
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    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 ?

  8. #8
    Join Date
    Feb 2001
    Posts
    290
    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

  9. #9
    Join Date
    Mar 2001
    Posts
    314
    Check your sys.v$fixed_table view - if "x$kcbrbh" table exists in the "name" col then you will find it otherwise ..............

    -amar

  10. #10
    Join Date
    Feb 2001
    Posts
    290
    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
  •  


Click Here to Expand Forum to Full Width