Can someone please advise how I can go about converting existing tablespaces to enable RECLAIMABLE Storage. Would a redirected restore do the trick ? Also what if any are the advantages of also converting to LARGE ?

Tablespaces in question are all DMS configured with MANAGED BY AUTOMATIC STORAGE, 2 containers on 2 discs per tablespace.

Many thanks, Fin.

On Thursday, August 2, 2012 11:41:01 PM UTC+2, Fin wrote:
Hi Fin,

What's the version you're currently running?

Luiz

Express-C 10.1 LUW on WIndows 7 Pro.

On Friday, August 3, 2012 10:59:14 AM UTC+2, Fin wrote:
If the tablespaces were created in a 9.7 or above, you should have no problem to use "ALTER TABLESPACE" with "REDUCE" option... Are you facing any issue?

Yeah, sadly my Tablespaces were not created in 9.7 or above so the alter tablespace command fails. I have literally hundreds of tables that have indexes in my INDEXES tablespace and I was hoping there was a command or procedure somewhere I am missing to convert the tablespace to allow reclaimable storage. Unloading and reloading the tables is out of the question, as is moving tables via the admin move table util. I am not doing that hundreds of times simply to lower the high water mark on the indexes tablespace.

On Friday, August 3, 2012 11:40:02 AM UTC+2, Fin wrote:
In our shop, we faced the same situation and we've chosen this approach:
1) Create a new database.
2) Configure Federation/Nicknames
3) Loop through all tables using Load from Cursor in the new db.