Missing Tablespace under dba_free_space
I have a 126.96.36.199 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.
well if it's full then obviously you cant see it
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;
Click Here to Expand Forum to Full Width