You have to do exp/imp on that table.



"Burris Mark " <oracledba-ezmlmshield-x22008645.[Email address protected]
01/31/2007 10:15 AM


To
"LazyDBA Discussion" <[Email address protected]

cc


Subject
Moving tables to a different tablespace







I want to move some tables to a different tablespace and I can't do the
move table command because the table has long columns. What would be
the best approach to move these tables.



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




To: "LazyDBA Discussion" <[Email address protected]
cc:
From: "Burris Mark "
<oracledba-ezmlmshield-x22008645.[Email address protected]

**********************************************************************
This e-mail transmission and any attachments that accompany it may
contain information that is privileged, confidential or otherwise
exempt from disclosure under applicable law and is intended solely for
the use of the individual(s) to whom it was intended to be addressed.
If you have received this e-mail by mistake, or you are not the
intended recipient, any disclosure, dissemination, distribution,
copying or other use or retention of this communication or its
substance is prohibited. If you have received this communication in
error, please immediately reply to the author via e-mail that you
received this message by mistake and also permanently delete the
original and all copies of this e-mail and any attachments from your
computer. Thank you.
**********************************************************************

Oracle LazyDBA home page