OraFAQ Forum: Server Utilities » Exp/Imp - Move objects between tablespaces

Home » RDBMS Server » Server Utilities » Exp/Imp - Move objects between tablespaces (Oracle Database 10g RHEL5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Exp/Imp - Move objects between tablespaces [message #357235]

Tue, 04 November 2008 06:51

marcossantos
Messages: 123
Registered: June 2008

Senior Member

Hi,
I have one schema and I need move all
objects this schema for a new schema
in the same Server.
I try:
$exp user1/user1 file=/file.dmp

and

$imp user2/user2 file=/file.dmp

The all objects was in the same tablespace.
The all objects was in tablespace of user1.

How can I resolve this?

Marcos Santos

Report message to a moderator

Re: Exp/Imp - Move objects between tablespaces [message #357251 is a reply to message #357235]

Tue, 04 November 2008 07:53

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Don't give quota on user1 tablespace to user2 then all objects will go to user2 default tablespace.
Or precreate the objects in the correct tablespace and fill thme with "imp ignore=y".

Regards
Michel

Report message to a moderator

Re: Exp/Imp - Move objects between tablespaces [message #357262 is a reply to message #357235]

Tue, 04 November 2008 08:45

marcossantos
Messages: 123
Registered: June 2008

Senior Member

Hi,
the user2 dont have quota in tablespace
of user1. But, the user2 had DBA privilege.
Can I import without DBA privilege?
Can I use FULL=Y in this case?
Thanks,

Marcos Santos

Report message to a moderator

Re: Exp/Imp - Move objects between tablespaces [message #357269 is a reply to message #357262]

Tue, 04 November 2008 09:15

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

DBA implies quota unlimited on ALL tablespaces.

Quote:

Can I import without DBA privilege?

Not in this case.

Regards
Michel

Report message to a moderator

Previous Topic:	export a database which has no entry in tnsnames.ora
Next Topic:	Log Miner

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 00:42:35 CDT 2024