During the creation of a new index, I go to the ‘Storage’ tab to assign a tablespace for the new index.
However, our list of Tablespaces has suddenly shrunk to one. I can see the and one other option. This happens on all our pc’s running 6.3
Is there a setting that is restricting this list?
When I click on Tablespaces in DB Navigator, I get the following error:
14:17:56 Oracle Query: FieldAsInteger: List index out of bounds (-1) - Index out of bounds
- Create the index in the default tablespace
- Extract the ddl, drop and recreate the index in the correct tablespace. (INDEXES)
- When I view the index, it correctly show the tablespace as INDEXES