OraFAQ Forum: Backup & Recovery » Does imp need create a user before?

Home » RDBMS Server » Backup & Recovery » Does imp need create a user before?

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

Does imp need create a user before? [message #138296]

Wed, 21 September 2005 03:58

rushing
Messages: 135
Registered: January 2004
Location: Beijing,China

Senior Member

There is a .dmp file.
I want to import it into my Oracle.
Should I create a user for it?
Thanks!

Report message to a moderator

Re: Does imp need create a user before? [message #138306 is a reply to message #138296]

Wed, 21 September 2005 04:38

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

Depends... Did you export an entire schema or even db? If yes then you don't have to create a user as import will create the user for you. However if you just exported a few objects then the create user command is not created, so you will have to import to an existing user.

HTH
JIm

Report message to a moderator

Re: Does imp need create a user before? [message #139613 is a reply to message #138296]

Wed, 28 September 2005 16:01

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

I would recommend existence of a user ..
you can then take care of its default tablespace , extent management, its sizing etc ...

-Sai Jeedigunta

Report message to a moderator

Previous Topic:	IMP-00016 required character set conversion (type 3 to 1) not supported
Next Topic:	Recover is failing w/ system SCN diff from Control File

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 07:40:45 CDT 2024