Re: Importing dump in different tablespace

Hi,
you can assign the tablespace that you want as 'default tablespace' of the target schema, then use 'fromuser' 'touser' to imp from the source schema to the target one.

NB: this does not work for partitionned tables. In this case, you have to pre-create the tables, and use ignore=y upon import. You can get the DDL by using the indexfile parameter upon imp, and edit this resulting file.

rgds

On 6/19/06, Vijay Mishra <v.mishra_at_qualityg.com> wrote:
>
> Hi,
>
>
>
> How can an exp dump from Server1 be imported into the Server2 using
> different table space and different users?
>
>
>
>
>
> By default dump is getting imported into the server default tablespace not
> the user default tablespace. Please help I want to import the dump in user
> default tablespace.
>
>
>
>
>
>
>
> BR
>
>
>
> Vijay
>

--
http://www.freelists.org/webpage/oracle-l