I have multiple workspaces under one model, where each workspace is a separate schema with tablespaces. I have been able to write a script that iterates through the indexes of an entity and assign the tablespace for each based on the entities schema. However I haven’t been able to assign the schema to each index. It is available in the drop down box on each index, but I have been unable to access it through scripting.
I have attempted to use the Scripting Reference Guide and have had some success, but not in this instance.
Database: Oracle 12c
Toad Data Model: version 184.108.40.206
Any and all assistance would be greatly appreciated.