tablespace full

[thockman]

So the dba was out for the day and we had an issue with tablespace in our training env. I took the opportunity to add to my oracle knowledge.
First I needed to find what datafile the tablespace used.
Using sqlplus and the below it will show you what dbf file or files are used.

Code: Select all

SELECT TABLESPACE_NAME FROM DBA_TABLES WHERE TABLE_NAME = 'tablespace_name'

Then instead of using alter tablespace I used OEM to increase the datafile. The reason I used OEM was because I was already logged in and was seeing an issue while comparing what OEM showed for datafiles versus what the select showed.
While in OEM the tablespace showed that it had 10 datafiles listed in the datafile column, however when I went to the details of the tablespace it did not list the datafiles.
Then I went to the datafiles and increased the size of the last datafile and after that the datafiles showed correctly for the tablespace detail.

Not sure why but that was wierd.