Re: parameters at session level

2001-07-22 Thread Christian Trassens 

When you run an alter session to change session
parameter as optimizer_goal or sql_trace and then you
issue a show parameters, it shows you the values at
session level.

Regards.


--- prasad maganti <[EMAIL PROTECTED]> wrote:
> hi dba's
> 
> can anybody clarify me the flwng:
> 
> at database level the parameter
> optimizer_mode=choose.
> and i connected to scott and i set the
> optimizer_goal=
> rule.
> 
> when i see from scott using
> sql>show parameters optimizer 
> the value is shown as RULE
> 
> where as from connect internal 
> SVRMGR>SHOW PARAMETERS OPTIMIZER
> showing  CHOOSE.
> 
> But in the case of SQL_TRACE the system is showing
> the
> only value that is set at database level.
> 
> even if i set sql_trace=false in scott user and i
> issued
> >show parameters sql_trace
> 
> it is showing only TRUE that is set at database
> level.
> 
> why oracle behaves different ways for different
> parameters.
> 
> prasad.
> 
> 
> __
> Do You Yahoo!?
> Make international calls for as low as $.04/minute
> with Yahoo! Messenger
> http://phonecard.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: prasad maganti
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


=
Eng. Christian Trassens
Senior DBA
Systems Engineer
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : 541149816062

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christian Trassens
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Supert market desgn

2001-07-22 Thread Saravana Kumar 



Hi friends,
  I 
would like to know the name of site where i could find any document related 
to designing of database for a
supermarket chain speard across the 
country.
 
Please help me regarding the document.
 
Thank's in advance.
 
Regards
 
Saravana.
 

RE: backup Oracle on Sun Cluster 2.2 ???

2001-07-22 Thread Sinardy 

Hi,

If I shutdown my database, sun cluster will automatically startup it within
a second.

Regrads,
Sinardy

-Original Message-
[EMAIL PROTECTED]
Sent: Monday, 23 July 2001 2:05 PM
To: Multiple recipients of list ORACLE-L



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 database is down for cold backup.
Now, if u are using raw shared device, then the backup cab be taken through
'dd' and if u are using filesystems, then u can use anything u want.

DESHMUKH SAMBHAJI S
"Let's Document it and Call it a Future !"



"Sinardy"
   <[EMAIL PROTECTED]>
Sent by: cc:
root@fatcity.Subject: backup Oracle on Sun
Cluster 2.2 ???
com


07/22/01
09:10 PM
Please
respond to
ORACLE-L





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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinardy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: How to find oracle is 32/64 bit

2001-07-22 Thread Christian Trassens 

Hi,

Query the v$version view. From outside issue a file
$ORACLE_HOME/bin/oracle, usually when it is a 64 bits
release it doesn't appear the number 64. However in a
32 bits, it does:

$ file oracle
oracle: ELF 32-bit MSB executable SPARC
Version 1, dynamically linked, n
ot stripped


Regards.


--- Ajay Singh Rathore <[EMAIL PROTECTED]> wrote:
> 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:
> http://www.orafaq.com
> -- 
> Author: Ajay Singh Rathore
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


=
Eng. Christian Trassens
Senior DBA
Systems Engineer
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : 541149816062

__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christian Trassens
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Connectivity problems through IIS server.

2001-07-22 Thread okhalid 


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
LMK Resources
Voice: 111-101-101*780
Mobile: 0333-510-4465
Web: www.lmkr.com
'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'


   

   

   



   
   
   
   
   
   


   

"shirish"  

   
.com>cc:   

Sent by: Subject: RE: Connectivity problems 
through IIS server.
[EMAIL PROTECTED] 

om 

   

   

07/20/2001 

09:42 PM   

Please respond 

to ORACLE-L

   

   




hi

while connecting to oracle thro' ASP, u need to
specify the TNSname. as far as i know the tnsname
is case sensative(when using with ASP) so plz
check the tnsname entry.
also check the same with dsn entries..

hope this helps ..

thanks and regards !
Shirish Khapre, SE Rolta India Ltd.
Off Ph No. (+91) (022) 832,826,8300568
Ext'n 2730
Minds are like parachutes. They only function when
they are open




-Original Message-
Behalf Of Naik,
Sandesh S
Sent: Thursday, July 19, 2001 8:10 PM
To: Multiple recipients of list ORACLE-L


Dear List,
 One of our developers is getting following error
while trying to connect
using IIS Server (4.0) to oracle Database
8.1.6.2.0. I think he is using ASP
program to connect to database.
 I am able to connect though sqlplus.exe from that
machine but not through
the IIS Server connection. Is there anything else
you have to set in IIS
server to get right tnsnames.ora
 Can you help?
The error message:
Microsoft OLE DB Provider for Oracle error
'80004005'
ORA-12154: TNS:could not resolve service name
/getdate.asp, line 33

Thanks

Sandesh
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Naik, Sandesh S
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051
FAX: (858) 538-5051
San Diego, California-- Public Internet
access / Mailing Lists
--
--
To REMOVE yourself from this mailing list, send an
E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of
'ListGuru') and in
the message BODY, include a line containing: UNSUB
ORACLE-L
(or the name of mailing list you want to be
removed from).  You may
also send the HELP command for other information
(like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: shirish
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you

How to find oracle is 32/64 bit

2001-07-22 Thread Ajay Singh Rathore 

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: http://www.orafaq.com
-- 
Author: Ajay Singh Rathore
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: backup Oracle on Sun Cluster 2.2 ???

2001-07-22 Thread deshmukh 


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 database is down for cold backup.
Now, if u are using raw shared device, then the backup cab be taken through
'dd' and if u are using filesystems, then u can use anything u want.

DESHMUKH SAMBHAJI S
"Let's Document it and Call it a Future !"


   

"Sinardy"  

   <[EMAIL PROTECTED]>

Sent by: cc:   

root@fatcity.Subject: backup Oracle on Sun Cluster 2.2 
??? 
com

   

   

07/22/01   

09:10 PM   

Please 

respond to 

ORACLE-L   

   

   




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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sql help

2001-07-22 Thread Anand 

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 objects+the tablespaces
in which they reside.

i tried using the flwng way:


select tablespacename,table_name from dba_tables
where obj in (select obj_nm from dba_objects where
obj_type ='table' and owner='xyz')
union

select for indexes

union

select for clusters
;

can anybody tell me any alternative statement for the
above.

thnx in adv.

srinivas


__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: kommareddy sreenivasa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anand
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: backup Oracle on Sun Cluster 2.2 ???

2001-07-22 Thread Sinardy 

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 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]>
Sent: Sunday, July 22, 2001 8:10 PM


> 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
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sinardy
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Don Granaman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinardy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Locally managed tablespaces

2001-07-22 Thread Don Granaman 

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 new extent in the latter, you might  try "pre-fragmenting" the tablespace
by creating a junk table in it and manually allocating new extents, then
dropping the table - during a low activity period of course.

-Don Granaman
[ceritifiable OraSaurus]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, July 21, 2001 3:46 PM


> SMON will only automatically coalesce if pctincrease is > 0 but you
> can always ask for a coalesce.  Its part of the alter tablespace command
> and is the method I use.
>
> However, according to the doco there is no need to coalesce a LMT.
>
> -Original Message-
> Sent: Friday, July 20, 2001 7:01 AM
> To: Multiple recipients of list ORACLE-L
>
>
> It does not need to do it. Also SMON will coalesce only if pctincrease>0
and
> this is not a good idea.
>
> Alex Hillman
>
> -Original Message-
> Sent: Friday, July 20, 2001 8:41 AM
> To: Multiple recipients of list ORACLE-L
>
>
> consider this also..
> if u make a tablespace as LMT, the SMON process is not going to coalesce
it
> automatically..
> as it in the case of dictionary managed TS.
>
> if i'm wrong.. pls correct.
>
> Saurabh Sharma
>
> [EMAIL PROTECTED]
> http://www.geocities.com/saurabh00pc/stride.html
>
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Friday, July 20, 2001 5:16 AM
>
>
> > Yes, you can make any tablespace a locally-managed tablespace except
> SYSTEM.
> > What they're saying, I think, is that you can't set up temporary
> tablespaces
> > and shouldn't set up rollback segments with the AUTOALLOCATE allocation
> > management.
> >
> > Jon Walthour
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Thursday, July 19, 2001 4:32 PM
> >
> >
> > > I was pretty sure you could use it for any TS but SYSTEM. Is this
> > documented?
> > >
> > > Cheers,
> > >
> > > Earl
> > >
> > > ---
> > >
> > > TheOracleDBA
> > > [EMAIL PROTECTED]
> > >
> > >
> > >
> > > On Thu, 19 Jul 2001 09:32:27
> > >  Hillman, Alex wrote:
> > > >You canuse any storage parameters you like but oracle will ignore
them
> > exept
> > > >for initial for LMT with autoallocate. I would personally do not use
> > > >autoallocate. Also you cannot use autoallocate for temporary
tablespace
> > and
> > > >shouldn't use it for rollback.
> > > >
> > > >Alex Hillman
> > > >
> > > >-Original Message-
> > > >Sent: Thursday, July 19, 2001 12:43 PM
> > > >To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > >HPUX 11i 64 bit
> > > >Oracle 8.1.7.1 32 bit
> > > >
> > > >I am creating a new database and decided to go with locally managed
> > > >tablespaces.  I was going to go with autoallocate because the best I
> can
> > > >tell the only possible drawback with this is a little wasted space.
> > > >However, I was under the impression that you could not specify a next
> in
> > the
> > > >storage clause of a table creation.  Yet you can.  So what happens if
I
> > have
> > > >a next defined?  Do they pretty much just throw that away or should I
> > really
> > > >not define it?
> > > >
> > > >
> > > >
> > > >
> > > >Kimberly Smith
> > > >Database Administrator
> > > >IT Dept. - Fujitsu/GMD
> > > >Phone: (503) 669-6050
> > > >Fax: (503) 669-5705
> > > >Email : [EMAIL PROTECTED]
> > > >
> > > >--
> > > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > >--
> > > >Author: Kimberly Smith
> > > >  INET: [EMAIL PROTECTED]
> > > >
> > > >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > >San Diego, California-- Public Internet access / Mailing
Lists
> > > >
> > > >To REMOVE yourself from this mailing list, send an E-Mail message
> > > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > >the message BODY, include a line containing: UNSUB ORACLE-L
> > > >(or the name of mailing list you want to be removed from).  You may
> > > >also send the HELP command for other information (like subscribing).
> > > >--
> > > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > >--
> > > >Author: Hillman, Alex
> > > >  INET: [EMAIL PROTECTED]
> > > >
> > > >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > > >San Diego, California-- Public Internet access / Mailing
Lists
> > > >
> > > >To REMOVE yourself from this mailing list, send an E-Mail message
> > > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > >the m

Re: backup Oracle on Sun Cluster 2.2 ???

2001-07-22 Thread Don Granaman 

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]>
Sent: Sunday, July 22, 2001 8:10 PM


> 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
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sinardy
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don Granaman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

backup Oracle on Sun Cluster 2.2 ???

2001-07-22 Thread Sinardy 

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sinardy
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

SQLJ vrs PLSQL

2001-07-22 Thread Christopher Spence 

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
which only has to do a single context switch to make a SQL call.

Anyone have any experience either way?  Even Oracle claims PLSQL is faster:

"PL/SQL is a better solution for SQL-intensive applications. PL/SQL is
optimized for SQL, and so SQL operations are faster in PL/SQL than in Java.
Also, PL/SQL uses SQL datatypes directly, while Java applications must
convert between SQL datatypes and Java types."

 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: MTS - in Linux

2001-07-22 Thread Joe Testa 

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 mine)
> 
>  - jeremy
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing)

-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: MTS - in Linux

2001-07-22 Thread JDonson 

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 PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: version

2001-07-22 Thread Jon Walthour 

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 PM


> 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-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jon Walthour
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: some thing strange with user_tables vs real table

2001-07-22 Thread A. Bardeen 

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 tables from
MS Access to Oracle.  Be advised that this affects the
column names too, so they may need to be enclosed in
double quotes in order to be accessed.  Because of
this, I prefer to take the time to convert all table
and column names to upper case and Oracle naming
conventions BEFORE converting them from Access.

BTW, you can do the same thing manually by enclosing
the table or column names in double quotes.

HTH,

-- Anita 

--- "Ari, Rama" <[EMAIL PROTECTED]> wrote:
> One of our programmer had imported a table from
> ACESS database. 
> 
> When I query user_tables I get following result.
> SQL> select table_name from user_tables where
> table_name= 'TMP_APRIL'
> 
> no rows selected
> 
> SQL> select table_name from user_tables where
> table_name= 'tmp_april'
> 
> TABLE_NAME
> --
> tmp_april
> 
> When I query tmp_april table I get following result.
> SQL> select count(*) from tmp_april;
> select count(*) from tmp_april
>  *
> ERROR at line 1:
> ORA-00942: table or view does not exist
> 
> SQL> select count(*) from TMP_APRIL;
> select count(*) from tmp_april
>  *
> ERROR at line 1:
> ORA-00942: table or view does not exist
> 
> For some reason, table name has been stored as
> tmp_april (lower case). When
> we create table it supposed to store table name with
> upper case.
> 
> Did any one had similar kind of problem?
> 
> Thanks in Advance,
> 
> Rama Ari
> Database Administrator
> [EMAIL PROTECTED]
> 610.964.5128
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Ari, Rama
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: version

2001-07-22 Thread Mohammad Rafiq 

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 (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-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle listener security patch -

2001-07-22 Thread A. Bardeen 

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 for 8.1.6.3 on Solaris.
> But maybe it is not due to the patchset, because
> I've applied it on 2 
> servers and I'm only having problems in one of them,
> the production one!!!
> Have you ever seen this kind of error?
> 
> SQL> alter session set optimizer_mode=all_rows;
> ERROR:
> ORA-00096: invalid value ALL_ROWS for parameter
> optimizer_mode, must be from
> among signature, timestamp
> 
> Thx,
> Àngel
> 
> 
> At 23.55 18/7/01 -0800, you wrote:
> 
> >You can't get more secure than that!
> >John
> >
> >-Original Message-
> >From: John Lewis 
>
>[mailto:[EMAIL PROTECTED]]
> >Sent: 19 July 01 00:01
> >To: Multiple recipients of list ORACLE-L
> >Subject: Oracle listener security patch -
> >
> >Just installed p1859778_8162_Solaris patch for
> listener security problems.
> >Before I installed it - everything was hunky-dory.
> >Afterwards the listener wouldn't start any
> 'services'.
> >Haven't tried metallink yet.
> >
> >Anybody had this problem?
> >
> >(Using 8.1.6.2 on Sun Solaris)
> >
> >TIA -
> >john f. lewis
> >
> >--
> >Please see the official ORACLE-L FAQ: 
> >http://www.orafaq.com
> >--
> >Author: John Lewis
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> >San Diego, California-- Public Internet
> access / Mailing Lists
>
>
> >To REMOVE yourself from this mailing list, send an
> E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB
> ORACLE-L
> >(or the name of mailing list you want to be removed
> from).  You may
> >also send the HELP command for other information
> (like subscribing).
> >
> >
> >
>
>**
> >This email and any attachments may be confidential
> and the subject of
> >legal professional privilege. Any disclosure, use,
> storage or copying
> >of this email without the consent of the sender is
> strictly prohibited.
> >Please notify the sender immediately if you are not
> the intended
> >recipient and then delete the email from your inbox
> and do not
> >disclose the contents to another person, use, copy
> or store the
> >information in any medium.
>
>**
> 


__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Snapshot shows as INVALID in DBA_OBJECTs

2001-07-22 Thread A. Bardeen 

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 statement that determines the
object type.  It doesn't have an entry for type 42,
the new type for materialized views/snapshots, so
that's why they're listed as "undefined."

You can manually change the view definition, just keep
in mind that you'll need to change it again after
applying a patchset if the patchset replaces
catalog.sql.

It doesn't interfere with the way the snapshot/MV
works, so it's considered annoying, but harmless.  The
script is fixed in 9i.

HTH,

-- Anita

--- Dave Morgan <[EMAIL PROTECTED]> wrote:
> Hi All,
>   The subject says it all, 8.1.7 on Solaris 2.8
> 
>   The snapshot is accessable and correct. 
> 
>   Anyone know a (supported) way to clean up the data
> dictionary?
> 
> TIA
> Dave
> 
> -- 
> Dave Morgan
> DBA, Cybersurf
> Office: 403 777 2000 ext 284
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Dave Morgan
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: export/import object types

2001-07-22 Thread A. Bardeen 

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 if anyone has seen this before.
> 
> I export an user A, then import it into user B in a
> different database
> and everything is ok.  Then I use the same export
> file to import into
> user C in the same database as user B and all the
> "CREATE TYPE" 
> failed because Oracle retains the object id in the
> export file and when 
> importing into user C it tries to create them with
> the same object id
> and since user B already has it it failed.  I had to
> manually delete
> the object id from the log and recreate it.
> 
> It's not a huge problem since it's rare that I do
> something like this.
> But just wondering why would Oracle retain the
> object id for TYPE?
> It certainly didn't keep the same object id for
> other objects like table, etc.
> 
> Any thoughts?
> 
> Richard Ji



__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: MTS - in Linux

2001-07-22 Thread A. Bardeen 

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 8.1.7EE.
> Ivo
> 
> 
> -Original Message-
> Sent: Monday, July 16, 2001 11:36 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Friends :
> 
> I have the parameters below and we are receiving the
> message :
> 
>PMON: terminating instance due to error 601
>Instance terminated by PMON, pid = 11300
>Load Indicator not supported by OS !
> 
> Does anyone know this error ?
> If i to alter all parameters MTS solve this problem
> ?
> 
> Regards
> Eriovaldo
> 
> BANNER
>

> Oracle8i Release 8.1.6.1.0 - Production
> PL/SQL Release 8.1.6.0.0 - Production
> CORE8.1.6.0.0   Production
> TNS for Linux: Version 8.1.6.0.0 - Production
> NLSRTL Version 3.4.0.0.0 - Production
> 
> 
> SVRMGR> show parameter mts
> NAMETYPEVALUE
> --- ---
> --
> mts_circuitsinteger 225
> mts_dispatchers string 
> (protocol=TCP)
> mts_listener_addressstring
> mts_max_dispatchers integer 5
> mts_max_servers integer 20
> mts_multiple_listeners  boolean FALSE
> mts_servers integer 1
> mts_service string  I001
> mts_sessionsinteger 220
> 
> 
>
_
> Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com.
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Eca Eca
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Libal, Ivo
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).


__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

version

2001-07-22 Thread Rukmini Devi 

 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-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sql help

2001-07-22 Thread GL2Z/ INF DBA BENLATRECHE 

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é : samedi 21 juillet 2001 15:45
À : Multiple recipients of list ORACLE-L
Objet : sql help


hi dba's

how to find out a users all objects+the tablespaces
in which they reside.

i tried using the flwng way: 


select tablespacename,table_name from dba_tables
where obj in (select obj_nm from dba_objects where
obj_type ='table' and owner='xyz') 
union

select for indexes

union

select for clusters   
;

can anybody tell me any alternative statement for the
above.

thnx in adv.

srinivas


__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: kommareddy sreenivasa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: GL2Z/ INF  DBA BENLATRECHE
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).