Home » RDBMS Server » Server Utilities » Doubt in using export and import (Oracle 11.2.0.3.0, Linux 5)
Doubt in using export and import [message #577014] Mon, 11 February 2013 16:24 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

I have one doubt in using export and import command.

Can we use SYS or SYSTEM user to take export and import like ( schema export,full db export,
table export etc.. ) if DB users does not have privilege to take export and import.Could you please clarify ?

If we cannot use SYS or SYSTEM user to take export and import , could you give me the reason why we cannot
use sys or system user to take export and import ?

Regards,
Jack

[Updated on: Mon, 11 February 2013 16:28]

Report message to a moderator

Re: Doubt in using export and import [message #577015 is a reply to message #577014] Mon, 11 February 2013 17:03 Go to previous messageGo to next message
BlackSwan
Messages: 22718
Registered: January 2009
Senior Member
The DB SYS user should only be used to apply Oracle patches & version upgrades

with Oracle everything is forbidden; except that which has been explicitly granted, so you may need to issue GRANT as required

when all else fails Read The Fine Manual

http://docs.oracle.com/cd/E11882_01/server.112/e10575/toc.htm
Re: Doubt in using export and import [message #577116 is a reply to message #577014] Tue, 12 February 2013 08:48 Go to previous messageGo to next message
gazzag
Messages: 298
Registered: November 2010
Location: Bristol, UK
Senior Member

You can use the SYSTEM user to export other users' schemas.

HTH
-g

[Updated on: Tue, 12 February 2013 10:01] by Moderator

Report message to a moderator

Re: Doubt in using export and import [message #577217 is a reply to message #577116] Wed, 13 February 2013 08:50 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Gazzag & Swan,

Thank you for the answers.

I have few questions to clarify.

1.May i know why we cannot use SYS user to export other user's schemas ?
2.What would be the impact to database if we use SYS user to export other user's schemas?

Regards,
Jack
Re: Doubt in using export and import [message #577219 is a reply to message #577217] Wed, 13 February 2013 09:00 Go to previous messageGo to next message
BlackSwan
Messages: 22718
Registered: January 2009
Senior Member
http://docs.oracle.com/cd/E11882_01/server.112/e25494/dba005.htm#ADMIN11042

"Create at least one additional administrative user and grant to that user an appropriate administrative role to use when performing daily administrative tasks. Do not use SYS and SYSTEM for these purposes."
Re: Doubt in using export and import [message #577224 is a reply to message #577219] Wed, 13 February 2013 09:34 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Swan,

I understand SYS and SYSTEM users cannot be used for these purposes. But i want to know the reason
as why we cannot use these users for such purpose

Regards,
Jack
Re: Doubt in using export and import [message #577227 is a reply to message #577224] Wed, 13 February 2013 09:59 Go to previous messageGo to next message
Michel Cadot
Messages: 58937
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
They are Oracle proprietary, use your own accounts.

In addition, as I often say:

Quote:
- Never ever use SYS (or SYSDBA) but for maintenance purpose (startup, shutdown, backup, recover)
- SYS/SYSDBA is special
- SYS/SYSDBA is Oracle proprietary (try to open a SR/TAR starting with "i did that with SYS/SYSDBA" and you'll see the immediate answer)
- SYS/SYSDBA does not act like any other user
- When you use SYS/SYSDBA Oracle deactivates some code path and activates others
- Whatever you do with SYS/SYSDBA will neither validate nor invalidate the same thing with any other user.

NEVER EVER use SYS/SYSDBA for anything that can be done by another user.
Use SYS/SYSDBA ONLY for something that can't be done by someone else.


Regards
Michel
Re: Doubt in using export and import [message #578740 is a reply to message #577227] Mon, 04 March 2013 09:11 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Thank you all for your answers

[Updated on: Mon, 04 March 2013 23:28]

Report message to a moderator

Previous Topic: EXP-00041: INCTYPE parameter is obsolete
Next Topic: Import million data from excel to Oracle 11g
Goto Forum:
  


Current Time: Fri Aug 29 11:21:29 CDT 2014

Total time taken to generate the page: 0.06281 seconds