OraFAQ Forum: Server Utilities » Do we need to have a DBA privilege inorder to use IMP/EXP

Home » RDBMS Server » Server Utilities » Do we need to have a DBA privilege inorder to use IMP/EXP

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

Do we need to have a DBA privilege inorder to use IMP/EXP [message #250174]

Mon, 09 July 2007 00:42

donind
Messages: 95
Registered: February 2007

Member

Hi,

Do we need to have a DBA privilege inorder to use IMP/EXP.
what are the various options available with IMP/EXP.

Any help with example really appreciated.

Thanks in advance

Report message to a moderator

Re: Do we need to have a DBA privilege inorder to use IMP/EXP [message #250177 is a reply to message #250174]

Mon, 09 July 2007 00:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Do we need to have a DBA privilege inorder to use IMP/EXP.
NO, but you need to be smarter than the equipment you are using.
ARE YOU?

Report message to a moderator

Re: Do we need to have a DBA privilege inorder to use IMP/EXP [message #250183 is a reply to message #250177]

Mon, 09 July 2007 00:51

donind
Messages: 95
Registered: February 2007

Member

Hi,

Equipment in the sense. Can you make it little bit easier.

Thanks

Report message to a moderator

Re: Do we need to have a DBA privilege inorder to use IMP/EXP [message #250184 is a reply to message #250174]

Mon, 09 July 2007 00:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Equipment in the sense. Can you make it little bit easier.
What problem are you really tring t solve?

Report message to a moderator

Re: Do we need to have a DBA privilege inorder to use IMP/EXP [message #250185 is a reply to message #250184]

Mon, 09 July 2007 00:57

donind
Messages: 95
Registered: February 2007

Member

Hi,

I am tring to import the dmp file.

This is the command I am using

IMP userid=abc/abc file=c:\1.dmp full-Y

Its giving an error you dont have dba privilege.

A part from the above options is there any other options for importing a data.

Thanks in advance

Report message to a moderator

Re: Do we need to have a DBA privilege inorder to use IMP/EXP [message #250186 is a reply to message #250174]

Mon, 09 July 2007 00:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

IMP help=yes
EXP help-yes

Report message to a moderator

Re: Do we need to have a DBA privilege inorder to use IMP/EXP [message #250188 is a reply to message #250186]

Mon, 09 July 2007 01:09

donind
Messages: 95
Registered: February 2007

Member

Hi,

What abt the privilege?

Do we need have any privilege for imp data.

Thanks

Report message to a moderator

Re: Do we need to have a DBA privilege inorder to use IMP/EXP [message #250194 is a reply to message #250188]

Mon, 09 July 2007 01:35

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

Senior Member
Account Moderator

Instead of SAYING what error you have, COPY & PASTE the log then we can exactly see what happened and not your interpretation of what happened.

An export done by a DBA can only be imported by a DBA.

Regards
Michel

Report message to a moderator