sqlldr / as sysdba

From: barry <bbulsara23_at_hotmail.com>
Date: 20 Apr 2005 12:11:01 -0700
Message-ID: <747f1dec.0504201111.4d4e2dd2@posting.google.com>

Hi, bit of a mind block :(

Why am I seeing prod3 as the database name when ORACLE_SID=prod3 or prod4 ?

Thank you in advance
Barry

(oracle_at_svr12UK)$
(oracle_at_svr12UK)$ set ORACLE_SID=prod3
(oracle_at_svr12UK)$ sqlplus / AS SYSDBA

SQL*Plus: Release 10.1.0.3.0 - Production on Wed Apr 20 17:20:42 2005

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production With the Partitioning and Data Mining options

SQL> SELECT NAME FROM V$DATABASE; NAME

---

prod3

SQL> QUIT
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit ProductionWith the Partitioning and Data Mining options
(oracle_at_svr12UK)$ set ORACLE_SID=prod4
(oracle_at_svr12UK)$ sqlplus / AS SYSDBA

SQL*Plus: Release 10.1.0.3.0 - Production on Wed Apr 20 17:21:08 2005

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production With the Partitioning and Data Mining options

SQL> SELECT NAME FROM V$DATABASE; NAME

---

prod3

SQL> SELECT * FROM V$VERSION; BANNER

---

Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bi PL/SQL Release 10.1.0.3.0 - Production
CORE 10.1.0.3.0 Production
TNS for Solaris: Version 10.1.0.3.0 - Production NLSRTL Version 10.1.0.3.0 - Production

SQL> QUIT
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit ProductionWith the Partitioning and Data Mining options
(oracle_at_svr12UK)$
(oracle_at_svr12UK)$
Received on Wed Apr 20 2005 - 14:11:01 CDT