Home » RDBMS Server » Server Utilities » How can I move a table with a LONG column to another tablespace?
How can I move a table with a LONG column to another tablespace? [message #73799] Wed, 14 July 2004 03:46 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 can I move a table with a LONG column to another tablespace? [message #73800 is a reply to message #73799] Wed, 14 July 2004 04:06 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
export the table
recreate the table in another tablespace
import the table.

Report message to a moderator

Previous Topic: Problem in starting Database
Next Topic: Loading DATE & TIME using the SQL-LOADER
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 09:11:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.