Re: Moving tables to a different tablespace

From: <achoto_at_american.edu>
Date: Thu, 14 Dec 2000 15:00:30 -0500
Message-Id: <10710.124617@fatcity.com>

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

Ana E. Choto
Systems Programmer
American University
e-Operations
Phone (202) 885-2275 Received on Thu Dec 14 2000 - 14:00:30 CST