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é :
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
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
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
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
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
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
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
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
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
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
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
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
--
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]
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
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
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
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
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:
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
20 matches
Mail list logo