Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> moving tables from one tablespace to another

moving tables from one tablespace to another

From: harish <harishksh_at_yahoo.com>
Date: 18 Mar 2003 20:44:00 -0800
Message-ID: <ff46df6e.0303182044.705e16b7@posting.google.com> 





in my oracle 8i database, when database is exported from one user A
(default tablespace a) and imported in a different user B (default
tablespace a), the tables that are imported in the user B is been
storing in  tablespace A. But i want it to be stored in tablespace B
which is the default tablespace of user B.
Now how to solve this problem?


what is the sql statement for moving a table from one tablespace to
another?
Received on Tue Mar 18 2003 - 22:44:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US