New database SELECT dba_views error!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: New database SELECT dba_views error!

  1. #1
    Join Date
    May 2002
    Posts
    4
    Hi!

    I have one problem , and I can't find the solution.
    I built manually database, that has 2 tablespaces (system and user01).
    I can start it up, and connect as internal.
    When I use SELECT with V$ dynamic requests, it's working.
    Example:
    select * from v$tablespace;
    it returne:
    TS# NAME
    --------------
    0 System
    1 User01

    But, when I try to run SELECT DBA_something, it returns error:
    select * from dba_data_files;

    ERROR at line 1
    ORA 00942: table or view does not exist.

    And request that consist of SELECT * from dba_somethink return same error?!!!

    Perhaps it looks silly, but I can't find the explanations (I just begin to study Oracle).
    Can somebody help me?

    Thank you.
    Best regards.
    Yan.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you have to run catalog.sql to generate these views

  3. #3
    Join Date
    Jun 2002
    Posts
    1

    Red face

    Hope you are not connecting as a different user while viewing from DBA_VIEWS !!

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well if the user you are using can see v$ views you should be able to see DBA_XXX, if you cannot then most probably is you have not run catalog.sql

  5. #5
    Join Date
    May 2002
    Posts
    4

    Spesial thanks to Pando!

    Thank you very much!

    You are right. When I executed the catalog.sql, all dba_XXX view began to work.

    Thank you for advice.
    Yan.

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