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 -> Changing tablespaces on IMP?

Changing tablespaces on IMP?

From: dean <deanbrown3d_at_yahoo.com>
Date: 27 Feb 2007 10:38:33 -0800
Message-ID: <1172601513.740939.58690@q2g2000cwa.googlegroups.com>


Is it possible to change the tablespaces of the tables during an import, from their original ones? Right now when we import a schema from our clients, to bring the data down to out test servers, we have to watch the error messages from the tablespace not existing, create the tablespaces, and then try again.

Oracle 9.2i, 10g v 1 and 2. Windows, Sun, Linux.

Thanks

Dean Received on Tue Feb 27 2007 - 12:38:33 CST

Original text of this message

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