Message-Id: <10711.124698@fatcity.com> From: achoto@american.edu Date: Fri, 15 Dec 2000 09:11:37 -0500 Subject: Re: Moving tables to a different tablespace Sorry, I meant 8.0.5.2.1 Thanks Ana "Joseph S. Testa" To: Multiple recipients of list ORACLE-L Subject: Re: Moving tables to a different tablespace Sent by: root@fatcity. com 12/14/00 05:08 PM Please respond to ORACLE-L I hope you dont mean 8.0.2, that was a pre-production release. joe achoto@american.edu wrote: > > I forgot to include our version of Oracle. We're on 8.0.2.5.1 and Sun > Solaris 2.6 > > Thanks > > Ana > > > Ana Choto > To: Oracle List > 12/14/00 cc: > 02:45 PM Subject: Moving tables to a different tablespace > > > > I need to move some tables out of a tablespace into another. Is there > another option other than dropping the tables and recreating them in the > new tablespace? > > I have exported the user, but if I understand correctly I can import the > tables into a different user, but not into a different tablespace, or am I > wrong? I want to keep the owner as it is. > > Thanks > > Thanks > > Ana E. Choto > Systems Programmer > American University > e-Operations > Phone (202) 885-2275 > Fax (202) 885-2224 > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: teci@oracle-dba.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may