By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,502 Members | 1,878 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,502 IT Pros & Developers. It's quick & easy.

Moving a table from one tablespace to another tablespace

P: n/a
Hi NG

what is the easiest way to move a table from one tablespace to another ?

Thanks
Peter

Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
The answer is highly dependant on your version. If you have 8i at
least, just do "alter table yourtablename move (online) tablespace
newtablespace". Look in the SQL reference manual for all the options
you can use while doing this move.

Daniel
Hi NG

what is the easiest way to move a table from one tablespace to another ?

Thanks
Peter

--

Jul 19 '05 #2

P: n/a
The answer is highly dependant on your version. If you have 8i at
least, just do "alter table yourtablename move (online) tablespace
newtablespace". Look in the SQL reference manual for all the options
you can use while doing this move.

Daniel
Hi NG

what is the easiest way to move a table from one tablespace to another ?

Thanks
Peter

--

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.