RE: Moving table to different tablespace

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Thu, 18 Jan 2001 11:47:31 -0800
Message-Id: <10745.127060@fatcity.com>

alter table <table_name> move tablespace <tablespace_name>;

Beware all indexes on the table will be marked as unusable and will need to be rebuilt. I don't belive it will work with tables that contain longs or long raws, but I haven't tested that assertion.

Ian

-----Original Message-----

From: Rahul Dandekar [mailto:orcldba_at_hotmail.com] Sent: Thursday, January 18, 2001 9:50 AM To: L; L
Subject: Moving table to different tablespace

Can I do it without export import?
Think there is a 8i feature or something?

Need to move replication table out of system tablespace. But don't want to do
export/import.....

Thanks

-Rahul

---

Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Received on Thu Jan 18 2001 - 13:47:31 CST