Home » RDBMS Server » Server Utilities » Import with OS-User (Oracle10g / AIX)
Import with OS-User [message #523635] Mon, 19 September 2011 10:14 Go to next message
Karlia
Messages: 40
Registered: May 2011
Location: Algiers
Member
Hi everybody,

I want to know if it is possible, to run IMP program without connecting with database user , for example :

imp \'/ as sysdba\' file=f.dmp fromuer=u1 touser=u2 log=flog.log

that permits to perform scripts without passwords in.

i hope my questio clear.

Thanks to every body.
Re: Import with OS-User [message #523637 is a reply to message #523635] Mon, 19 September 2011 10:17 Go to previous messageGo to next message
BlackSwan
Messages: 26626
Registered: January 2009
Location: SoCal
Senior Member
>I want to know if it is possible, to run IMP program without connecting with database user , for example :
>imp \'/ as sysdba\' file=f.dmp fromuer=u1 touser=u2 log=flog.log
>that permits to perform scripts without passwords in.
yes, if script runs on DB Server system itself
Re: Import with OS-User [message #523640 is a reply to message #523635] Mon, 19 September 2011 10:29 Go to previous messageGo to next message
Michel Cadot
Messages: 66692
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And instead of using "/ as sysdba", create a OS identified account with DBA role.

Regards
Michel
Re: Import with OS-User [message #523791 is a reply to message #523635] Tue, 20 September 2011 07:48 Go to previous messageGo to next message
Karlia
Messages: 40
Registered: May 2011
Location: Algiers
Member
Thanks guys,

BlackSwan said
yes, if script runs on DB Server system itself 

I tried it but it didn't work
What is wrong in my syntax ?
imp \'/ as sysdba\' file=f.dmp fromuer=u1 touser=u2 log=flog.log


Michel Cadot said
And instead of using "/ as sysdba", create a OS identified account with DBA role.


that's precisely what i want to avoid !

i don't want my script contains any identifiying string.


Re: Import with OS-User [message #523811 is a reply to message #523791] Tue, 20 September 2011 08:08 Go to previous messageGo to next message
cookiemonster
Messages: 13726
Registered: September 2008
Location: Rainy Manchester
Senior Member
I don't think you understood Michel's reply. If you use OS authentication you don't need an indetifying string.
Re: Import with OS-User [message #523813 is a reply to message #523811] Tue, 20 September 2011 08:09 Go to previous messageGo to next message
cookiemonster
Messages: 13726
Registered: September 2008
Location: Rainy Manchester
Senior Member
As for what you are running - giving us the error message would help.
Re: Import with OS-User [message #523841 is a reply to message #523635] Tue, 20 September 2011 09:59 Go to previous messageGo to next message
Karlia
Messages: 40
Registered: May 2011
Location: Algiers
Member
My syntax is correct and it works perfectly well

imp \'/ as sysdba\' file=f.dmp fromuer=u1 touser=u2 log=flog.log


I should have been mistaken when i was typing my code.

Sorry COOKIEMONSTER, I lost the error message.

Thanks to every one,
Re: Import with OS-User [message #523843 is a reply to message #523841] Tue, 20 September 2011 10:24 Go to previous messageGo to next message
Michel Cadot
Messages: 66692
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Mon, 19 September 2011 17:29
And instead of using "/ as sysdba", create a OS identified account with DBA role.



Quote:
it works perfectly well

No, it seems to work and you may have some problems you will not understand.

- 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

[Updated on: Tue, 20 September 2011 10:25]

Report message to a moderator

Re: Import with OS-User [message #523847 is a reply to message #523635] Tue, 20 September 2011 11:02 Go to previous message
Karlia
Messages: 40
Registered: May 2011
Location: Algiers
Member
What a precious advice ! Michel Cadot

Now, I understand your earlier reply !

Thanks again.
Previous Topic: transport tablespace
Next Topic: SQL Loader loads only 1 record
Goto Forum:
  


Current Time: Wed Nov 20 09:24:08 CST 2019