OraFAQ Forum: Server Utilities » username/password in exp/imp

Home » RDBMS Server » Server Utilities » username/password in exp/imp (AIX, Oracle 10.2.0.3)

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

username/password in exp/imp [message #504578]

Tue, 26 April 2011 12:07

lg123
Messages: 225
Registered: August 2008

Senior Member

While doing export/import we specify the username and password. Preferably which user do we need to specify? Sys or system or our own user?

Report message to a moderator

Re: username/password in exp/imp [message #504581 is a reply to message #504578]

Tue, 26 April 2011 12:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>While doing export/import we specify the username and password. Preferably which user do we need to specify? Sys or system or our own user?
it depends upon who is doing what.

SYS user should be avoided except when installing or upgrading Oracle version

Report message to a moderator

Re: username/password in exp/imp [message #504587 is a reply to message #504581]

Tue, 26 April 2011 12:16

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

Senior Member
Account Moderator

SYSTEM should be avoid a well.

Use your own account(s), let Oracle ones to Oracle.

Regards
Michel

Report message to a moderator

Re: username/password in exp/imp [message #504591 is a reply to message #504587]

Tue, 26 April 2011 12:28

lg123
Messages: 225
Registered: August 2008

Senior Member

How to find out how much time an export job has taken?

Report message to a moderator

Re: username/password in exp/imp [message #504593 is a reply to message #504591]

Tue, 26 April 2011 12:31

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

lg123 wrote on Tue, 26 April 2011 13:28

How to find out how much time an export job has taken?

Look at your watch when you start it, look at your watch when it ends. Subtract starting time from ending time.

Is that the questions you really wanted to ask?

Report message to a moderator

Re: username/password in exp/imp [message #504594 is a reply to message #504593]

Tue, 26 April 2011 12:34

lg123
Messages: 225
Registered: August 2008

Senior Member

I want to know how to see the duration in the database itself or in the OS level. Is there a way?

Report message to a moderator

Re: username/password in exp/imp [message #504595 is a reply to message #504593]

Tue, 26 April 2011 12:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How to find out how much time an export job has taken?
start & stop times are in LOG file; assuming you requested one be made.

Report message to a moderator

Re: username/password in exp/imp [message #504597 is a reply to message #504591]

Tue, 26 April 2011 12:42

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

Senior Member
Account Moderator

lg123 wrote on Tue, 26 April 2011 19:28

How to find out how much time an export job has taken?

time exp ...

See "man time"

Regards
Michel

Report message to a moderator

Re: username/password in exp/imp [message #504598 is a reply to message #504597]

Tue, 26 April 2011 12:47

lg123
Messages: 225
Registered: August 2008

Senior Member

I could see the time in the nohup.out file too.

Report message to a moderator

Re: username/password in exp/imp [message #504601 is a reply to message #504598]

Tue, 26 April 2011 12:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I prefer screen to nohup.

Report message to a moderator

Re: username/password in exp/imp [message #617730 is a reply to message #504587]

Thu, 03 July 2014 01:59

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Hi Michel/Blackswan,

Quote:

SYS user should be avoided except when installing or upgrading Oracle version
SYSTEM should be avoid a well.

Use your own account(s),

Why is that sys and system user should not be used to take export and import ? Can you explain ?

Regards,

[Updated on: Thu, 03 July 2014 01:59]

Report message to a moderator

Re: username/password in exp/imp [message #617737 is a reply to message #617730]

Thu, 03 July 2014 04:32

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Because SYS is special and not for regular use.

Edit : Provided the link, which has a complete explanation.

[Updated on: Thu, 03 July 2014 04:33]

Report message to a moderator

Re: username/password in exp/imp [message #617738 is a reply to message #617737]

Thu, 03 July 2014 04:45

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Lalit,

But i have used sys and system user for export and import and have not faced any issue so far.

Report message to a moderator

Re: username/password in exp/imp [message #617740 is a reply to message #617738]

Thu, 03 July 2014 04:49

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

Senior Member
Account Moderator

You THINK you didn't face any issue and, even so, this does not mean you will not face any issue and then it will be your fault and you couldn't blame Oracle and your boss will be allowed to fire you.

Report message to a moderator

Re: username/password in exp/imp [message #617741 is a reply to message #617740]

Thu, 03 July 2014 04:57

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

ofcourse i did not face any issue till now.If so , what kind of issues i will face if i use sys and system for export and import ?
Can you list some of them ?

[Updated on: Thu, 03 July 2014 05:02]

Report message to a moderator