How to move table to different tablespace

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Article Type: General
Product: Aleph
Product Version: 21

Description:
How would we move a table (znn) to a different tablespace?

Resolution:
You would need to run p_file_03 to back up the table. (Check the $data_files to make certain that znn.seq has been created.) Then:

change the file_list entry to the desired tablespace;
SQL> drop table znn;
> util a/17/1 znn to create it in the new tablespace. (util a/17/1 can’t handle switch of tablespace without the SQL drop.)
> p_file_04 to load the backed-up table into the new tablespace.

Alternatively, the table could be exported/imported using the $aleph_proc/oracle_expdp_table / $aleph_proc/oracle_impdp_table procedures. {See KB 16384-56929 ("Use Oracle Data Pump to transfer individual table to Test"). }

Article last edited: 10/8/2013