Home » RDBMS Server » Server Utilities » Exp/Imp - Move objects between tablespaces (Oracle Database 10g RHEL5)
Exp/Imp - Move objects between tablespaces [message #357235] Tue, 04 November 2008 06:51 Go to next message
marcossantos
Messages: 114
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
Re: Exp/Imp - Move objects between tablespaces [message #357251 is a reply to message #357235] Tue, 04 November 2008 07:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
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
Re: Exp/Imp - Move objects between tablespaces [message #357262 is a reply to message #357235] Tue, 04 November 2008 08:45 Go to previous messageGo to next message
marcossantos
Messages: 114
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
Re: Exp/Imp - Move objects between tablespaces [message #357269 is a reply to message #357262] Tue, 04 November 2008 09:15 Go to previous message
Michel Cadot
Messages: 64119
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
Previous Topic: export a database which has no entry in tnsnames.ora
Next Topic: Log Miner
Goto Forum:
  


Current Time: Tue Dec 06 06:32:42 CST 2016

Total time taken to generate the page: 0.24160 seconds