Missing Tablespace under dba_free_space
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Missing Tablespace under dba_free_space

  1. #1
    Join Date
    Oct 2002
    Location
    Singapore
    Posts
    49

    Missing Tablespace under dba_free_space

    I have a 8.1.6.0 instance running. I have 4 tablespaces created that is reflected in the dictionary view of dba_tablespaces, dba_data_files. THis live database already has tables created in one particular tablespace. However there is this one particular tablespace is not found under the dba_free_space view.

    is this a patch problem? Has anyone encounter this before?

    Rdgs:
    Regards
    CF

  2. #2
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Strange, create a table in that tablespace then try to query the view again.

    Note: When you create or resize tempfiles, they are not always guaranteed allocation of disk space for the file size specified. On certain file systems, disk blocks are not allocated on file creation or resizing, but before the blocks are accessed. This enables fast tempfile creation or resizing.
    Last edited by Calvin_Qiu; 11-10-2002 at 10:26 PM.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  3. #3
    Join Date
    Oct 2002
    Location
    Singapore
    Posts
    49
    Hi,
    There are many tables already created under this missing tablespace name, and the db is in production. Everything is ok. Applications are accessing the live data from these tables. You can find this TBS under dba_tablespaces and even the phys file under dba_data_fles. Just that it does not appear in dba_free_space.
    Regards
    CF

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well if it's full then obviously you cant see it

  5. #5
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234
    Feng11

    So what Pando means is enlarge one of the datafiles from the "missing" tablespace and it will show up again in the dba_free_space view.

    select tablespace_name, file_name, bytes/1024/1024 from dba_data_files;

    Use this info for the next command.

    alter database datafile '' resize ???M;

    Tycho

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