Missing Tablespace under dba_free_space

[feng11]

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:

[Calvin_Qiu]

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.

[feng11]

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.

[pando]

well if it's full then obviously you cant see it

[tycho]

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