Home » RDBMS Server » Server Administration » How to move a table with a LONG column to another tablespace?
How to move a table with a LONG column to another tablespace? [message #62317] Wed, 14 July 2004 03:42 Go to next message
Tian Maohuai
Messages: 23
Registered: December 2003
Junior Member
When I try to move a table which has a LONG type column to another tablespace,it failed.the command I used is "alter mytab move myts",I have successfully moved some common tables without LONG column,BUT HOW CAN I MOVE A "LONG" COLUMN TABLE?HELP ME!!!

Report message to a moderator

Re: How to move a table with a LONG column to another tablespace? [message #62318 is a reply to message #62317] Wed, 14 July 2004 04:13 Go to previous message
Oskar
Messages: 26
Registered: May 2002
Junior Member
You can't. You need to create that table in target tablespace and then move the rows to the new object (use export/import or create table as select and then rename)

Report message to a moderator

Previous Topic: ora-00405: Compatibility type "MV81"
Next Topic: info on grants for sequences,procedures & functions
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Feb 12 21:24:13 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.