| oracle environment setting [message #557616] |
Thu, 14 June 2012 05:06  |
 |
guddu_12
Messages: 227
Registered: April 2012
Location: UK
|
Senior Member |
|
|
Hello gurus,
In my unix box there is a oracle 10g installed, now for the new requirment on the sme box oracle 11gr2 has been installed. i have a same table in both the database , when i run the sql loader in loads into 10g database rather that 11g.
could you please help me to provide the setting so that it would load onto the correct data base. user is also same in both the database.
Please help
|
|
|
|
|
|
| Re: oracle environment setting [message #558154 is a reply to message #557616] |
Tue, 19 June 2012 15:48  |
 |
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
|
Senior Member |
|
|
This will set your oracle environment, but make sure an entry for your 11g database
exists in the /etc/oratab file (or /var/opt/oracle/oratab for Solaris).
Add it at the top of your script:
ORAENV_ASK=NO
. /usr/local/bin/oraenv ORCL11 #<== Here you put the ORACLE_SID of the 11g database
#
# Environment is set, so continue with your commands here....
[Updated on: Tue, 19 June 2012 23:22] by Moderator Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
