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

Re: Changing tablespaces on IMP?

From: Gerard H. Pille <ghp_at_skynet.be>
Date: Tue, 27 Feb 2007 20:01:16 +0100
Message-ID: <45e47def$0$2952$ba620e4c@news.skynet.be>


dean wrote:
> 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
>

The trick used to be to give the schema owners a default tablespace that exists. When import does not find the original tablespace, or the owner has a zero quota on the original tablespace, it should try to create the tables and indexes in the default tablespace of the schema. Received on Tue Feb 27 2007 - 13:01:16 CST

Original text of this message

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