Home » RDBMS Server » Server Administration » moving table with long raw column
moving table with long raw column [message #53691] Sat, 05 October 2002 02:33 Go to next message
Mike
Messages: 417
Registered: September 1998
Senior Member
Hi.
I want to move table which contain long raw column to another tablespace.
alter table .. move - gives error ( ORA-00997: illegal use of LONG datatype).
Also i can't use: create table as select *.. (same error).

SQLPLUS COPY operation also did't help me
(ERROR:ORA-00932: inconsistent datatypes)

If somebody knows how to move this kind of tables -
please help.

Thanks,
Mike

Report message to a moderator

Re: moving table with long raw column [message #53704 is a reply to message #53691] Sun, 06 October 2002 21:57 Go to previous messageGo to next message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Mike,

Use export/import on this table. That works for me on my database.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Re: moving table with long raw column [message #54797 is a reply to message #53691] Thu, 05 December 2002 09:20 Go to previous messageGo to next message
anny
Messages: 4
Registered: December 2002
Junior Member
only with impor or export -
there is cool site http://asktom.oracle.com
(there search Archives for "MOVE TABLE")

Report message to a moderator

Re: moving table with long raw column [message #54799 is a reply to message #53704] Thu, 05 December 2002 09:46 Go to previous message
anny
Messages: 4
Registered: December 2002
Junior Member
or if you have TABLE1 (a long, b number)
make:

create table TABLE2 as (a CLOB, b number)

insert into TABLE2(a,b)
SELECT to_lob(a), b FROM TABLE1 - Works GOOD and you
get rid of the nasty LONG type!!!!!!!!!

I faced with this prombem and recreate all my tables!!!!

Report message to a moderator

Previous Topic: Describe V_$SGA
Next Topic: application not utilizing indexes
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 04:56:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.