1 - After creating the tables in the new DBSPACE, can I recreate the tables in the original DBSPACE ?. I suppose so, using the same command that was used to move them from DBSPACE. I ask this because all my tables are in a single DBSPACE. I understand this would involve doing the job 2 times for each table, but I would like to keep all the tables together.
2 - Assuming that when you return the table to its original DBSPACE, it runs out of space, how could I solve it?
3 - Does this process also copy the indexes of the tables ?.
4 - The NEXT SIZE value could be indicated as a percentage ratio of the size of each table ?. This because the table would already be compacted by calling it somehow.
The app in question doesn't happen to be SAP, does it?