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

Home -> Community -> Usenet -> c.d.o.server -> Re: Moving tables between tablespaces???

Re: Moving tables between tablespaces???

From: Mario Bucsics <mario.bucsicsNOmaSPAM_at_siemens.at.invalid>
Date: 2000/03/17
Message-ID: <288c1866.e3a28f5b@usw-ex0102-014.remarq.com>#1/1

Hi !

  1. export the table
  2. drop the table
  3. create the table in the tablespace where you want
  4. set the ignore parameter to "y" at the imp command line

 Good Luck !

 Mario Bucsics

Received on Fri Mar 17 2000 - 00:00:00 CST

Original text of this message

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