When trying to setup the Space Manager from DBA|Tablespaces,user receive "The Space Manager tables were not found. To create them, ensure you are connected as the Toad user then select the Create Space Manager Tables button on the Space History or IO History tab" message.
Before you can use Space Manager, you must set up specific objects in the TOAD schema.
1. Login as Toad user
2. Click the Create/Recreate TOAD Space Manager Tables button
NOTE: The TOAD schema must have the privileges to create and alter jobs, create and drop its own tables and procedures, and must have SELECT access on: DBA_TABLESPACES, DBA_DATA_FILES, DBA_FREE_SPACE, and V_$FILESTAT.
3. a. Enter the starting date to Execute the job. Click the drop down to display a calendar, or edit the day and year directly in the edit box. If the collection job is not present, then the default is a few minutes in the future. If the collection job is active, then the default is the Next Execution date of the existing collection job. If the collection job is inactive, then the default is many years in the future (which is what Oracle stores as the Next Execution date of the existing job).
b. In the At this time: field, enter the time of day you want the data collection performed.
c. Decide how often you want to collect the information. You can:
- Select a choice from the drop down menu below the At this time: field or you can enter the formula by hand in the field beneath the Execute this job on: field.
4. Grant explicitly the following views:
grant select on SYS.V_$SYSSTAT to public;
grant select on SYS.DBA_TABLESPACES to toad;
grant select on SYS.DBA_DATA_FILES to toad;
grant select on SYS.DBA_FREE_SPACE to toad;
grant select on SYS.V_$FILESTAT to toad;
