While trying to move a table from one tablespace to another, I had to follow these steps.
( Table is not going to be copied to another schema, just within the schema, the tablespace is to be changed )
a. export the table
b. drop the table from the schema with cascade option
c. re-create the table in new tablespace along with
constraints and foreign key constraints in other dependant
d. Using import utility, IGNORE=Y option, reload the table
data from the dump file.
e. re-created indexes that were available earlier.
Performing the above steps doesn't take care of the existing user privileges on the table and how it will be re-created in the newly created table object.
Is there any other way out to have the privileges also restored in the re-created table?
Click Here to Expand Forum to Full Width