Skip to Main Content

Moving tables to a new default tablespace

FabiorepettoNov 6 2002
I want to move all the tables owned by a user (OUTLN) to a new tablespace.

I know that if I make an export file of that schema and then I make an import after deleting the tables and changing the default tablespace of that schema I should solve the problem (as suggested from documentation), but it isn't so.

The tablespace of the tables after the import remains the same.

Why?

Thank you
Comments
Post Details
Added on Nov 6 2002
2 comments
222 views