Re: How do I create a table from a table containing a LONG col?

From: <alistair.thomson_at_sphinxcst.co.uk>
Date: Mon, 24 Jan 2000 15:04:25 GMT
Message-ID: <86hpll$g9b$1@nnrp1.deja.com>

Try exporting the table, drop the table, change your default tablespace to where you want the table built then import the table.

HTH Alistair Thomson

In article <mxoi4.428$0B6.66631_at_news4.usenetserver.com>, Scott Forbes <Scott_member_at_webusenet.com> wrote:
> I have a number of tables containing LONG columns ... which I wish to
move to
> different tablespaces ... I keep receiving the ORA-00997 error which
trying to
> create and/or populate the tables ... Anyone got a workaround?
>
> Scott Forbes. FTCI.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 24 2000 - 09:04:25 CST