Re: EXP and Tablespaces

Yes, several methods:
1 pre-create the affected objects in a different tablespace. This can be done easily by extracting the create commands from the export file (use imp show=y log=<file> or imp indexfile=<file>) 2 revoke the resource role from the owner, grant quota on the new tablespace only, make sure that is the default tablespace for the owner.

Hth,

Sybrand Bakker, Oracle DBA

stevie <sluetge_at_siliconplanet.de> wrote in message news:GeuSjUJl$GA.398_at_fnews1.vi-internet.de...
> Is there any way I can tell the IMP procedure NOT to use the original (the
> ones that where in use at EXPORT-Time) tablespaces for tables when
importing
> ? What happens when a certain tablespace does not exist ?
> Thanks for any advice
> Stefan
>
>
>
> --
> Mit freundlichen Grüßen
>
> Stefan Lütge
> ----------------------------------------------------------
> Geschäftsführer
> Silicon Planet GmbH
> Behringstr. 28a
> 22765 Hamburg
> www.siliconplanet.de
>
>
>
Received on Thu Mar 23 2000 - 08:33:51 CET