ghost tablespace?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ghost tablespace?

  1. #1
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Hi ppl

    I have recenty find a problemwhen i query dba_tablespaces and dba_data_files and v$datafile in order to find out what tablespaces are present and which files etc. There is one tablespace, the temporary one which never shows up in none of these views and the only way to find ts existence is through Enterprise Manager. Anyone know any reason about this?


    Cheers

  2. #2
    Join Date
    Jul 2000
    Location
    delhi,india
    Posts
    10
    Hi ,
    Which version of oracle are you using.if you are using 8.0(upwards),then i think the problem is due to the fact that the tablespace was created using the temporary option.(i'm not too sure)i too faced this problem some time back but i don't remember the exact reason for this.but if this is the reason,let me know.Thanks.

    Rajesh.

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    the version is 8.1.5 now migrated to 8.1.6, it didnt appear before migration nor after. There is another temporary tablespace and that one does appear :o
    However the one which everyone use is the one that I can only see from OEM

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