OraFAQ Forum: Server Utilities » Importing from dmp file problem

Home » RDBMS Server » Server Utilities » Importing from dmp file problem

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

Importing from dmp file problem [message #233925]

Sat, 28 April 2007 04:46

fage79
Messages: 4
Registered: April 2007
Location: bangalore

Junior Member

Hi

i am facing a problem while importing form dmp file in oracle 10g on linux. we are having some user cerated objects(tables and indexes ) in system tablespace.I wanna move them in a diff tablespace.So i exported user's schema objects thrugh exp utility.And then cerated a new user with default tablespace as users tablespace along with quota unlimited.while importing from dmp file created with exp utitlity in this new user again objects are created in system tablespace instead of this new users's default tablespace..

How to solve this problem? thanks in advance

Report message to a moderator

Re: Importing from dmp file problem [message #233935 is a reply to message #233925]

Sat, 28 April 2007 06:11

hvvaghani
Messages: 7
Registered: August 2006
Location: Surat,(guj),India

Junior Member

hi,

do like this,

Export from user1

Now create new user2 whith different ID from Erliyer user.Give its default and new table space names..

now delet old user..

in the Imp commad give your system login and user fromuser -touser
Options

Report message to a moderator

Re: Importing from dmp file problem [message #233956 is a reply to message #233925]

Sat, 28 April 2007 07:45

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ Remove unlimited tablespace or role containing them (dba, resource) from these users.

2/ Don't use export/import, use "alter table move" and/or "alter index rebuild tablespace".

Regards
Michel

Report message to a moderator

Re: Importing from dmp file problem [message #235347 is a reply to message #233956]

Sat, 05 May 2007 03:59

fage79
Messages: 4
Registered: April 2007
Location: bangalore

Junior Member

thanx alot Michel its working fine

Report message to a moderator

Previous Topic:	how to load data from Ms Access to oracle
Next Topic:	ORA-1882 on Import Oracle 9.2.0.6

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 11:53:17 CST 2024