FW: Importing dump in different tablespace
- From: "Vijay Mishra" <v.mishra@xxxxxxxxxxxx>
- To: "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 20 Jun 2006 10:58:05 +0300
Dear Syed,
Thanks a lot it worked very well.
Best Regards
Vijay Mishra
-----Original Message-----
From: Syed Jaffar Hussain [mailto:sjaffarhussain@xxxxxxxxx]
Sent: 19 June 2006 16:32
To: v.mishra@xxxxxxxxxxxx
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@xxxxxxxxxxxx> 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."
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » FW: Importing dump in different tablespace
