# Toad 13.0.0.80 : if you visualize a tablespace and you need to visualize datafile specifications, when you click on datafile name you'll get ORA-00942 in  for Oracle Versions 9i and previous ...

**URL:** <https://forums.toadworld.com/t/toad-13-0-0-80-if-you-visualize-a-tablespace-and-you-need-to-visualize-datafile-specifications-when-you-click-on-datafile-name-youll-get-ora-00942-in-for-oracle-versions-9i-and-previous/41184>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [July 18, 2018, 7:48am UTC](https://forums.toadworld.com/t/toad-13-0-0-80-if-you-visualize-a-tablespace-and-you-need-to-visualize-datafile-specifications-when-you-click-on-datafile-name-youll-get-ora-00942-in-for-oracle-versions-9i-and-previous/41184 "2018-07-18T07:48:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sergio.valle](https://avatars.discourse-cdn.com/v4/letter/s/c67d28/32.png) [@sergio.valle](https://forums.toadworld.com/u/sergio.valle)\
**Post date:** [July 18, 2018, 7:48am UTC](https://forums.toadworld.com/t/toad-13-0-0-80-if-you-visualize-a-tablespace-and-you-need-to-visualize-datafile-specifications-when-you-click-on-datafile-name-youll-get-ora-00942-in-for-oracle-versions-9i-and-previous/41184/1 "2018-07-18T07:48:50Z")

</div>

In Toad 1212 all is ok.

We spooled the relative code when we did the operation.

In Toad 13.0 only we saw this as last action :

select space  
from sys.dba\_recyclebin  
where space is not null  
and space \> 0  
and ts\_name = ‘’;

Why so ? What’s the use ?

Thank you

p.s. in older releases like 9i and 8i recyclebin do not exist … and we still have some old releases …

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [July 24, 2018, 10:20am UTC](https://forums.toadworld.com/t/toad-13-0-0-80-if-you-visualize-a-tablespace-and-you-need-to-visualize-datafile-specifications-when-you-click-on-datafile-name-youll-get-ora-00942-in-for-oracle-versions-9i-and-previous/41184/2 "2018-07-24T10:20:57Z")

</div>

We do some things differently depending on if recycle bin is empty or not. The query is to determine that.

You’re right, we should not run it prior to 10g.