Export your tables. Drop tables and associated indexes.
Create Tablespaces and Users correctly.
Recreate tables (only structure) in appropriate tablespaces.
Import tables 'from user' and 'to user' with rows=y and ignore=y to import data from your export dump.
Recreate indexes.




Reply With Quote