1 2 Previous Next 17 Replies Latest reply: Apr 10, 2009 8:12 AM by SatishKandi RSS

    SCHEMA SIZE AND TABLESPACE SIZE

    693241
      Hi All,
      I have a schema dolphin3_t and the only tablespace used by it other than system,sysaux,temp is PHIN_DATA1. Last night a issue came up where space exceeded for the tablespace but the schema as such is having 19gb size where as
      the tablespace had 32gb (maximum value) but a datafile has been added to the tablespace again with 32gb. but how is this possible.

      SELECT Sum(bytes)/1024/1024/1024 FROM dba_data_files WHERE tablespace_name LIKE 'PHIN_DATA1'
      61.6015625

      SELECT Sum(bytes)/1024/1024/1024 FROM dba_segments WHERE owner = 'DOLPHIN3_T'
      19.25311279296875

      should the first query return a value lesser than the one gievn by second query .
      Note: The tablespace is used by dolphin3_t schema only.

      My guess is the other shift guy has mistaken quota shortage for space shortage in datafile.





      Thanks
      Vijay G
      6721
        1 2 Previous Next