How will you swap objects into a different table space for an existing database ?

Export the user Perform import using the command imp system/manager file=export.dmp indexfile=newrite.sql. This will create all definitions into newfile.sql. Drop necessary objects. Run the script newfile.sql after altering the tablespaces. Import from the backup for the necessary objects.

Interview Candidate
Sep 6th, 2004
3
2138

Memory Management

Answer

First
Prev
Next
Last

Showing Answers 1 - 3 of 3 Answers

simakas
Profile Answers by simakas

Oct 9th, 2007

If its the same database use:

alter table the_table move tablespace other_tablespace;
alter index the_index rebuild tablespace other_tablespace;