ISSUE: How to change the shared space name in Octane
Determine the shared space schema containing the workspace you wish to change. Do so by issuing a query to the Octane admin schema…
select * from <octane_site_schema>.shared_space;
Note the value in the field SP_ID and SP_NAME. The value in the SP_NAME is the name of the Shared Space. Not its SP_ID value as that is used in the next query
Update the Shared Space name by issuing the following query…
update <octane_site_schema>.shared_space set sp_name = '<new_shared_space_name>' where SP_ID = <SP_ID>
Restart the Octane service for the changes to take effect