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 Tablespace A to Tablespace B

Moving Tables from Tablespace A to Tablespace B

From: Tim Romano <tim_at_ot.com>
Date: 1997/06/06
Message-ID: <01bc7161$32d77a40$94f0eac7@haven>#1/1

Is there an easy way to move a table to another tablespace? Such as:

        MOVE mytable from Tablespace1 to Tablespace2

How can one guarantee that objects get created in a particular tablespace when they're imported? (Setting the DefaultTablespace of the TOUSER does not seem to be 100% effective.)

Could you please cc: me at tim_at_ot.com if you respond to the list. Thank you.
Tim Received on Fri Jun 06 1997 - 00:00:00 CDT

Original text of this message

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