OraFAQ Forum: Server Utilities » Import with OS-User

Home » RDBMS Server » Server Utilities » Import with OS-User (Oracle10g / AIX)

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

Import with OS-User [message #523635]

Mon, 19 September 2011 10:14

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.

Report message to a moderator

Re: Import with OS-User [message #523637 is a reply to message #523635]

Mon, 19 September 2011 10:17

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Import with OS-User [message #523640 is a reply to message #523635]

Mon, 19 September 2011 10:29

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

Senior Member
Account Moderator

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

Regards
Michel

Report message to a moderator

Re: Import with OS-User [message #523791 is a reply to message #523635]

Tue, 20 September 2011 07:48

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.

Report message to a moderator

Re: Import with OS-User [message #523811 is a reply to message #523791]

Tue, 20 September 2011 08:08

cookiemonster
Messages: 13962
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.

Report message to a moderator

Re: Import with OS-User [message #523813 is a reply to message #523811]

Tue, 20 September 2011 08:09

cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester

Senior Member

As for what you are running - giving us the error message would help.

Report message to a moderator

Re: Import with OS-User [message #523841 is a reply to message #523635]

Tue, 20 September 2011 09:59

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,

Report message to a moderator

Re: Import with OS-User [message #523843 is a reply to message #523841]

Tue, 20 September 2011 10:24

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

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

Karlia
Messages: 40
Registered: May 2011
Location: Algiers

Member

What a precious advice ! Michel Cadot

Now, I understand your earlier reply !

Thanks again.

Report message to a moderator

Previous Topic:	transport tablespace
Next Topic:	SQL Loader loads only 1 record

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 13:35:43 CST 2025