Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Changing tablespaces on IMP?
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