I have a 18.104.22.168 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?
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 09: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
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.