OraFAQ Forum: Server Utilities » Doubt in using export and import

Home » RDBMS Server » Server Utilities » Doubt in using export and import (Oracle 11.2.0.3.0, Linux 5)

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

Doubt in using export and import [message #577014]

Mon, 11 February 2013 16:24

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

Re: Doubt in using export and import [message #577116 is a reply to message #577014]

Tue, 12 February 2013 08:48

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, 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

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

Report message to a moderator

Re: Doubt in using export and import [message #577219 is a reply to message #577217]

Wed, 13 February 2013 09:00

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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."

Report message to a moderator

Re: Doubt in using export and import [message #577224 is a reply to message #577219]

Wed, 13 February 2013 09:34

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

Report message to a moderator

Re: Doubt in using export and import [message #577227 is a reply to message #577224]

Wed, 13 February 2013 09:59

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

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

Report message to a moderator

Re: Doubt in using export and import [message #578740 is a reply to message #577227]

Mon, 04 March 2013 09:11

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 15:56:39 CST 2025