Home » RDBMS Server » Server Utilities » Do we need to have a DBA privilege inorder to use IMP/EXP
Do we need to have a DBA privilege inorder to use IMP/EXP [message #250174] Mon, 09 July 2007 00:42 Go to next message
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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?
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 Go to previous messageGo to next message
donind
Messages: 95
Registered: February 2007
Member
Hi,

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

Thanks
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 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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?
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
IMP help=yes
EXP help-yes
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 Go to previous messageGo to next message
donind
Messages: 95
Registered: February 2007
Member
Hi,

What abt the privilege?

Do we need have any privilege for imp data.

Thanks
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Do we need to have a DBA privilege inorder to use IMP/EXP [message #250242 is a reply to message #250174] Mon, 09 July 2007 04:54 Go to previous messageGo to next message
lijingwei9060
Messages: 1
Registered: July 2007
Junior Member
the role of the exportor
and the role of the importor

[Updated on: Mon, 09 July 2007 04:59]

Report message to a moderator

Re: Do we need to have a DBA privilege inorder to use IMP/EXP [message #250282 is a reply to message #250174] Mon, 09 July 2007 08:08 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
What don't you understand about posting the log ?

Until you do, good luck.
Re: Do we need to have a DBA privilege inorder to use IMP/EXP [message #250312 is a reply to message #250242] Mon, 09 July 2007 10:56 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
lijingwei9060 wrote on Mon, 09 July 2007 03:54
the role of the exportor
and the role of the importor




http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm
Previous Topic: About Tablespce not found
Next Topic: Unique Index
Goto Forum:
  


Current Time: Fri Dec 09 23:29:05 CST 2016

Total time taken to generate the page: 0.04617 seconds