try this one. It should definitely give.
select * from product_component_version;
Regds,
Rajni
----- Original Message -----
From: "kumar" <oracledba-ezmlmshield-x29371621.[Email address protected]
To: "LazyDBA.com Discussion" <[Email address protected]
Sent: Wednesday, June 02, 2004 4:44 PM
Subject: RE: Which Oracle is installed on Solaris?
>
> Hi
>
> what is said is not working my side, my side i am using 64 bit, but
> while getting in through SQLPLUS i never receiving message as you said,
> there is no massage related to 64 bit or 32 bit
>
> FYI
>
> SQL*Plus: Release 9.0.1.0.1 - Production on Wed Jun 2 16:46:53 2004
>
> (c) Copyright 2001 Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.1.0 - Production
>
> SQL>
>
>
>
> Thanks & Regards
>
> Kumar .N
> " Nothing in this world is impossible to a willing heart "
>
>
> |---------+-------------------------------------------------------->
> | | "Mudhalvan Moovarkku " |
> | | <oracledba-ezmlmshield-x1721423.[Email Address Removed] | | azyDBA.com> |
> | | |
> | | 06/02/2004 02:44 AM |
> | | |
> |---------+-------------------------------------------------------->
>
>---------------------------------------------------------------------------
--------------------|
> |
|
> | To: "LazyDBA.com Discussion" <[Email address protected]
|
> | cc: (bcc: kumar.n/Polaris)
|
> | Subject: RE: Which Oracle is installed on Solaris?
|
>
>---------------------------------------------------------------------------
--------------------|
>
>
>
>
> Hi Helmar,
>
> Easy method use SQLPLUS to login to Server.
>
> If you got
> Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.3.0 - Production
>
> Then it is 64 Bit if not it is 32Bit
>
> Thank you
> Mudhalvan M.M
> -----Original Message-----
> From: Hellmar Becker [mailto:oracledba-ezmlmshield-x99806497.[Email
address
> protected]
> Sent: Wednesday, June 02, 2004 5:33 PM
> To: LazyDBA.com Discussion
> Subject: Which Oracle is installed on Solaris?
>
>
> Hi All,
>
> I've got Oracle 9i installed on a Solaris server. How do I find out
whether
> the installed version is 32 bit or 64 bit?
>
> Thanks in advance,
>
> Hellmar Becker
> Datanautics GmbH
> Business Consultant
> Glockengasse 1
> 50667 Köln
> Phone +49 221 420756 15
> Fax +49 221 420756 20
> Mobile +49 151 1623 1226
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: send a blank email to oracledba-[Email address protected]
> By using this list you agree to these terms:
> http://www.lazydba.com/legal.html
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: send a blank email to oracledba-[Email address protected]
> By using this list you agree to these terms:
> http://www.lazydba.com/legal.html
>
>
>
>
>
>
> This e-Mail may contain proprietary and confidential information and is
sent for the intended recipient(s) only.
> If by an addressing or transmission error this mail has been misdirected
to you, you are requested to delete this mail immediately.
> You are also hereby notified that any use, any form of reproduction,
dissemination, copying, disclosure, modification,
> distribution and/or publication of this e-mail message, contents or its
attachment other than by its intended recipient/s is strictly prohibited.
>
> Visit Us at http://www.polaris.co.in
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: send a blank email to oracledba-[Email address protected]
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page