RE: sql help

Try this simple script set pagesize 66 linesize 132 verify off select tablespace_name Tablespace ,segment_type Object_type ,segment_name Object from user_extents order by tablespace_name,segment_type; -Message d'origine- De : kommareddy sreenivasa [mailto:[EMAIL PROTECTED]] Envoyé :

version

Hi All, How can we find what version of oracle (standard/enterprise/workgroup) is running in the system. Is there any view/table ? Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services

RE: MTS - in Linux

See Note: 107341.1 Load Indicator Messages in alert log for more details. HTH, -- Anita --- Libal, Ivo [EMAIL PROTECTED] wrote: There are some known bugs related to MTS and 8.1.6 with this LOAD INDICATOR NOT SUPPORTED BY OS. I am having similar problem on my linux with 2 IP addresses and

Re: export/import object types

Richard, This is an issue with TYPE objects as the TOID (type object ID) is exported (see the Utilities manual). Also see Note: 1066139.6 IMP-17 IMP-3 ORA-2304 IMP-63 FROMUSER/TOUSER Import of Table With Object Column HTH, -- Anita --- Richard Ji [EMAIL PROTECTED] wrote: Hi all, I wonder

Re: Snapshot shows as INVALID in DBA_OBJECTs

Dave, As someone else pointed out, this is a known bug (1188948). The issue is not with the dd, but that the view for DBA_OBJECTS did not get updated to handle the new object type value for materialized views. If you check the view definition (should be in catalog.sql) you'll see a decode

RE: Oracle listener security patch -

Angel, This error can occur with an incorrect setting for COMPATIBLE in the init.ora. What is it set to on your prod db? HTH, -- Anita --- Angel Munte Salvador [EMAIL PROTECTED] wrote: Hi, curiously, I've begun to have problems with alter session statements after applying this patch

Re: version

login as sqlplus(without -s option) and see banner...will tell you exactly what you want MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Sun, 22 Jul 2001 08:16:55 -0800 Hi All, How can we find what version of oracle

Re: some thing strange with user_tables vs real table

Rama, This is an issue with any object that is created via an ODBC connection as ODBC encloses the names in double quotes. Unless the application specifically converts them to uppercase before issuing the DDL, they'll be created with mixed case. This is most commonly seen when converting

Re: version

Easy. Log in to sqlplus or svrmgrl and run the following query: select * from v$version; The first line will tell you what version of Oracle you are running. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, July 22, 2001 12:16

RE: MTS - in Linux

I can't get the MTS parameters to enable MTS, as reported by the V$SESSION view... If anyone want to take a look @ my pfile, that would be cool. (please show me yours if I show you mine) - jeremy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL

Re: MTS - in Linux

you dont happen to have server=dedicated in the tnsnames.ora file? joe [EMAIL PROTECTED] wrote: I can't get the MTS parameters to enable MTS, as reported by the V$SESSION view... If anyone want to take a look @ my pfile, that would be cool. (please show me yours if I show you

SQLJ vrs PLSQL

I have a friend who states SQLJ is faster PLSQL, so I started reading up on SQLJ, which I have always avoided as it didn't seem to impressive and I try to avoid any sql in java files. In reading, I noticed it calls a SQLJ runtime which is java. I can't believe this would outperform native PLSQL

backup Oracle on Sun Cluster 2.2 ???

Hi all, I want to perform Oracle cold backup, Since I am using Sun Cluster 2.2, after I stop my cluster, those clustered partitions are not mounted. How can I shutdown my database while my cluster is working (How to shutdown my Oracle with mounted partitions) Best Regards Sinardy --

Re: backup Oracle on Sun Cluster 2.2 ???

For a cold backup, simply shut down all Oracle instances accessing the database to be backed up. There is no need to shut down any Sun or Veritos cluster services. -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

Re: Locally managed tablespaces

If you are using uniform extents in LMT, you don't want to coalesce - ever. Since every extent will be the same size, it is useless overhead. This is even more true if you have adopted a uniform extents policy in any dictionary managed tablespaces. In fact, to reduce the overhead of throwing a

RE: backup Oracle on Sun Cluster 2.2 ???

Hi Don Granaman, If I shutdown Oracle, My cluster daemon will startup it back automatically. Regards, sinardy -Original Message- Granaman Sent: Monday, 23 July 2001 1:00 PM To: Multiple recipients of list ORACLE-L For a cold backup, simply shut down all Oracle instances

RE: sql help

Hi, Try this query :- SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME IN (SELECT SEGMENT_NAME FROM DBA_SEGMENTS); Regards, Anand. -Original Message- sreenivasa Sent: Saturday, July 21, 2001 9:15 PM To: Multiple recipients of list ORACLE-L hi dba's how to find out a users all

Re: backup Oracle on Sun Cluster 2.2 ???

I don't see any problem in stopping Oracle Database and keep the cluster running. Stop the database from svrmgr prompt on all nodes using just shutdown normal/immediate and don't execute anything related to cluster. This way u will have access to all shared storage (raw / filesystems) and your

How to find oracle is 32/64 bit

Hi, I want to known whether my oracle database is 32/64bits. Can anybody help me how to find it ? Thanks, Ajay Singh Rathore HCL Infosystems Ltd --- visit us at www.hclinsystems.com -- Please see the official ORACLE-L FAQ:

RE: Connectivity problems through IIS server.

i have done this some time back . you need to setup the ODBC ADMINISTRATOR and make a DSN on the client side or the server side to access the oracle database using ASP. simply using the SQL NET won't work if u'r using ASP. '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' Omar Khalid Software Engineer