-
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
tables.
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|