# Quest Space Manager not found, on-demand tables not working

**URL:** <https://forums.toadworld.com/t/quest-space-manager-not-found-on-demand-tables-not-working/28555>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [January 28, 2014, 2:44am UTC](https://forums.toadworld.com/t/quest-space-manager-not-found-on-demand-tables-not-working/28555 "2014-01-28T02:44:16Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![ServiceAccount\_Toad](https://avatars.discourse-cdn.com/v4/letter/s/5f8ce5/32.png) [@ServiceAccount\_Toad](https://forums.toadworld.com/u/ServiceAccount_Toad)\
**Post date:** [January 28, 2014, 2:44am UTC](https://forums.toadworld.com/t/quest-space-manager-not-found-on-demand-tables-not-working/28555/1 "2014-01-28T02:44:16Z")

</div>

Hi,

I am trying to use the Space Manager, but when I try to invoke it I get the message that the Quest Space Manager is not found.

I am connected to the database as sysdba, so should not be missing any privileges.

I have a TOAD schema, but it only contains a single table - TOAD\_PLAN\_TABLE.

The server side objects wizard does not appear to exist anymore, and on-demand object creation does not appear to be doing anything.

I am using Oracle 10.2.0.5 and TOAD 12.0.0.61

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [January 28, 2014, 4:04am UTC](https://forums.toadworld.com/t/quest-space-manager-not-found-on-demand-tables-not-working/28555/2 "2014-01-28T04:04:35Z")

</div>

Let me start with my usual harping - there is no reason to connect as sysdba when using Toad. There are like 3 or 4 minor areas where this is required - e.g. running the instance manager where you want to start/stop databases. Sysdba should only be used when you know for a fact from reading Oracle docs that task X such as start/stop database requires me to connect as sysdba. It’s not a silver bullet fix all my problems tool.

That said, let me try to answer your question. Quest Space Manager is a separate product which requires a license - it is not a toad feature. Toad does have a limited feature to show the history of tablespace data file space usage and IO statistics. You go to main menu -\> database -\> administer -\> tablesapces. There will be two tabs near the end for the space usage history and IO stats. If you navigate to either of these tabs, toad will sense that the tables to support this feature are missing and ask if it’s OK to create them. That’s it.

Toad no longer offers either scripts or a database object creation wizard. Instead it now checks when you use a feature that requires an object, and if it’s missing it asks you. That makes it far easier for most people.

---

<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:** [January 28, 2014, 6:25am UTC](https://forums.toadworld.com/t/quest-space-manager-not-found-on-demand-tables-not-working/28555/3 "2014-01-28T06:25:04Z")

</div>

There was a bug in a recent version (it may have been 12.0, I don’t remember for sure) where it was difficult to get those objects to install. I just tried it and it worked OK for me, but if you can’t get them set up, send me an email (john.dorlon at software dot dell dot com) and I will send you the script to create them.

---

<div class="post-metadata">

**Author:** ![stevenrathke](https://avatars.discourse-cdn.com/v4/letter/s/f9ae1b/32.png) [@stevenrathke](https://forums.toadworld.com/u/stevenrathke)\
**Post date:** [November 13, 2019, 8:00pm UTC](https://forums.toadworld.com/t/quest-space-manager-not-found-on-demand-tables-not-working/28555/4 "2019-11-13T20:00:38Z")

</div>

Using toad for Oracle RAC, 13.1.1.5 many of the tools the user server side objects don't work. I got some objects to load into a TOAD SCHEMA for the table space manager. it installed a few tables and a package . All have public synonyms. I try as sys and TOAD user neither will get it going.

---

<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:** [November 13, 2019, 8:24pm UTC](https://forums.toadworld.com/t/quest-space-manager-not-found-on-demand-tables-not-working/28555/5 "2019-11-13T20:24:06Z")

</div>

Try this:

1. Restart Toad
2. Make a connection
3. Turn on Spool SQL. Main Menu -\> Database -\> Spool SQL -\> Spool to screen.
4. Main Menu: Database -\> Administer -\> Tablespaces, then go to the Space Manager tab. If you see a list of tablespaces, pick one.

If it doesn't seem to work, post a screen shot and the spool SQL contents.

If there is just nothing in the charts and you just recently set up the server side objects, maybe the problem is that the data collection job just hasn't had a chance to run enough times yet to get enough data to report on.

---

<div class="post-metadata">

**Author:** ![stevenrathke](https://avatars.discourse-cdn.com/v4/letter/s/f9ae1b/32.png) [@stevenrathke](https://forums.toadworld.com/u/stevenrathke)\
**Post date:** [November 14, 2019, 9:45pm UTC](https://forums.toadworld.com/t/quest-space-manager-not-found-on-demand-tables-not-working/28555/6 "2019-11-14T21:45:38Z")

</div>

This process works and is available to me - i can select a table space but however the icon to launch quest space manager does nothing. is there a tool there ?

here is the spool...

* * *

-- Session: SYS@DWREBUILD  
-- Timestamp: 14:29:05.106  
select 1 from dba\_tablespaces where tablespace\_name = 'SYSTEM' and extent\_management = 'LOCAL';

* * *

-- Session: SYS@DWREBUILD  
-- Timestamp: 14:29:05.362  
-- if this query is slow, see Oracle Doc ID 1292253.1  
select a.tablespace\_name,  
round(a.bytes\_alloc / 1024 / 1024) megs\_alloc,  
round(nvl(b.bytes\_free, 0) / 1024 / 1024) megs\_free,  
round((a.bytes\_alloc - nvl(b.bytes\_free, 0)) / 1024 / 1024) megs\_used,  
round((nvl(b.bytes\_free, 0) / a.bytes\_alloc) \* 100) Pct\_Free,  
100 - round((nvl(b.bytes\_free, 0) / a.bytes\_alloc) \* 100) Pct\_used,  
round(maxbytes/1048576) Max,  
c.status, c.contents  
from ( select f.tablespace\_name,  
sum(f.bytes) bytes\_alloc,  
sum(decode(f.autoextensible, 'YES',f.maxbytes,'NO', f.bytes)) maxbytes  
from dba\_data\_files f  
group by tablespace\_name) a,  
(  
select ts.name tablespace\_name, sum(fs.blocks) \* ts.blocksize bytes\_free  
from DBA\_LMT\_FREE\_SPACE fs, sys.ts$ ts  
where ts.ts# = fs.tablespace\_id  
group by ts.name, ts.blocksize  
) b,  
dba\_tablespaces c  
where a.tablespace\_name = b.tablespace\_name (+)  
and a.tablespace\_name = c.tablespace\_name  
union all  
select h.tablespace\_name,  
round(sum(h.bytes\_free + h.bytes\_used) / 1048576) megs\_alloc,  
round(sum((h.bytes\_free + h.bytes\_used) - nvl(p.bytes\_used, 0)) / 1048576) megs\_free,  
round(sum(nvl(p.bytes\_used, 0))/ 1048576) megs\_used,  
round((sum((h.bytes\_free + h.bytes\_used) - nvl(p.bytes\_used, 0)) / sum(h.bytes\_used + h.bytes\_free)) \* 100) Pct\_Free,  
100 - round((sum((h.bytes\_free + h.bytes\_used) - nvl(p.bytes\_used, 0)) / sum(h.bytes\_used + h.bytes\_free)) \* 100) pct\_used,  
round(sum(decode(f.autoextensible, 'YES', f.maxbytes, 'NO', f.bytes) / 1048576)) max,  
c.status, c.contents  
from sys.v\_$TEMP\_SPACE\_HEADER h,  
sys.v\_$Temp\_extent\_pool p,  
dba\_temp\_files f,  
dba\_tablespaces c  
where p.file\_id(+) = h.file\_id  
and p.tablespace\_name(+) = h.tablespace\_name  
and f.file\_id = h.file\_id  
and f.tablespace\_name = h.tablespace\_name  
and f.tablespace\_name = c.tablespace\_name  
group by h.tablespace\_name, c.status, c.contents  
ORDER BY 1;

---

<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:** [November 14, 2019, 10:00pm UTC](https://forums.toadworld.com/t/quest-space-manager-not-found-on-demand-tables-not-working/28555/7 "2019-11-14T22:00:34Z")

</div>

Oh, Quest Space Manager is a separate product. If it's not installed on your computer, that's why you are getting the message. Although, I would think in that case that the icon to launch it wouldn't be enabled at all.

Do you have that installed on your computer? If so, which version? Maybe you have incompatible versions of Toad and Space Manager.

---

<div class="post-metadata">

**Author:** ![stevenrathke](https://avatars.discourse-cdn.com/v4/letter/s/f9ae1b/32.png) [@stevenrathke](https://forums.toadworld.com/u/stevenrathke)\
**Post date:** [November 15, 2019, 8:08pm UTC](https://forums.toadworld.com/t/quest-space-manager-not-found-on-demand-tables-not-working/28555/8 "2019-11-15T20:08:48Z")

</div>

13.1.1.5 - I paid for the RAC version of TOAD for Oracle
