Alter LONG RAW to BLOB and you will be able to move tables around using
alter table ... move syntax. If you definitely can't live without LONGs, you can
export the table data, drop table, create it with new storage and import table
data back into it. Or you can do what you suggested: create new table,
copy data from old table into new one using a PL/SQL loop, drop old table,
rename new to old, recreate indexes.
IMO export/import is much easier and works a lot faster, plus you will get
your table reorganized as side effect.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"KnutA" <knut.aarrestad_at_emisoft.com> wrote in message news:aa3bm6$n06$1_at_news.ost.eltele.no...
> Hi
>
> I'm organizing tables into different tablespaces, and have been using 'ALTER
> TABLE <table_name> MOVE TABLESPACE <new Tablespace>'.
>
> This works fine for most tables, but for those containing a LONG_RAW column,
> it does not (ORA-00997: illegal use of LONG datatype).
>
> Is there a quick way to move these?
>
> I know i can rename the old, create a new table, and move data with some
> application, but that is a pretty large job.
>
> My problem involves about 20 tables, and I will probably do this to several
> databases.
>
> Knut
>
>
>
Received on Wed Apr 24 2002 - 02:49:22 CDT
