Home » RDBMS Server » Server Utilities » username/password in exp/imp (AIX, Oracle 10.2.0.3)
username/password in exp/imp [message #504578] Tue, 26 April 2011 12:07 Go to next message
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?
Re: username/password in exp/imp [message #504581 is a reply to message #504578] Tue, 26 April 2011 12:10 Go to previous messageGo to next message
BlackSwan
Messages: 21942
Registered: January 2009
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
Re: username/password in exp/imp [message #504587 is a reply to message #504581] Tue, 26 April 2011 12:16 Go to previous messageGo to next message
Michel Cadot
Messages: 57611
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SYSTEM should be avoid a well.

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

Regards
Michel
Re: username/password in exp/imp [message #504591 is a reply to message #504587] Tue, 26 April 2011 12:28 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
How to find out how much time an export job has taken?
Re: username/password in exp/imp [message #504593 is a reply to message #504591] Tue, 26 April 2011 12:31 Go to previous messageGo to next message
joy_division
Messages: 4454
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?
Re: username/password in exp/imp [message #504594 is a reply to message #504593] Tue, 26 April 2011 12:34 Go to previous messageGo to next message
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?
Re: username/password in exp/imp [message #504595 is a reply to message #504593] Tue, 26 April 2011 12:34 Go to previous messageGo to next message
BlackSwan
Messages: 21942
Registered: January 2009
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.
Re: username/password in exp/imp [message #504597 is a reply to message #504591] Tue, 26 April 2011 12:42 Go to previous messageGo to next message
Michel Cadot
Messages: 57611
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: username/password in exp/imp [message #504598 is a reply to message #504597] Tue, 26 April 2011 12:47 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
I could see the time in the nohup.out file too.
Re: username/password in exp/imp [message #504601 is a reply to message #504598] Tue, 26 April 2011 12:54 Go to previous message
BlackSwan
Messages: 21942
Registered: January 2009
Senior Member
I prefer screen to nohup.
Previous Topic: pre-create tables
Next Topic: export stopped
Goto Forum:
  


Current Time: Fri Apr 18 16:03:29 CDT 2014

Total time taken to generate the page: 0.52847 seconds