FW: Importing dump in different tablespace

Dear Syed,

Thanks a lot it worked very well.

Best Regards
Vijay Mishra

-----Original Message-----
From: Syed Jaffar Hussain [mailto:sjaffarhussain_at_gmail.com] Sent: 19 June 2006 16:32
To: v.mishra_at_qualityg.com
Subject: Re: Importing dump in different tablespace

Vijay,

You can use fromuser and touser parameters to import from one user to another user.
As far as default tablespace, do the following in case there is no similar tablespace exists in target database.

1. Remove unlimited tablespace permission from the user where you are importing.
2. Give the user any unlimited tablespace on any tablespace.
3. Use ignore = y parameter.

Example:

 revoke unlimited tablespace from user1; alter user USER1 quota unlimited on tablespace;

imp file=filename.dmp log=name.log fromuser=user2 touser=user1 ignore=y

Jaffar

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

-- 
Best Regards,
Syed Jaffar Hussain
8i,9i & 10g, OCP DBA
Banque Saudi Fransi,
Saudi Arabia
http://jaffardba.blogspot.com/
----------------------------------------------------------------------------
------
"Winners don't do different things. They do things differently."

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