Re: How to move table with long objects?

In article <3AE951E1.E605D1B1_at_aixigo.de>, Heiko Stein <Heiko.Stein_at_web.de> writes:
>I would like to move a table with a long object to another tablespace.
>I use Oracle 8.1.6.
>
>I tried
> "alter table XY move tablespace AB"
>and
> "alter table XY move tablespace AB lob (LOB_COLUMN_NAME) store
>as ( tablespace AB )"
>
>but everytime I get the error "ORA-00997: Illegal use of LONG datatype".
>
>Any idea ???

The traditional method would be to exp the table, drop it, run the DDL to recreate the table in new tablespace, imp the table using the ignore=y parameter.

• Mark D Powell --
  • Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net