Re: Moving Tablespaces

From: Mark Malakanov <markmal_at_delete-this-antispammer.home.com>
Date: Sun, 22 Apr 2001 16:33:23 GMT
Message-ID: <nJDE6.29132$_P.7313153@news3.rdc1.on.home.com>

It depends on version of Oracle.

The way works everywhere - export table, drop table, create table in other TS, import data into table.

In Oracle 8i
alter table move online tablespace OTHER_TS;

--
-----------------------------------------------------
Thanks,
Mark

"Ryn" <matty91_at_mindspring.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:9bup3v$j0f$1_at_slb7.atl.mindspring.net...


> Hello folks,

>

> What is the easiest way to move a table from one tablespace

> to another? I have also been asked to save individual tables

> based on size. Has anyone written a script to export individual

> tables based on table size > X? I assume if something got corrupt

> I would need to drop table X then imp it??

>

> Thanks for any info,

>

> Ryn

>

>

Received on Sun Apr 22 2001 - 11:33:23 CDT