date:20010829


Thanks Christopher. Useful information.

-Original Message-
Sent: Tuesday, August 28, 2001 7:26 PM
To: Multiple recipients of list ORACLE-L


When it is perm, you need to recovery it like a normal tablespace if moving
it or recovering, unless you offline it or rebuild the control file, with a
temporary tablespace it is just not part of the database.  It is a bit
simplier, although you can get around it.  Although both work perfectly
fine, it is syntaxtic sugar as I would say to just set it as temporary
(tempfile) and not have to worry about it period.

As for putting objects into it, agreed, you can avoid it, but with a
temporary tablespace you do not need to worry about it at all.  This is a
minor problem, but is something to note.

As for ST enqueue, perhaps you do not have problems with the ST enqueue, but
there are many cases where perm tablespace for sorting causes ST enqueue
contention, most notably when doing parallel segment creation.  It is well
documented that perm temporary tablespaces cause more contention on the ST
enqueue.  When you have a perm temporary tablespace, for every extent
created you need to hold the ST enqueue exclusively.  This WILL cause ST
enqueue contention, it is very possible you are not suffering from large
waits due to this.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Tuesday, August 28, 2001 9:17 AM
To: Christopher Spence; Multiple recipients of list ORACLE-L


Chris,

I've always used a permanent tablespace for temp and have not had the
problems you state.  But it does take some consistency to maintain.

1- we never allow anyone a quota on temp or even allow anyone to have that
as their default.  Come to think of it only sys has system as it's default
tablespace.  We also do not allow 'unlimited tablespace' even to purchased
apps.
2- The ST enqueue has not been a problem, actually have 0 contention there
even in the data warehouse.
3- we don't back it up.  Have had one get trashed, along with the disk
drive. 
Did an offline drop and rebuilt it elsewhere.

Dick Goulet

Reply Separator
Author: Christopher Spence [EMAIL PROTECTED]
Date:   8/28/2001 5:50 AM

No, it is generally better practice to use temporary tablespace for the
following reasons.
 
1.  You will not accidentently store objects in it.
2.  Reduced contention for the ST enqueue
3. Reduce backup and recovery time
 
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:(707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  

-Original Message-
Sent: Tuesday, August 28, 2001 8:11 AM
To: Multiple recipients of list ORACLE-L




Oracle recommends creation of separate temporary tablespace for sort
operations.  
Is there any advantage in using a permanent tablespace instead of a
temporary for sort operations? 

rgds 
amar 


!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD
META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=us-ascii
TITLEMessage/TITLE

META content=MSHTML 5.50.4807.2300 name=GENERATOR/HEAD BODY
DIVSPAN class=040424112-28082001FONT color=#ff size=2No, it is 
generally better practice to use temporary tablespace for the following 
reasons./FONT/SPAN/DIV
DIVSPAN class=040424112-28082001FONT color=#ff 
size=2/FONT/SPANnbsp;/DIV
DIVSPAN class=040424112-28082001FONT color=#ff size=21.nbsp; You
will

not accidentently store objects in it./FONT/SPAN/DIV DIVSPAN
class=040424112-28082001FONT color=#ff size=22.nbsp; Reduced 
contention for the ST enqueue/FONT/SPAN/DIV
DIVSPAN class=040424112-28082001FONT face=Arial color=#ff size=23.

Reduce backup and recovery time/FONT/SPAN/DIV
DIVFONT face=Arial color=#ff size=2/FONTnbsp;/DIV DIVFONT
face=Times New RomanDo not criticize someone until you walked a 
mile in their shoes, that way when you criticize them, you are a mile a way
and 
have their shoes./FONT/DIV
PFONT face=Script size=5Christopher R. Spence/FONT BRFONT 
face=Comic Sans MS size=2Oracle DBA/FONT BRFONT face=Comic Sans MS

size=2Phone: (978) 322-5744/FONT BRFONT face=Comic Sans MS 
size=2Fax:nbsp;nbsp;nbsp; (707) 885-2275/FONT /P PFONT
face=Comic Sans MS size=2Fuelspot/FONT BRFONT 
face=Comic Sans MS size=273 Princeton Street/FONT BRFONT 
face=Comic Sans MS size=2North, Chelmsford 01863/FONT BRFONT 
face=Comic Sans MS size=2/FONTnbsp; /P
BLOCKQUOTE dir=ltr style=MARGIN-RIGHT: 0px
  DIV/DIV
  DIV class=OutlookMessageHeader lang=en-us dir=ltr align=leftFONT 
  face=Tahoma size=2-Original Message-BRBFrom:/B Amar Kumar
Padhi

  [mailto:[EMAIL

Re: Windows application - Linux server

2001-08-29 Thread Stefan Jahnke


Hi,

I can recommend the OFC (the Oracle Class Library for Windows
platforms). It's stable and caters to Oracle's capabilities. We used it
and it's great. 
And ... yes, use a RAD tool like C++ - Builder. Creating GUIs with VC++
is a pain.

 
| Regards,   |
| Stefan Jahnke  |
| @:D2 Vodafone, Abt.: FBOM  |
 


Jan Pruner schrieb:
 
 Ad 1.
 If you need only forms to read your data and business logic is simple:
 - I think that the best way is create packages with business logic in PL/SQL
 on server and put output on a web server to view it using standard web
 browser. You haven't to install any stuff on client workstation (program,
 net8 or ODBC, configuration ...)
 
 If your users need to analyze data extracted from db:
 - Forgott VB - you cannot handle data well and you will die from upgrading
 every workstation during installation of your soft.
 - If you will use VC++ - perfect GUI is a pain, use some RAD tool like
 Borland builder or any other.
 
 Ad 2.
 Use Net8 and objects of your development framework.
 
 What's about Java?
 
 Jan Pruner
 
 Dne út 28. srpen 2001 12:30 jste napsal(a):
  Hi all,
I would like to develop a windows (Windows 98)application, which will
  have to connect to an oracle database (8.1.6) running on a Linux machine (
  RH 7.0 ). Can somebody please advice me as to which of the following can be
  chosen:
 
  1). Which language or GUI interface would be efficient?
   VB, VC++ or is there something else ?
  2). Which is the best way to connect to the database?
   ODBC, OLEDB , Activex Data Objects  or
   anything other than these ?
   And also how about using pro_c++?
 
   This is the first time I am trying to develop an application for
  Windows, so I donot have any idea about these technologies, but I would
  like to choose the best one before I start to learn about it. Can someone
  please help me or guide me to some resource which will provide this
  information? I don't require information about the technologies themselves,
  just tell me which the best one is and I will manage to learn it myself.
  Thanks for any help.
 
  PS: Even, if you have experience working with only one of the technologies,
  please mail back with the experiences you had with it. In this way we can
  compare all the individual experiences and will be able to make out
  something out of it.
 
 
 
 
 
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Vandana  Ponnuru
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: Jan Pruner
   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 Mail has been checked for Viruses
 Attention: Encrypted mails can NOT be checked!
 
 **
 
 Diese Mail wurde auf Viren geprueft
 Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden!
 -

--

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stefan Jahnke
  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: RE: Permanent Tablespace for sorting.

Title: RE: RE: Permanent Tablespace for sorting.






How do we check on the ST enqueue contention?


rgds
amar


-Original Message-
From: Connor McDonald [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 10:33 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:RE: Permanent Tablespace for sorting.



I suppose the response to this would be why bother?.
temp tablespaces (especially tempfile ones) will have



- less impact on redo logs
- allows current ( or future) use of standby for
read-only
- no need for any offline drop etc


Cheers
Connor


--- [EMAIL PROTECTED] wrote:  Chris,
 
 I've always used a permanent tablespace for temp
 and have not had the
 problems you state. But it does take some
 consistency to maintain.
 
 1- we never allow anyone a quota on temp or even
 allow anyone to have that as
 their default. Come to think of it only sys has
 system as it's default
 tablespace. We also do not allow 'unlimited
 tablespace' even to purchased apps.
 2- The ST enqueue has not been a problem, actually
 have 0 contention there even
 in the data warehouse.
 3- we don't back it up. Have had one get trashed,
 along with the disk drive. 
 Did an offline drop and rebuilt it elsewhere.
 
 Dick Goulet
 
 Reply
 Separator
 Author: Christopher Spence [EMAIL PROTECTED]
 Date: 8/28/2001 5:50 AM
 
 No, it is generally better practice to use temporary
 tablespace for the
 following reasons.
 
 1. You will not accidentently store objects in it.
 2. Reduced contention for the ST enqueue
 3. Reduce backup and recovery time
 
 Do not criticize someone until you walked a mile in
 their shoes, that way
 when you criticize them, you are a mile a way and
 have their shoes.
 
 Christopher R. Spence 
 Oracle DBA 
 Phone: (978) 322-5744 
 Fax: (707) 885-2275 
 
 Fuelspot 
 73 Princeton Street 
 North, Chelmsford 01863 
 
 
 -Original Message-
 Sent: Tuesday, August 28, 2001 8:11 AM
 To: Multiple recipients of list ORACLE-L
 
 
 
 
 Oracle recommends creation of separate temporary
 tablespace for sort
 operations. 
 Is there any advantage in using a permanent
 tablespace instead of a
 temporary for sort operations? 
 
 rgds 
 amar 
 
 
 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0
 Transitional//EN
 HTMLHEAD
 META HTTP-EQUIV=Content-Type CONTENT=text/html;
 charset=us-ascii
 TITLEMessage/TITLE
 
 META content=MSHTML 5.50.4807.2300
 name=GENERATOR/HEAD
 BODY
 DIVSPAN class=040424112-28082001FONT
 color=#ff size=2No, it is 
 generally better practice to use temporary
 tablespace for the following 
 reasons./FONT/SPAN/DIV
 DIVSPAN class=040424112-28082001FONT
 color=#ff 
 size=2/FONT/SPANnbsp;/DIV
 DIVSPAN class=040424112-28082001FONT
 color=#ff size=21.nbsp; You will
 
 not accidentently store objects in
 it./FONT/SPAN/DIV
 DIVSPAN class=040424112-28082001FONT
 color=#ff size=22.nbsp; Reduced 
 contention for the ST enqueue/FONT/SPAN/DIV
 DIVSPAN class=040424112-28082001FONT face=Arial
 color=#ff size=23. 
 Reduce backup and recovery time/FONT/SPAN/DIV
 DIVFONT face=Arial color=#ff
 size=2/FONTnbsp;/DIV
 DIVFONT face=Times New RomanDo not criticize
 someone until you walked a 
 mile in their shoes, that way when you criticize
 them, you are a mile a way and 
 have their shoes./FONT/DIV
 PFONT face=Script size=5Christopher R.
 Spence/FONT BRFONT 
 face=Comic Sans MS size=2Oracle DBA/FONT
 BRFONT face=Comic Sans MS 
 size=2Phone: (978) 322-5744/FONT BRFONT
 face=Comic Sans MS 
 size=2Fax:nbsp;nbsp;nbsp; (707) 885-2275/FONT
 /P
 PFONT face=Comic Sans MS size=2Fuelspot/FONT
 BRFONT 
 face=Comic Sans MS size=273 Princeton
 Street/FONT BRFONT 
 face=Comic Sans MS size=2North, Chelmsford
 01863/FONT BRFONT 
 face=Comic Sans MS size=2/FONTnbsp; /P
 BLOCKQUOTE dir=ltr style=MARGIN-RIGHT: 0px
 DIV/DIV
 DIV class=OutlookMessageHeader lang=en-us dir=ltr
 align=leftFONT 
 face=Tahoma size=2-Original
 Message-BRBFrom:/B Amar Kumar Padhi
 
 [mailto:[EMAIL PROTECTED]] BRBSent:/B
 Tuesday, August 28, 2001 8:11 
 AMBRBTo:/B Multiple recipients of list
 ORACLE-LBRBSubject:/B 
 Permanent Tablespace for sorting.
 BRBR/FONT/DIVBR
 PFONT face=Courier size=2Oracle recommends
 creation of separate temporary 
 tablespace for sort operations.nbsp;
 /FONTBRFONT face=Courier size=2Is 
 there any advantage in using a permanent
 tablespace instead of a temporary for
 
 sort operations? /FONT/P
 PFONT face=Courier size=2rgds/FONT BRFONT
 face=Courier 
 size=2amar/FONT /P/BLOCKQUOTE/BODY/HTML
 
 -- 
 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

RE: RE: Permanent Tablespace for sorting.

Title: RE: RE: Permanent Tablespace for sorting.





Thanks Cris and Conner, 
I was concerned about the performance implications between the two, even if minor. 


rgds
amar


-Original Message-
From: Connor McDonald [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 10:33 PM
To: Multiple recipients of list ORACLE-L
Subject: Re:RE: Permanent Tablespace for sorting.



I suppose the response to this would be why bother?.
temp tablespaces (especially tempfile ones) will have



- less impact on redo logs
- allows current ( or future) use of standby for
read-only
- no need for any offline drop etc


Cheers
Connor


--- [EMAIL PROTECTED] wrote:  Chris,
 
 I've always used a permanent tablespace for temp
 and have not had the
 problems you state. But it does take some
 consistency to maintain.
 
 1- we never allow anyone a quota on temp or even
 allow anyone to have that as
 their default. Come to think of it only sys has
 system as it's default
 tablespace. We also do not allow 'unlimited
 tablespace' even to purchased apps.
 2- The ST enqueue has not been a problem, actually
 have 0 contention there even
 in the data warehouse.
 3- we don't back it up. Have had one get trashed,
 along with the disk drive. 
 Did an offline drop and rebuilt it elsewhere.
 
 Dick Goulet
 
 Reply
 Separator
 Author: Christopher Spence [EMAIL PROTECTED]
 Date: 8/28/2001 5:50 AM
 
 No, it is generally better practice to use temporary
 tablespace for the
 following reasons.
 
 1. You will not accidentently store objects in it.
 2. Reduced contention for the ST enqueue
 3. Reduce backup and recovery time
 
 Do not criticize someone until you walked a mile in
 their shoes, that way
 when you criticize them, you are a mile a way and
 have their shoes.
 
 Christopher R. Spence 
 Oracle DBA 
 Phone: (978) 322-5744 
 Fax: (707) 885-2275 
 
 Fuelspot 
 73 Princeton Street 
 North, Chelmsford 01863 
 
 
 -Original Message-
 Sent: Tuesday, August 28, 2001 8:11 AM
 To: Multiple recipients of list ORACLE-L
 
 
 
 
 Oracle recommends creation of separate temporary
 tablespace for sort
 operations. 
 Is there any advantage in using a permanent
 tablespace instead of a
 temporary for sort operations? 
 
 rgds 
 amar 
 
 
 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0
 Transitional//EN
 HTMLHEAD
 META HTTP-EQUIV=Content-Type CONTENT=text/html;
 charset=us-ascii
 TITLEMessage/TITLE
 
 META content=MSHTML 5.50.4807.2300
 name=GENERATOR/HEAD
 BODY
 DIVSPAN class=040424112-28082001FONT
 color=#ff size=2No, it is 
 generally better practice to use temporary
 tablespace for the following 
 reasons./FONT/SPAN/DIV
 DIVSPAN class=040424112-28082001FONT
 color=#ff 
 size=2/FONT/SPANnbsp;/DIV
 DIVSPAN class=040424112-28082001FONT
 color=#ff size=21.nbsp; You will
 
 not accidentently store objects in
 it./FONT/SPAN/DIV
 DIVSPAN class=040424112-28082001FONT
 color=#ff size=22.nbsp; Reduced 
 contention for the ST enqueue/FONT/SPAN/DIV
 DIVSPAN class=040424112-28082001FONT face=Arial
 color=#ff size=23. 
 Reduce backup and recovery time/FONT/SPAN/DIV
 DIVFONT face=Arial color=#ff
 size=2/FONTnbsp;/DIV
 DIVFONT face=Times New RomanDo not criticize
 someone until you walked a 
 mile in their shoes, that way when you criticize
 them, you are a mile a way and 
 have their shoes./FONT/DIV
 PFONT face=Script size=5Christopher R.
 Spence/FONT BRFONT 
 face=Comic Sans MS size=2Oracle DBA/FONT
 BRFONT face=Comic Sans MS 
 size=2Phone: (978) 322-5744/FONT BRFONT
 face=Comic Sans MS 
 size=2Fax:nbsp;nbsp;nbsp; (707) 885-2275/FONT
 /P
 PFONT face=Comic Sans MS size=2Fuelspot/FONT
 BRFONT 
 face=Comic Sans MS size=273 Princeton
 Street/FONT BRFONT 
 face=Comic Sans MS size=2North, Chelmsford
 01863/FONT BRFONT 
 face=Comic Sans MS size=2/FONTnbsp; /P
 BLOCKQUOTE dir=ltr style=MARGIN-RIGHT: 0px
 DIV/DIV
 DIV class=OutlookMessageHeader lang=en-us dir=ltr
 align=leftFONT 
 face=Tahoma size=2-Original
 Message-BRBFrom:/B Amar Kumar Padhi
 
 [mailto:[EMAIL PROTECTED]] BRBSent:/B
 Tuesday, August 28, 2001 8:11 
 AMBRBTo:/B Multiple recipients of list
 ORACLE-LBRBSubject:/B 
 Permanent Tablespace for sorting.
 BRBR/FONT/DIVBR
 PFONT face=Courier size=2Oracle recommends
 creation of separate temporary 
 tablespace for sort operations.nbsp;
 /FONTBRFONT face=Courier size=2Is 
 there any advantage in using a permanent
 tablespace instead of a temporary for
 
 sort operations? /FONT/P
 PFONT face=Courier size=2rgds/FONT BRFONT
 face=Courier 
 size=2amar/FONT /P/BLOCKQUOTE/BODY/HTML
 
 -- 
 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

Re: Convert 7.3 users to 8.17 users

2001-08-29 Thread nlzanen1



Hi,


I can't test on 7.3 anymore but try following kind of script (it seems to
work between 8.0  8.1 databases


**
ORACLE_SID=EWIP
export ORACLE_SID
sqlplus -s username/password EOF
set term off echo off heading off feedback off verify off
set pagesize 0 linesize 80 recsep off
set concat
spool syncEWIP03.sql
rem

select 'drop user '||username||' cascade;' from dba_users where username
not in ('SYS','SYSTEM','DBSNMP');
rem

select 'create user '||username||' identified by values '''||password||'''
default tablespace '|| default_tablespace ||'
temporary tablespace '||temporary_tablespace||'
profile '||profile||';' from dba_users@EWPR where username not in
('SYS','SYSTEM','DBSNMP');
rem

select 'alter user '||username||' quota '||-
decode(max_bytes,-1,'unlimited',max_bytes)|| ' on '||tablespace_name||';'-
from dba_ts_quotas@EWPR;
rem

select 'grant '||granted_role||' to '||grantee ||-
decode(admin_option,'YES',' with admin option','')||';'-
from dba_role_privs@EWPR;
rem
===
select 'grant '||privilege||' to '||grantee||-
decode(admin_option,'YES',' with admin option','')||';'-
from dba_sys_privs@EWPR;
rem

select 'create synonym '||owner||'.'||synonym_name||'
for '||table_owner||'.'||table_name||';'
from dba_synonyms@EWPR where owner not in ('SYS','SYSTEM','DBSNMP');

spool off
@syncEWIP03
exit
EOF

**


Jack




Bartolo, David [EMAIL PROTECTED]@fatcity.com on 28-08-2001 23:07:54

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)

Hi all

Can I take all the users created in a 7.3 database and somehow import them
into a 8.1.7 database
with the original passwords and roles/access to tables?


TIA
David
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bartolo, David
  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).




=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst 
Young, niet toegestaan. Ernst  Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst  Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst  Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst  Young. Ernst  Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst  Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all

RE: Migration of simple snapshots

2001-08-29 Thread Hatzistavrou Giannis

In your case, i would have used offline instantiation. Have a look at the
replication manual!

Cheers

 -Original Message-
 From: Mike J Kurth [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, August 28, 2001 18:51
 To:   Multiple recipients of list ORACLE-L
 Subject:  Migration of simple snapshots

 I use simple snapshots, and have some questions regarding migration from
 7.3.4.5
 to 8.1.6.2:
 1) Can a 8.1.6.2 master site co-exist with a 7.3.4.5 snapshot site?
 2) After I migrate master site I need to drop triggers on the mlogs,
 because
 8I does not use database triggers to populate the mlogs?
 3) Do I need to do a complete refresh of each snapshot after the master
migration? Any way around this?
 4) Do I need to convert my rowid snapshots to primary key snapshots?
 5) Any other issues I need to be aware of?

 Thanks

 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Mike J Kurth
   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: Hatzistavrou Giannis
  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).

How to select and display 10 records at a time from a table using sql query

2001-08-29 Thread Ranganath K


Dear DBA Gurus,

How do I select and display 10 records at a time from a table using sql
query only?

Thanks and Regards,

Ranganath


DISCLAIMER: This correspondence is confidential and intended for the named
recipient(s) only. If you are not the named recipient and receive this
correspondence in error, you must not copy, distribute or take any action in
reliance on it and you should delete it from your system and notify the
sender immediately. Unless otherwise stated, any views or opinions expressed
are solely those of the author and do not represent those of Subex Systems
Limited.

www.subexgroup.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ranganath K
  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: OT : kernel using 75% of CPU

2001-08-29 Thread Connor McDonald


Agreed - and Sun doesn't handle getting close to the
edge at all well imho.  Recently upgraded a db on
(2.6) server from 8.0 to 8.1.6 and it went from
running fine to running like an absolute dog - kernel
thrashing exactly like our initial poster reports...

... The problem?

java_pool_size (and its 20m default).  Once the idiot
(me) remembered to reset this to 32k, performance was
immediately better than even the original 8.0.  Just
an extra 20M freed up (on a 512M box) and miracles
occurred 

Cheers
Connor

 --- Christopher Spence [EMAIL PROTECTED] wrote:
 paging and swapping is the first thing that comes to
 mind, look at vmstat.
  
 I think your question is completely on topic.
  
 
 Do not criticize someone until you walked a mile in
 their shoes, that way
 when you criticize them, you are a mile a way and
 have their shoes.
 
 Christopher R. Spence 
 Oracle DBA 
 Phone: (978) 322-5744 
 Fax:(707) 885-2275 
 
 Fuelspot 
 73 Princeton Street 
 North, Chelmsford 01863 
   
 
 -Original Message-
 Sent: Tuesday, August 28, 2001 11:20 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi there,
  
 I have a Sun e4500, running Solaris 2.7 and Oracle
 8.1.7.1.0. Everything
 looks normal from a database perspective, but when I
 run top it show the
 kernel being very hog-like:
  
 load averages: 14.38, 15.18, 15.18
 07:16:21
 126 processes: 118 sleeping, 4 running, 4 on cpu
 CPU states:  0.6% idle, 26.6% user, 72.8% kernel, 
 0.0% iowait,  0.0% swap
 Memory: 4096M real, 63M free, 216M swap in use,
 5310M swap free
  
   PID USERNAME THR PRI NICE  SIZE   RES STATE   TIME
CPU COMMAND
  2286 oracle 1   00 1844M 1814M run 9:44
 13.90% oracle
 11068 oracle 1   00 2056K 1536K cpu00:02
  1.53% top
 11333 oracle 1   00 1150M 1124M cpu10:01
  1.39% oracle
  5944 oracle 1  400 1820M 1789M sleep  14:40
  1.36% oracle
  4797 root   1  500 2112K 1248K sleep   6:01
  1.36% top
 11346 oracle 1   00  110M   92M cpu00:01
  1.26% oracle
 4 oracle 1   00 1009M  984M cpu10:00
  0.66% oracle
 11157 oracle 1   00 1009M  984M run 0:00
  0.63% oracle
 11368 oracle 1  330 1794M 1765M sleep   0:00
  0.29% oracle
 19558 oracle 1  600 1797M 1751M sleep  78:28
  0.28% oracle
 19554 oracle 1  600 1794M 1751M sleep  38:05
  0.20% oracle
 11366 oracle 1  550 1793M 1763M sleep   0:00
  0.19% oracle
 11292 oracle 1  262 2008K 1424K run 0:00
  0.19% dsql
  
 Any ideas on what I, as a lowly DBA, would be able
 to check? It's a bit out
 of my area and I'm stumped...
  
  
 Thanks!
  
 Jerry
 
 
 
  

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

Some days you're the pigeon, some days you're the statue


Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  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: OT : kernel using 75% of CPU




OK,

If 
you're not using JServer/Aurora (whatever it's called this week), you can drop 
the size of your Java pool, I usually have mine set to 2M on such databases 
without any trouble. Is the Java running on the Oracle server? The way to see 
what Java is actually doing is to use the Java Profiler (this works with Sun 
JDK, which I assume you are using). Use the command:

$ 
java -Xrunhprof:help

to 
find out how to do this. If you are seeing paging activity buthave plenty 
of free memory, this suggests memory-mapped I/O. But you have a high scan rate, 
which means that Solaris is constantly needing to look for free memory. 
Although, if you have priority_paging set in /etc/system, it will be high 
anyway. Hmmm. The problem is definitely Solaris rather than Oracle. Software 
RAID? Hmmm.

g


  -Original Message-From: Jerry C 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 28, 2001 10:46 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  OT : kernel using 75% of CPU
  Guy,
  
  Thank you very very much, this is a great 
  explanation, and is much appreciated.
  
  To answer some of your questions (and add 
  a few!):
  
  Yes, our client is experiencing 
  performance problems.
  
  vmstat and swap -s seem to show some 
  swapping:
  
  csuaor46 vmstat 2 
  10procs 
  memory 
  page 
  disk 
  faults cpur b w swap 
  free re mf pi po fr de sr s6 s1 s1 s5 in 
  sy cs us sy id2 0 0 14536 14776 67 1514 15 
  228 957 62760 262 0 2 2 0 640 115 931 25 25 502 0 0 6179304 62416 36 
  1893 0 744 5500 56488 1126 0 4 4 0 988 6159 917 23 55 221 0 0 
  6177696 62600 20 908 0 1032 11808 56488 2488 0 6 6 0 917 3781 667 24 51 
  250 0 0 6181688 62960 89 1528 4 288 444 56488 37 0 6 6 0 1076 19029 
  862 23 54 231 0 0 6181336 64432 15 1269 0 140 576 56488 110 0 1 1 0 
  456 8550 493 14 46 400 0 0 6182376 63776 18 2976 4 368 1008 62760 
  328 0 8 8 0 594 6163 831 14 54 322 0 0 6180800 63072 9 1746 0 
  300 1296 62760 202 0 1 1 0 661 4441 693 12 65 230 0 0 6178120 62728 
  47 1311 4 612 2272 56488 464 0 3 2 0 829 5535 801 34 38 282 0 0 
  6179944 64616 36 1322 0 364 764 62760 70 0 0 0 0 996 4786 739 13 69 
  180 0 0 6183112 62560 40 856 4 340 1444 62760 339 0 1 2 0 822 
  4107 707 10 40 50csuaor46 swap -stotal: 2602216k bytes allocated + 
  19960k reserved = 2622176k used, 6177752k available
  I would assume swapping operations would 
  be included under "kernel"? The app also uses java, is there any way to 
  determine if Java is performing any wacky system calls?
  
  There are 3 databases on this box, which 
  has 4 Gb. of memory:
  
  csuaor46 ps -ef |grep ora_ |grep 
  smon oracle 867 1 
  0 Aug 16 ? 0:13 
  ora_smon_tstrn oracle 981 
  1 0 Aug 16 ? 0:14 
  ora_smon_tsdmo oracle 19561 1 
  0 Aug 23 ? 0:35 
  ora_smon_tsprd
  The main db (tsprd) has an SGA of 1.7 
  Gb., the other 2 are ~180 Mb. each. -so that's ~2.1 Gb. There are only 
  49 connections to the 3 databases:
  
  csuaor46 ps -ef |grep LOCAL 
  |wc 49 
  447 3418
  
  We are not using MTS. Is there any way to 
  determine the amount of real memory that these dedicated connections are 
  using? I can't see how the whole 4 Gb. would be used, causing the system to 
  swap... ?
  
  The primary database:
  - has an SGA of 1.7GB
   shared pool 
  550Mb.
  buffer cache 
  640Mb.
   java 
  pool 470Mb.! (460Mb. of which is free)
  - logical I/O rate~3,000 
  blocks/sec.
  - physical I/O rate 500-1,000 I/O/sec 
  (disk is EMC, RAID 1+0 I think)
  
  Everything internal to the db doesn't 
  look that bad, although I'm guessing they don't need so much java pool and the 
  shared pool could be downsized...
  
  Still stumped
  
  Thanks again.
  
  csuaor46 iostat -xtc 15 
  20 
  extended device statistics 
  tty 
  cpudevice r/s w/s kr/s 
  kw/s wait actv svc_t %w %b tin tout us sy wt 
  idsd6 0.0 0.0 
  0.0 0.0 0.0 0.0 
  0.0 0 0 0 18 25 25 
  2 48sd11 1.0 1.4 
  11.3 24.7 0.0 0.1 32.0 
  0 2 sd12 1.0 
  1.4 11.3 24.7 0.0 0.1 
  45.3 0 2 sd58 
  0.0 0.0 0.0 0.0 0.0 
  0.0 0.0 0 0 
  sd75 0.2 0.4 
  11.4 3.7 0.0 0.0 
  1.6 0 0 sd76 
  8.9 0.4 335.9 3.2 0.0 
  0.0 6.3 0 3 
  sd77 0.2 0.0 
  7.0 0.1 0.0 0.0 
  4.2 0 0 sd78 
  0.5 0.1 23.2 1.3 0.0 
  0.0 6.3 0 0 
  sd79 0.0 0.0 
  1.5 0.2 0.0 0.0 
  5.3 0 0 sd135 0.0 
  0.0 0.0 0.0 0.0 
  0.0 0.0 0 0 
  sd152 0.2 0.4 
  11.4 4.2 0.0 0.0 
  1.6 0 0 sd153 9.0 
  0.4 337.5 3.2 0.0 0.0 
  5.8 0 3 sd154 0.2 
  0.0 6.9 0.1 0.0 
  0.0 3.8 0 0 
  sd155 0.5 0.1 
  23.2 1.3 0.0 0.0 
  6.1 0 0 sd156 0.0 
  0.0 1.5 0.2 0.0 
  0.0 5.0 0 0 
  sd881 0.2 2.1 
  5.6 4.3 0.0 0.0 10.8 
  0 1 sd882 0.0 
  0.1 3.5 6.6 0.0 
  0.0 4.6 0 0 
  sd883 0.4 0.0 
  13.1 0.3 0.0 0.0 
  8.2 0 0 sd884 0.2 
  0.0 10.6 0.1 0.0 
  0.0 2.5 0 0 
  sd885 0.3 0.0 
  21.9 0.0 0.0 0.0 
  1.6 0 0 sd886 2.1 
  7.6 32.9 64.1 0.0 0.0 
  5.0 0 2 sd887 0.5 
  0.7 26.1 15.9 0.0 0.0 
  4.7 0 0 sd888 0.5 
  0.1 25.0 1.7 0.0 0.0 
  15.5 0 1 sd889 0.5 
  0.1 28.0 1.1 0.0 
  0.0 7.9 0 0 
  sd890 0.7 0.4 
  31.2 4.1 0.0 0.0 
  5.2 0 0 sd891 0.7

Re: Unix-script

2001-08-29 Thread Stephane Faroult


[EMAIL PROTECTED] wrote:
 
 Hallo,
 
 Can anyone give me an eaxmple of a iunix script, which checks if the file in 
unixsystem exists
 and if it does then it runs th esqlloader script, which loads data into a database 
table.?
 Thanks in advance.
 
 Roland
 

There is a script named upload.ksh on the Oriole site which does more
than this (it has been written to run a number of loads in parallel, and
to work with a matching download.ksh). You may find it a bit hard to
swallow if you are still struggling with script programming, but it
contains bits which will certainly be of interest to you, such as
extensive error checking, rebuilding of invalidated indexes if a direct
load fails and automated restart of the load in conventional mode, etc.
--
Regards,

  Stephane Faroult
  Oriole Corporation
--
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  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: Rename Constraint

2001-08-29 Thread Mark Leith


Hamid,

Check this out:

http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci759997,00.html

HTH

Mark

-Original Message-
Sent: Tuesday, August 28, 2001 22:24
To: Multiple recipients of list ORACLE-L


Hi all,

Is any body know what's the easiet way to rename a constraint name i don't
want to use the names which generated by oracle like SYS_C006701 or some
thing like this.
Thanks in advance


Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hamid Alavi
  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: Mark Leith
  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 select and display 10 records at a time from a table using sql query

2001-08-29 Thread Jan Pruner


select * from ( select column1, column2 from my_table order by 1) where 
ROWNUM  11;

Look at manual how to use ROWNUM.
It's ease to make mistakes with it.

JP

Dne st 29. srpen 2001 10:55 jste napsal(a):
 Dear DBA Gurus,

   How do I select and display 10 records at a time from a table using sql
 query only?

 Thanks and Regards,

 Ranganath


 DISCLAIMER: This correspondence is confidential and intended for the named
 recipient(s) only. If you are not the named recipient and receive this
 correspondence in error, you must not copy, distribute or take any action
 in reliance on it and you should delete it from your system and notify the
 sender immediately. Unless otherwise stated, any views or opinions
 expressed are solely those of the author and do not represent those of
 Subex Systems Limited.

 www.subexgroup.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  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).

rman restore question

2001-08-29 Thread Malik, Fawzia



Hi,

If I need to do an rman restore to another server, do the filesystems need
to be a replica of the original??? Is it possible to restore to different
disks??
Any help would be greatly appreciated!!

Rgds

FAwzia


This message is confidential and is intended for the addressee only; unless clearly 
stated that this disclaimer should not apply, this e-mail is not intended to create 
legally
 binding commitments on behalf of any company in the British Interactive Broadcasting 
Holding Limited group, nor do its contents reflect the corporate views or policies of 
any 
such company. Any unauthorised disclosure, use or dissemination, either whole or 
partial, is prohibited. If you are not the intended recipient of the message, please 
notify 
the sender immediately.

RE: How to select and display 10 records at a time from a table u

Title: RE: How to select and display 10 records at a time from a table using sql query





If you are talking of only sql query, then it not feasible to show 10 records at a time and then wait for user to press a key to show the next ten records (if that is what you mean). You may use sql*plus and set pagesize to 10 and pause on to see 10 records at a time.

If you meant to see only 10 records from your select, use rownum. 


rgds
amar


-Original Message-
From: Ranganath K [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 12:55 PM
To: Multiple recipients of list ORACLE-L
Subject: How to select and display 10 records at a time from a table
using sql query



Dear DBA Gurus,


 How do I select and display 10 records at a time from a table using sql
query only?


Thanks and Regards,


Ranganath



DISCLAIMER: This correspondence is confidential and intended for the named
recipient(s) only. If you are not the named recipient and receive this
correspondence in error, you must not copy, distribute or take any action in
reliance on it and you should delete it from your system and notify the
sender immediately. Unless otherwise stated, any views or opinions expressed
are solely those of the author and do not represent those of Subex Systems
Limited.


www.subexgroup.com



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ranganath K
 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 select and display 10 records at a time from a table u

2001-08-29 Thread Jenner Mike


set pagesize 10
set pause on
select ...
enter return to display next page of results.

- Mike.

-Original Message-
Sent: 29 August 2001 09:55
To: Multiple recipients of list ORACLE-L
using sql query


Dear DBA Gurus,

How do I select and display 10 records at a time from a table using
sql
query only?

Thanks and Regards,

Ranganath


DISCLAIMER: This correspondence is confidential and intended for the named
recipient(s) only. If you are not the named recipient and receive this
correspondence in error, you must not copy, distribute or take any action in
reliance on it and you should delete it from your system and notify the
sender immediately. Unless otherwise stated, any views or opinions expressed
are solely those of the author and do not represent those of Subex Systems
Limited.

www.subexgroup.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ranganath K
  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: Jenner Mike
  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: !! Very important Oracle-L message !!

2001-08-29 Thread Jenner Mike




-Original Message-
Sent: 28 August 2001 23:29
To: Multiple recipients of list ORACLE-L



Ok, now that I have your attention, please read the following message from
Bruce Bergman,
owner of fatcity.com.  It concerns the future of this list.

Please read the entire message before replying.

Thank you.

Jared Still  ( List Owner )


---

Hello ORACLE-L list members --

I would like to take a few minutes of your time for a State of the Union
address, if you can call it that.  This is a rather serious message, and I
request that you take the time to read this message entirely.  I've got a
problem that needs resolution this week, and I'm hoping you folks can help
me come to a conclusion.  This message turned out to be fairly
long-winded, so please excuse me for that. :-)

Fat City (fatcity.com) is my company, and I am the provider of the list
services that you receive ORACLE-L through.  I've been hosting Internet
mailing lists for over 10 years, and carry quite a few lists, including a
big selection of Oracle-related lists (14, in fact).  Fat City has always
been a labor of love for me.  Over the years it has rarely generated any
income at all, and it usually does not cover my expenses -- most of the
time
it is a monthly loss for me.  The vast majority of my 60+ mailing lists
have
been hosted for free, at my expense (as is the ORACLE-L list, for example).
Yet I have absorbed these costs because I enjoy hosting discussion lists
and I know a lot of lists can't afford to pay for quality service.

I am soon to be one of the Rhythms Orphans.  Rhythms, my DSL provider, has
gone bankrupt and will be out of business by 10-Sep-2001.  I need to find
another provider of high-speed Internet in order to continue operations.  I
am at the point of either folding shop completely and going out of business
myself, or trying to make Fat City a viable, money-making endeavor.  I need
to make this decision by this Friday (for financial and planning reasons).
After Friday, I am committed one way or the other.

My upstream ISP and I are on very good terms, and in fact, I've been a
customer of theirs since 1985!  As a result, they have graciously offered
to help me out of this situation at considerable expense to themselves.
I'm not at liberty to discuss the terms of the contract I would engage in
with them, but suffice to say that is one of those once-in-a-lifetime
opportunities that I'd be a fool to pass up.  I have this offer personally
from the President of that company, if I want it.  Simply said, my ability
to take them up on their offer and switch Fat City over to a dedicated T1
or
better solution revolves around being able to generate quite a bit of
additional
income per month, and very soon.  In an effort to be open and up-front with
you folks about this, I basically need to generate an additional $500 more
per
month. Right now that seems daunting, but I've been working hard to line up
that
additional income, and I believe I can do it.  Just not right away.  My
estimates are that it will take me four or five months to come up to that
level.  I need to get out there and sell website hosting and list hosting
packages, and get new customers.  That takes time, unfortunately.  I need a
buffer to enable me to get past this startup phase.

After some discussions with Jared (the list owner), and some encouragement
from him, I am coming to you to ask for you help in keeping Fat City
financially afloat until I can be self sufficient.  I'm not asking for a
specific dollar amount from anyone, nor am I *expecting* anything from you
folks.  But if it is within your power to contribute some money towards
this
end (and yes, I know these are hard financial times for everyone), I am
hoping you can help.  If I can get sufficient promise of funds that will
see
me through the next few months, I am willing to jump in with both feet and
make Fat City a viable business.  If it looks like the contributions are
not
sufficient to enable me to do that, I will cease operations within the next
45-60 days.

Let me be clear about a few things: If I *do* cease operations, I will give
all of my lists time to find new list providers, and will make every effort
to aid the shift over to the new provider, provide list dumps, archives,
mail forwarding, etc.  Even though Rhythms goes out of business on
10-Sep-2001, I have secured service until at least 10-Oct-2001 to enable
this to happen.  So don't worry about having to rush into your conversion
if
things don't work out.  I would also like to clearly state that this is not
some attempt to blackmail or coerce anyone into coming up with money.  This
will either succeed or fail based on what you folks can comfortably and
willingly contribute.  If I had the ability to cover this startup period
myself,
I would definitely do so.  If Fat City ultimately goes under, it wil NOT be
your fault, and I hold no one to blame.  That's just how the Internet cards
are right now.  I

Spooling output of a select statement to a file through stored procedure

2001-08-29 Thread Ranganath K


Dear DBA Gurus,

How do I spool output of a select statement to a file through stored
procedure.  The stored procedure should take the directory and path of the
file to be spooled to on the client machine.  I know we can do this using
UTL_FILE package.  But I don't want to write to a file in Oracle Database
server machine rather I want to write the output to a file in client
machine.  Please note that I want to do this through a Pl/Sql procedure or a
pl/sql program so that the procedure can be called from the front end which
is Java/C++.   How do I do this?  Any help in this regard will be duly
appreciated.

Thanks and Regards,

Ranganath


DISCLAIMER: This correspondence is confidential and intended for the named
recipient(s) only. If you are not the named recipient and receive this
correspondence in error, you must not copy, distribute or take any action in
reliance on it and you should delete it from your system and notify the
sender immediately. Unless otherwise stated, any views or opinions expressed
are solely those of the author and do not represent those of Subex Systems
Limited.

www.subexgroup.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ranganath K
  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: Burning game CD's


We wuvs you Mladen, you ickle fwuffy bunny... :0)

g


-Original Message-
Sent: Tuesday, August 28, 2001 8:34 PM
To: Multiple recipients of list ORACLE-L


Wow! I have fans! This will further inflate my already healthy ego
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Guy Hammond
  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: DBMS_JOB Help


Hi,

You need to find the job number, then use DBMS_JOB.REMOVE(). This is all
in the documentation:

http://technet.oracle.com/doc/oracle8i_816/server.816/a76956/jobq.htm#10
57

Note that the job will complete before being removed from the queue.

g


-Original Message-
Sent: Tuesday, August 28, 2001 7:21 AM
To: Multiple recipients of list ORACLE-L


Hi All,

Can Anyone tell me how to stop a background job initiated through a
DBMS_JOB package when it is no longer required?

Thanks in advance.

Regards
Sundar

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rangachari Sundar
  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: Guy Hammond
  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).

Fwd: Re: How to select and display 10 records at a time from a table using sql query

2001-08-29 Thread Jan Pruner


Does anybody know how to do it better way?

 But this will return only the first ten rows not subsequent sets. How do I
 display rows from 11 to 20, 21 to 30 and so on?

ROWNUM is counting output tuples. You cannot use ROWNUM  10.

I think you have to order select by your primary key, make filter based on
your primary key and  take only first 10 tuples using ROWNUM.

JP
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jan Pruner
 Sent: Wednesday, August 29, 2001 4:01 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: How to select and display 10 records at a time from a table
 using sql query


 select * from ( select column1, column2 from my_table order by 1) where
 ROWNUM  11;

 Look at manual how to use ROWNUM.
 It's ease to make mistakes with it.

 JP

 Dne st 29. srpen 2001 10:55 jste napsal(a):
  Dear DBA Gurus,
 
  How do I select and display 10 records at a time from a table using sql
  query only?
 
  Thanks and Regards,
 
  Ranganath
 
 
  DISCLAIMER: This correspondence is confidential and intended for the
  named recipient(s) only. If you are not the named recipient and receive
  this correspondence in error, you must not copy, distribute or take any
  action in reliance on it and you should delete it from your system and
  notify the sender immediately. Unless otherwise stated, any views or
  opinions expressed are solely those of the author and do not represent
  those of Subex Systems Limited.
 
  www.subexgroup.com

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Jan Pruner
   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).


 DISCLAIMER: This correspondence is confidential and intended for the named
 recipient(s) only. If you are not the named recipient and receive this
 correspondence in error, you must not copy, distribute or take any action
 in reliance on it and you should delete it from your system and notify the
 sender immediately. Unless otherwise stated, any views or opinions
 expressed are solely those of the author and do not represent those of
 Subex Systems Limited.

 www.subexgroup.com

---
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  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: HP-UX

2001-08-29 Thread Stuart Graham


Ed, the real problem is it's not just this patch... there is a list of 10-15
patches which all give this error message. I am tempted to just go ahead and
try the install anyway, how seriously could things go wrong :-)


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, August 28, 2001 9:10 PM


 This is just a stab in the dark:

 I have never used a \ when installing patches so try running the command
on
 a single line
 like this:

 # swinstall -x autoreboot=true -x patch_match_target=true -s
 /tmp/PHCO_17058.depot

 If that doesn't work and since this seems to be a SAM patch, do you have
sam
 installed and working?
 Try running sam from the command line and see if the system administrator
 tool works.
 Otherwise I dunno. This might fail if a superseding patch was already
 installed.

 PHCO_17058 has been replaced by PHCO_23876 (Latest Superseding Patch) and
 PHCO_21187 (Best Available Patch). Try doing:

 swlist | grep PHCO

 to see if any of these later patches are already installed.

 You might want to install one of the later patches. I don't think anyone
 comes out with
 so many patch udates like HP-UX. Anytime you see documentation that says
you
 need to install a certain patch, that patch will have been supersceeded 2
or
 more times by the time you read the documentation so don't be worried
about
 trying to install one of the supersceeding patches.


 HTH
 Ed

 -Original Message-
 Sent: Tuesday, August 28, 2001 12:27 PM
 To: Multiple recipients of list ORACLE-L


 Hi all, this is slightly off topic, but I am trying to install 9i database
 on an HP-UX 11.00 box.

 I have v.v.v.v. little experience on HP-UX. This is only a test box, but
 going through ORACLE's install guide, it tells me I need to install
various
 HP-UX patches using swinstall.

 Many of the patches I try to install are erroring out...

 I run the command

 # swinstall -x autoreboot=true -x patch_match_target=true \

  -s /tmp/PHCO_17058.depot

 and get the following output:

 ===  08/28/01 16:14:35 BST  BEGIN swinstall SESSION (non-interactive)

  * Session started for user root@ham1.

 * Beginning Selection

 * Target connection succeeded for ham1:/.
 NOTE:The patch match operation failed to find patches for target
 software on ham1 which passed the filter.
 NOTE:Cannot continue the swinstall task.

 ===  08/28/01 16:14:50 BST  END swinstall SESSION (non-interactive)


 Does this mean I don't need these patches??

 TIA,

 Stuart



 * * * * * Freedom of Information Act Notice * * * * *
 The information in this email is subject to the record protection mandated
 by 5 United States Code 552(b)(4) and relevant judicial opinions.
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Sherman, Edward
   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: Stuart Graham
  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: rman restore question


Yes, you can lo+ok at note 73974.1on Metalink to find out how to put the
datafiles in different places in the copy database. This note tells you
exactly how to do it, but when you 'switch' that datafiles you have to
repeat the set newname... command and then switch each individual file.

HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 29, 2001 6:00 AM



 Hi,

 If I need to do an rman restore to another server, do the filesystems need
 to be a replica of the original??? Is it possible to restore to different
 disks??
 Any help would be greatly appreciated!!

 Rgds

 FAwzia


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  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: Tablespace layout

2001-08-29 Thread Cherie_Machler



Don,

By uniform extents, do you mean all extents in the same tablespace being
the same size?   Or do you mean having
a choice of say three different sizes in on tablespace but sticking to
those sizes?   That seems to be the crux of
the disagreement amongst our team.

Thanks for your comprehensive reply.

Cherie


   

Don Granaman 

granaman@home   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]   
.comcc:   

Sent by: Subject: Re: Tablespace layout

[EMAIL PROTECTED] 

om 

   

   

08/29/01 02:10 

AM 

Please respond 

to ORACLE-L

   

   





There is no advantage at all in making extent sizes a function of
db_block_buffers.

I agree, to a certain extent (no pun intended), with the idea of using
dedicated tablespaces.  I prefer to use dedicated tablespaces for all
significantly large tables, where the value for significantly large is
subjective.  For example, in a very critical 200 GB OLTP database, it might
mean dedicated tablespaces for tables of 200 MB or larger, a few
tablespaces - with uniform extent sizes - for smaller tables, and dedicated
tablespaces - also with uniform extent sizes - for indexes on larger
tables.
For example, ACCT_DATA, ACCT_INDX, CUST_DATA, CUST_INDX, ORDR_DATA,
ORDR_INDX, STAT_DATA, STAT_INDX, etc.  Another consideration is in how the
contents of the tablespace are used.  STAT_DATA, for example, might be
reserved for largely static tables.  There might be another tablespace for
similarly sized tables that are very volatile.

In general, my main considerations are:

Object size
uniform extents - ironclad rule for everything except SYSTEM, in all
but
most rare circumstances
only a few different extent sizes for all app data and indexes in the
entire database
ignore the multiple extents kills performance myth (but keep it
reasonable!)

Volatility
read-only data?
objects continually dropped/truncated and recreated/reloaded
intensely transactional?
 etc...

I/O distribution
a single non-dedicated tablespace should not contain objects likely to
be in contention
separate indexes and data (I/O effect is debatable, but index rebuilds,
etc. favor)
tablespace design so as to support reasonably even I/O distribution
across disks/stripe sets
ability to (relatively) easily move datafiles to rebalance I/O

Recoverability
Preference for many tablespaces over very large multi-table tablespaces
Preference for more smaller datafiles over very large datafiles (files

2 GB are very rarely needed)

Partitioning
For large partitioned objects - a tablespace for each partition
Rolling temporal partitions - as above.  Age off or move data by
partition exchange

Transportable tablespaces
What, if anything , needs to be moved? (e.g to a warehouse staging
area)
At what frequency / data volume?

Parallel server
Access patterns, PCM lock allocation (pre-9i at least), etc.

This works best with something like only three or four different extent
sizes for everything - except perhaps rollback, system, and temp, and
perhaps only three or four different datafile sizes for everything except
perhaps control files and redo logs.

The above is an off the top of the head list.  I don't pretend that it is
comprehensive.  However, it might generate some interesting discussion.  It
seems that space management is sometimes almost a religious topic.  I
converted to the uniform extents philosophy early - about 1990 - and
confess to being an evangelist.

-Don

RE: RMAN tuning

2001-08-29 Thread Mercadante, Thomas F


Michael,

You might look at the BLKSIZE parameter.  I did some basic tests using NT
and the EDM client, and found that setting the BLKSIZE to 2 Meg was the
fastest for my installation.  I think the default is 64k.

You set the parameter like:

allocate channel d2 type 'SBT_TAPE' parms 'BLKSIZE=2097152';

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, August 28, 2001 9:26 PM
To: Multiple recipients of list ORACLE-L



Hi All,

I use RMAN to do a full backup of 120G database while the database is up
running. It takes around 6 hours to finish. I have 61 data files and
manually allocate 6 channels. For all the RMAN parameters such as
FILESPERSET, I take the default.

Does anybody there know how to maximize the throughput?

Thanks,

Michael 




This e-mail contains privileged attorney-client communications and/or
confidential information, and is only for the use by the intended recipient.
Receipt by an unintended recipient does not constitute a waiver of any
applicable privilege.

Reading, disclosure, discussion, dissemination, distribution or copying of
this information by anyone other than the intended recipient or his or her
employees or agents is strictly prohibited.  If you have received this
communication in error, please immediately notify us and delete the original
material from your computer.

Sempra Energy Trading Corp. (SET) is not the same company as SDGE or
SoCalGas, the utilities owned by SET's parent company.  SET is not regulated
by the California Public Utilities Commission and you do not have to buy
SET's products and services to continue to receive quality regulated service
from the utilities.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Xin \Michael\ Wu
  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: Mercadante, Thomas F
  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: conversion from public to private synonym

Title: RE: conversion from public to private synonym





A private synonym cannot have the same name as the object. You will have to change dependent code if your public synonym name was same as the object name. 

rgds
amar


-Original Message-
From: Miller, Jay [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 1:46 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: conversion from public to private synonym



Actually, it's even easier. You can create the private synonym (which will
then take precedence over the public synonym when logged in as the synonym
owner) and then drop the public synonym. Users wouldn't even notice any
change.


Jay Miller


-Original Message-
Sent: Tuesday, August 28, 2001 5:18 PM
To: Multiple recipients of list ORACLE-L



THE FOLLOWING IS A JOKE, KIDDIES, DONT TRY THIS AT HOME(OR WORK)


update sys.syn$ set type = 'PRIVATE' where name = 'SYNONYM NAME';



you can't u must drop and recreate.


joe
Seema Singh wrote:
 
 Hi
 how to change from public synonym to private synonym without droping the
 synonym?
 thanks
 -Seema
 
 _
 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: Seema Singh
 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 :)
IM: n8xcthome or joen8xct
-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
 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).

results of analyze


Good morning all,

Someone asked me where the results of analying tables and indexes goes.  Can
anyone tell me what table(s) holds the statistics generated.

Thanks,
Ruth B. Gramolini
ORACLE  DB2  DBA
VT Dept. of Taxes
ph# 802.828.5708
fax# 802.828..3754
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  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: Tablespace layout

2001-08-29 Thread Cherie_Machler



Lisa,

I have a copy of the paper you refer to and have read it a couple of times.
We've gone over this issue many times in our team but our other two DBAs
remain unconvinced.   Perhaps I need to actually give them a copy of
the paper.

As I said, the crux of the issue is whether we should only have one extent
size per tablespace or allow different extent sizes per tablespace, as long
as they are all multiples of each other.   Over time, we've gotten so that
we're
in the later situation and it's getting  unmanageable.  However, I just
can't
convince these two and they keep changing the extent sizes in the
tablespaces
so there are more and more different sizes.I guess I'm looking for fuel
to convince them with, if there is any.

As for the partitions, I'm leaning towards putting the fact table that we
will be dropping
old partitions off of into a single tablespace per partition.   The other
partitioned tables,
I'm thinking about leaving in the regular tablespaces where they are
currently located.
They are currently alternated between data01 and data02 as you said.

Thanks for your reply,

Cherie


   
   
Koivu, Lisa  
   
lisa.koivu@efair   To: '[EMAIL PROTECTED]' 
[EMAIL PROTECTED],  
field.com   '[EMAIL PROTECTED]' 
[EMAIL PROTECTED]  
cc:
   
08/28/01 03:05 PM   Subject: RE: Tablespace layout 
   
   
   
   
   




Well Satar you didn't even read Cherie's email.


Way back before I took that db to the tablespace layout you refer to
(straight out of HOw to Stop Defragmenting and Start Living white paper) I
had created a separate tablespace for each partition.  It was an awful pain
back then and the number of tablespaces I had was ridiculous.  I can see
your point with mttr  and keeping your tablespaces fairly small in
comparison to what it's become.  I guess it's a tradeoff with pros and cons
either way.


However, I suggest you take that paper (above) and throw it their faces.  I
disagree about different sized extents in the same tablespace vehemently.
I think they should be uniform, period, for the same reason you state - if
disk is so precious, then use it wisely !!  Plus, when your partition
starts looking for another 100MB extent, you are out of luck.


  -- Or should I just leave them all in the same tablespaces as
 non-partitioned tables?


What's your feeling on partitioning?  I think if you are dropping data
monthly, use partitions wherever you can.  That way you are more assured of
reusing your disk - however, then you are looking at a different tablespace
per partition.


I believe at one point I had 2-3 partitions in each tablespace, rotating
them (part1 in ts1, part2 in ts2, part3 in ts1, part4 in ts2, etc.)  Maybe
that will provide the compromise in functionality, disk space management
and recoverability you seek.


I do know your pain.  Good Luck.


Lisa Koivu
Certified Monkey and DBA
Ft. Lauderdale, FL, USA







 -Original Message-
 From:   Satar Naghshineh
 [SMTP:[EMAIL PROTECTED]]
 Sent:   Tuesday, August 28, 2001 4:30 PM
 To: Multiple recipients of list ORACLE-L
 Subject:RE: Tablespace layout


 Hi Cherie,


 Just shove all your data on a RAID 5 (great for data Warehouses) and
 forget about it. If that is not possible, then stick with what your
 DBA team has stated about everything being ok as long as the extents
 are multiples of one another.


 Regards,
 Satar Naghshineh





 -Original Message-
 From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
 Sent:   Tuesday, August 28, 2001 7:27 PM
 To: Multiple recipients of list ORACLE-L
 Subject:    Tablespace layout





 I've been thinking a lot about our tablespace layout for our
 data warehouse.  Our warehouse is approaching 200Gig
 and is almost out of space on disk.  I'm getting another 75 Gig
 this weekend and am trying to plan the best use for that 75Gig.


 Our current data tablespace layout is that we have two tablespaces
 for small, medium, and large data tables and the same for indexes.
 So it's something like this:


 SM_DATA01
 SM_DATA02
 MED_DATA01
 MED_DATA02
 LG_DATA01
 LG_DATA02
 SM_IDX01
 SM_IDX02
 MED_IDX01
 MED_IDX02
 LG_IDX01

RE: Fwd: Re: How to select and display 10 records at a time from a table

2001-08-29 Thread Stephane Faroult



 
 Does anybody know how to do it better way?
 

You can do it (under SQL*Plus) by running

   @next10ini

then
   @next10
and then
   /
repetitively, where next10ini.sql is :

--
--   next10ini.sql
--
--   To be called ONCE before calling repetitively next10.sql
--   (to be called each time you want to reset everything)
--
--   If there is an ORDER BY then you must
--   store new_value for each column in the
--   ORDER BY.
--   If there is none, use this :
--
-- column rwid noprint new_value last_row
--
--and write the query in next10.sql as:
--
--   select * 
--   from (select rowid rwid, table_name
-- from dictionary
-- where rowid  'last_row')
--   where rownum  11;
--
--   (note that it would not work with this example because ROWIDs
--cannot be used with the DICTIONARY view)
--
column table_name new_value last_row
--
--   Initialize with a value which is smaller
--   than the smallest value you want to return
--
define last_row = '0'
set verify off

and next10.sql is :

--
--  next10.sql
--
--To be called repetitively.
--
select * 
from (select table_name
  from dictionary
  where table_name  'last_row'
  order by table_name) 
where rownum  11
/

but it is not madly efficient. The only proper way is to open a cursor
and fetch by batches of 10 rows - or what has been suggested, setting
the pagesize to 10 and pause !


  But this will return only the first ten rows not subsequent sets. How do I
  display rows from 11 to 20, 21 to 30 and so on?
 
 ROWNUM is counting output tuples. You cannot use ROWNUM  10.
 
 I think you have to order select by your primary key, make filter based on
 your primary key and  take only first 10 tuples using ROWNUM.
 
 JP

-- 
Regards,

  Stephane Faroult
  email: [EMAIL PROTECTED] 
  Oriole Corporation
  Voice:  +44  (0) 7050-696-269 
  Fax:+44  (0) 7050-696-449 
  Performance Tools  Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  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: HP-UX

2001-08-29 Thread Jonathan Lewis


Stuart,

I'm not an expert in these matters, but I've just
installed hp-ux 64-bit using the June release,
and including the three large-scale quality
patches.

During installation I noted that swinstall was
giving me message like:
298 files skipped out of 673

I think this meant it was simply not installing
patches which were not relevant to my particular
environment, and I suspect that your messages
mean the same.

I prefer with swinstall to invoke the product for
manual control, rather than using the command
line. i.e.
swinstall
then fill in the screen which specifies the depot
(the PHCO_17058.depot file in a local directory, then
choose the install action).

After the analyze stage you get messages about
errors and warnings and files skipped - this may be
more helpful (or perhaps comforting) than the summary
message you are getting at the end.


Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 29 August 2001 13:07


|Ed, the real problem is it's not just this patch... there is a list
of 10-15
|patches which all give this error message. I am tempted to just go
ahead and
|try the install anyway, how seriously could things go wrong :-)
|
|
|- Original Message -
|To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
|Sent: Tuesday, August 28, 2001 9:10 PM
|
|
| This is just a stab in the dark:
|
| I have never used a \ when installing patches so try running the
command
|on
| a single line
| like this:
|
| # swinstall -x autoreboot=true -x patch_match_target=true -s
| /tmp/PHCO_17058.depot
|
| If that doesn't work and since this seems to be a SAM patch, do you
have
|sam
| installed and working?
| Try running sam from the command line and see if the system
administrator
| tool works.
| Otherwise I dunno. This might fail if a superseding patch was
already
| installed.
|
| PHCO_17058 has been replaced by PHCO_23876 (Latest Superseding
Patch) and
| PHCO_21187 (Best Available Patch). Try doing:
|
| swlist | grep PHCO
|
| to see if any of these later patches are already installed.
|
| You might want to install one of the later patches. I don't think
anyone
| comes out with
| so many patch udates like HP-UX. Anytime you see documentation that
says
|you
| need to install a certain patch, that patch will have been
supersceeded 2
|or
| more times by the time you read the documentation so don't be
worried
|about
| trying to install one of the supersceeding patches.
|
|
| HTH
| Ed
|
| -Original Message-
| Sent: Tuesday, August 28, 2001 12:27 PM
| To: Multiple recipients of list ORACLE-L
|
|
| Hi all, this is slightly off topic, but I am trying to install 9i
database
| on an HP-UX 11.00 box.
|
| I have v.v.v.v. little experience on HP-UX. This is only a test
box, but
| going through ORACLE's install guide, it tells me I need to install
|various
| HP-UX patches using swinstall.
|
| Many of the patches I try to install are erroring out...
|
| I run the command
|
| # swinstall -x autoreboot=true -x patch_match_target=true \
|
|  -s /tmp/PHCO_17058.depot
|
| and get the following output:
|
| ===  08/28/01 16:14:35 BST  BEGIN swinstall SESSION
(non-interactive)
|
|  * Session started for user root@ham1.
|
| * Beginning Selection
|
| * Target connection succeeded for ham1:/.
| NOTE:The patch match operation failed to find patches for
target
| software on ham1 which passed the filter.
| NOTE:Cannot continue the swinstall task.
|
| ===  08/28/01 16:14:50 BST  END swinstall SESSION
(non-interactive)
|
|
| Does this mean I don't need these patches??
|
| TIA,
|
| Stuart
|

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan 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).

Drop Recreate table or alter table drop column. Which is

2001-08-29 Thread CHAN Chor Ling Catherine (CSC)


Hi Gurus,

If the table is empty  U need to drop one of the columns, do you 
1) alter table tab_name drop column col_name or 
2) drop  recreate table

I use option (1). Which is a better choice ?  TIA

Regds,
New Bee

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: Re[2]: Preventing logins from applications

Title: RE: Re[2]: Preventing logins from applications





In oracle 8i, you may take a look at product_profile table. You can prevent users from using sqlplus by adding the following in this table:

INSERT INTO Product_profile (product, userid, attribute, char_value)
VALUES ('SQL*Plus','AMAR','SELECT','DISABLED');


Dig into this, you may be able to prevent other apps from accessing accordingly.


rgds
amar


-Original Message-
From: John Lewis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 11:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re[2]: Preventing logins from applications



Perhaps a tack that explains to management the threat (real or imagined) of
un-authorized program access. Couch it in a
dollars-lost-from-fixing-problems sense. This usually gets their attention.


-Original Message-
Sent: Tuesday, August 28, 2001 11:33 AM
To: Multiple recipients of list ORACLE-L



Charlie,


 That's all well and good, my try at it was on V7, but in my case the
users
revolted to upper management. And you know where the manure landed!!!


Dick Goulet


Reply Separator
Author: Charlie Mengler [EMAIL PROTECTED]
Date: 8/28/2001 8:16 AM


This can be accomplished by creating a login trigger that checks
the PROGRAM name within V$SESSION. You can create a table that
contains whitelisted program names  simply terminate any session
that uses a program that does not exist within your authorized
list of programs.


Denham Eva wrote:
 
 Hi Gurus
 
 Has anyone ever had to prevent users from accessing the Database from
other
 applications other than those sanctioned by the company.
 ie prevent users accessing the database using Microsoft's Access and yet
 still be able to access via the company application which also uses ODBC.
 OR preventing users accessing the DB via sqlplus but still through the
app.
 
 I would appreciate any knowledge that can be shared on this topic.
 Many Thanks
 Denham
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Denham Eva
 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).


-- 
Charlie Mengler Maintenance Warehouse 
[EMAIL PROTECTED] 10641 Scripps Summit Ct.
858-831-2229 .NET? Not yet! San Diego, CA 92131
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
 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: 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).

RE: results of analyze

2001-08-29 Thread Paul Baumgartel


Hi Ruth.

{user|all|dba}_tables, {user|all|dba}_columns, {user|all|dba}_indexes

Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, August 29, 2001 9:41 AM
To: Multiple recipients of list ORACLE-L


Good morning all,

Someone asked me where the results of analying tables and indexes goes.  Can
anyone tell me what table(s) holds the statistics generated.

Thanks,
Ruth B. Gramolini
ORACLE  DB2  DBA
VT Dept. of Taxes
ph# 802.828.5708
fax# 802.828..3754
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  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: Paul Baumgartel
  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: results of analyze

2001-08-29 Thread Christopher Spence


XXX_TABLES, XXX_INDEXES, you can read the statistics from these views

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Wednesday, August 29, 2001 9:41 AM
To: Multiple recipients of list ORACLE-L


Good morning all,

Someone asked me where the results of analying tables and indexes goes.  Can
anyone tell me what table(s) holds the statistics generated.

Thanks,
Ruth B. Gramolini
ORACLE  DB2  DBA
VT Dept. of Taxes
ph# 802.828.5708
fax# 802.828..3754
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  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: 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: results of analyze

2001-08-29 Thread Deshpande, Kirti


Ruth,
  
  Those are in sys.tab$ and sys.ind$. 
 
Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

 -Original Message-
 From: Ruth Gramolini [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, August 29, 2001 8:41 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  results of analyze
 
 Good morning all,
 
 Someone asked me where the results of analying tables and indexes goes.
 Can
 anyone tell me what table(s) holds the statistics generated.
 
 Thanks,
 Ruth B. Gramolini
 ORACLE  DB2  DBA
 VT Dept. of Taxes
 ph# 802.828.5708
 fax# 802.828..3754
 [EMAIL PROTECTED]
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Ruth Gramolini
   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: Deshpande, Kirti
  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: Tablespace layout

2001-08-29 Thread Ron Rogers


Cherie,
 I created a test database for our developers that contains all of the production 
tables and data. The production is Oracle 7.3.4 on Novell and the test is 8.1.7 on 
Linux. Being that I am limited to the number if disks that I have available and I 
needed to use all available space efficiently, I opted to use LMT for the data and 
indexes. Partitioning is used on the tables that contain a lot of data  and span a 
large date range 1993 to sysdate. Determining the size of the other tables and their 
time frame for usage I was able to determine the best uniform size for the LMT. All 
tables that are static and small reside in 1 table spaces determined by their usage( 
all of the time, infrequent). Tables that contain daily updated, weekly updated,and 
monthly updated are of different size and volume therefore the LMT extents were 
tailored differently. The large tables that contain current and historic data are 
partitioned by date range and have different LMT extents as needed. The time and 
effort spent in laying out the tablespaces and datafiles was well worth it. The free 
space is at a minimum and as the data grows or shrinks the extents are reused with the 
LMT and uniform sizing for each tablespace. The original database has 31 tablespaces 
with approx 200 tables. The test database has  153 tablespaces that handle the 200 
tables.The free space is considerably  less on the LMT uniform extent server as like 
size requirements are combined where ever possible. The LMT and partitioning has also 
allowed me to remove some views that joined current and historic tables to present to 
the user. Not using the view decreased data access time and allowed the use of the 
indexes on the partitions. The partitioned tablespaces are smaller as the data is 
broken down by year (Megs as compared to Gigs) as compared to current( 6mo) and 
historic (8 years). 
  I feel that if you have the option and the time to manage your tablespaces then you 
will have better control over your disk space. I know that it takes time to set 
everything up and get it implemented but your space usage and access time should 
improve noticeable.
ROR mª¿ªm

 [EMAIL PROTECTED] 08/28/01 02:26PM 

I've been thinking a lot about our tablespace layout for our
data warehouse.  Our warehouse is approaching 200Gig
and is almost out of space on disk.  I'm getting another 75 Gig
this weekend and am trying to plan the best use for that 75Gig.

Our current data tablespace layout is that we have two tablespaces
for small, medium, and large data tables and the same for indexes.
So it's something like this:

SM_DATA01
SM_DATA02
MED_DATA01
MED_DATA02
LG_DATA01
LG_DATA02
SM_IDX01
SM_IDX02
MED_IDX01
MED_IDX02
LG_IDX01
LG_IDX02

I think that theoretically, all of the tables in each of the tablespaces
were supposed to have the same sized extents when they were
originally created.  However, over time, there are multiple sizes
of extents in the large and medium tablespaces.  Even though we
show significant free space, it is fragmented and coalescing can
not put together enough contiguous space to reuse a lot of the available
space.

Our largest tables are partitioned.  However the partitions are not split
out into separate tablespaces but go into the same medium and large
tablespaces as non-partitioned tables.   Theoretically, I suppose that this
is not a problem if, when partitions are dropped every month, the resulting
space is reused 100%.  I'm not sure if it is.

Here is my question.  My DBA team members feel that it's fine to have
tables with a variety of extent sizes in the same tablespace as long as
they are all multiples of each other (50, 100, 400, 2000, etc.).   My
concern
is that this setup is fine when the smaller tables need to extend but when
the larger tables need to extend, they can't pull together enough
contiguous
space and I keep having to add more.   I'd prefer to have only one size of
extent in each tablespace and keep it very pure that way.   Then I know
every single extent can be reused.  So I am considering increasing the
number of tablespaces so we have something more like this:

1kdata
10kdata
100kdata
1mdata
10mdata
100mdata
1000mdata
1kidx
10kidx
100kidx
1midx
10midx
100midx
1000midx

I would also probably split them out into at least two tablespaces for each
level.
Maybe not for the smaller sizes, but for the larger sizes.

I have several issues I'm trying to keep in mind.  One is the ease of
maintenance
for initial creation and ongoing upkeep.   I don't want to have too many
tablespaces
if I don't need to.   Another issue is mean time to recover.   If we lose a
single tablespace,
I'd prefer to have to recover fewer files.  The maximum file size we are
using is 2Gig.
We need to keep our recovery time under four hours total.

Probably the biggest issue I'm facing now is the sheer size of the large
tablespaces.
They are so big and bulky that it's almost impossible to reorg them or even
just
clean them up.   I think that if I

MySQL anyone?

2001-08-29 Thread Gene Gurevich


Hi.

does anyone know anything about MySQL? I was assigned
to a pilot to see whether this is something my company
would want to use. Does anyone use it? Any good/bad
opinions? 

TIA

Gene

=


__
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: Gene Gurevich
  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: results of analyze

2001-08-29 Thread Mercadante, Thomas F


Ruth,

the results are stored in the USER_TABLES and USER_INDEXES views.
below are some of the columns that get populated when I issue the following
command:

dbms_stats.gather_table_stats('schemaname','tablename');

hope this helps

09:28:15 WTWD descr user_tables
 Name   
 ---
 NUM_ROWS   =
 BLOCKS =
 EMPTY_BLOCKS   =
 AVG_SPACE  =
 CHAIN_CNT  =
 AVG_ROW_LEN=
 AVG_SPACE_FREELIST_BLOCKS  =
 NUM_FREELIST_BLOCKS=
 SAMPLE_SIZE=
 LAST_ANALYZED  =

09:28:18 WTWD descr user_indexes
 Name   
 --
 BLEVEL =
 LEAF_BLOCKS=
 DISTINCT_KEYS  =
 AVG_LEAF_BLOCKS_PER_KEY=
 AVG_DATA_BLOCKS_PER_KEY=
 NUM_ROWS   =
 SAMPLE_SIZE=
 LAST_ANALYZED  =

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, August 29, 2001 9:41 AM
To: Multiple recipients of list ORACLE-L


Good morning all,

Someone asked me where the results of analying tables and indexes goes.  Can
anyone tell me what table(s) holds the statistics generated.

Thanks,
Ruth B. Gramolini
ORACLE  DB2  DBA
VT Dept. of Taxes
ph# 802.828.5708
fax# 802.828..3754
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  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: Mercadante, Thomas F
  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).

OCP Study Materials - Your Opinion

2001-08-29 Thread kjanusz


I found both of these OCP study materials on Amazon.com 
and would like your opinion of them.

OCP: Oracle8i DBA Cert. Kit: Study Guide
by Chip Dawes
Book and CDROM
from Sybex

OCP: Oracle8i DBA Virtual Test Center
from Sybex

Your comments will be very helpful.

Thanks,
Ken Janusz, CPIM
-- 
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).

financial problems with fatcity.com

2001-08-29 Thread Hillman, Alex


I think that much better than voluntary contributions will be some
s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I
am sure that
everybody working with Oracle and living in US or UK or other developed
country can afford such fees. We will not need to charge people from
developing countries - I am sure these subscription fees will generate more
than $500 per month.

Alex Hillman

-- 
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 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: results of analyze

2001-08-29 Thread Koivu, Lisa

Title: RE: results of analyze





Ruth, do you mean tables other than dba_indexes, dba_tables, dba_ind_partitions, dba_tab_partitions, etc., etc??


Here's a good one. The dba I worked with (certified, no experience) tried to tell me that when you analyze it adds columns to the table. Yea, Certification !!

Are you looking for something else, Ruth? 


Lisa


-Original Message-
From: Ruth Gramolini [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 9:41 AM
To: Multiple recipients of list ORACLE-L
Subject: results of analyze


Good morning all,


Someone asked me where the results of analying tables and indexes goes. Can
anyone tell me what table(s) holds the statistics generated.


Thanks,
Ruth B. Gramolini
ORACLE  DB2 DBA
VT Dept. of Taxes
ph# 802.828.5708
fax# 802.828..3754
[EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
 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: results of analyze

2001-08-29 Thread Jared Still



In addition the INDEX_STATS view will be populated by
the VALIDATE INDEX INDEX_NAME; command.

It will have a most one row in it, so you need to check 
it after each validate.

Jared

On Wednesday 29 August 2001 07:00, Paul Baumgartel wrote:
 Hi Ruth.

 {user|all|dba}_tables, {user|all|dba}_columns, {user|all|dba}_indexes

 Paul Baumgartel
 MortgageSight Holdings, LLC
 [EMAIL PROTECTED]


 -Original Message-
 Sent: Wednesday, August 29, 2001 9:41 AM
 To: Multiple recipients of list ORACLE-L


 Good morning all,

 Someone asked me where the results of analying tables and indexes goes. 
 Can anyone tell me what table(s) holds the statistics generated.

 Thanks,
 Ruth B. Gramolini
 ORACLE  DB2  DBA
 VT Dept. of Taxes
 ph# 802.828.5708
 fax# 802.828..3754
 [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  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).

alternative rows

2001-08-29 Thread Tatireddy, Shrinivas (MED, Keane)


Hi lists

can anybody post me to find alternative rows in a table.

1,3,5 ...

or 2,4,6 

srinivas
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tatireddy, Shrinivas (MED, Keane)
  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: Drop Recreate table or alter table drop column.

2001-08-29 Thread JOE TESTA




if you're using 8i, then option 1 is fine, if  8.1 then option 2 is 
your only choice.

joe [EMAIL PROTECTED] 08/29/01 10:21AM 
Hi Gurus,If the table is empty  U need to drop one 
of the columns, do you 1) alter table tab_name drop column col_name or 
2) drop  recreate tableI use option (1). Which is a better 
choice ? TIARegds,New Bee-- Please see the 
official ORACLE-L FAQ: http://www.orafaq.com-- Author: CHAN 
Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED]Fat City 
Network Services -- (858) 538-5051 FAX: (858) 
538-5051San Diego, California -- 
Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from). You mayalso send the HELP command for 
other information (like subscribing).

Re: results of analyze

2001-08-29 Thread nlzanen1



Hi


DBA_TABLES
DBA_INDEXES

ORACLE 8.0.5

Jack




Ruth Gramolini [EMAIL PROTECTED]@fatcity.com on 29-08-2001
15:40:33

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)

Good morning all,

Someone asked me where the results of analying tables and indexes goes.
Can
anyone tell me what table(s) holds the statistics generated.

Thanks,
Ruth B. Gramolini
ORACLE  DB2  DBA
VT Dept. of Taxes
ph# 802.828.5708
fax# 802.828..3754
[EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ruth Gramolini
  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).




=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst 
Young, niet toegestaan. Ernst  Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst  Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst  Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst  Young. Ernst  Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst  Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.

In carrying out its engagements, Ernst  Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of
these terms and conditions is available on request free of charge.
=





--
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: MySQL anyone?

2001-08-29 Thread Joe Raube


It depends on what you want to use it for.

See 
http://www.phpbuilder.com/columns/tim2705.php3?page=1print_mode=1

for one opinion.

-Joe

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 29, 2001 10:00 AM


 Hi.
 
 does anyone know anything about MySQL? I was assigned
 to a pilot to see whether this is something my company
 would want to use. Does anyone use it? Any good/bad
 opinions? 
 
 TIA
 
 Gene
 
 =
 
 
 __
 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: Gene Gurevich
   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!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Raube
  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: results of analyze



Thanks all, know I can at least give an intelligent anwer.  

Ruth

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  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: Drop Recreate table or alter table drop column. Which

2001-08-29 Thread Gogala, Mladen

In an 8i database, dropping a column is certainly preferred over a
rebuild, because if you drop  re-create the table, you have to re-create
all grants, indexes, triggers and constraints. Since the table is empty (you
said so) you will not fragment any data (row chaining and alike).

 -Original Message-
 From: CHAN Chor Ling Catherine (CSC) [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 29, 2001 10:21 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Drop  Recreate table or alter table drop 
 column. Which is 

 Hi Gurus,

 If the table is empty  U need to drop one of the columns, do you 
 1) alter table tab_name drop column col_name or 
 2) drop  recreate table

 I use option (1). Which is a better choice ?  TIA

 Regds,
 New Bee

 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: CHAN Chor Ling Catherine (CSC)
   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: Gogala, Mladen
  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: conversion from public to private synonym

2001-08-29 Thread Rachel Carmichael


a private synonym can certainly have the same name as the object does. 
Unless you mean that the same user owns the object AND the synonym. But in 
that case, why would you want a synonym.

In fact, I used to set up test environments this way. One schema owned the 
objects. I created public synonyms for those objects. The developers could 
create copies of those tables and grant access to each other (if several 
where working on the same project). Each developer would have his/her own 
private synonym that pointed to the other developer's object. When testing 
was done, we did not have to recode to get the correct table names in.




From: Amar Kumar Padhi [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: conversion from public to private synonym
Date: Wed, 29 Aug 2001 05:16:18 -0800

A private synonym cannot have the same name as the object. You will have to
change dependent code if your public synonym name was same as the object
name.

rgds
amar

-Original Message-
Sent: Wednesday, August 29, 2001 1:46 AM
To: Multiple recipients of list ORACLE-L


Actually, it's even easier.  You can create the private synonym (which will
then take precedence over the public synonym when logged in as the synonym
owner) and then drop the public synonym.  Users wouldn't even notice any
change.

Jay Miller

-Original Message-
Sent: Tuesday, August 28, 2001 5:18 PM
To: Multiple recipients of list ORACLE-L


THE FOLLOWING IS A JOKE, KIDDIES, DONT TRY THIS AT HOME(OR WORK)

update sys.syn$ set type = 'PRIVATE' where name = 'SYNONYM NAME';


you can't u must drop and recreate.

joe
Seema Singh wrote:
 
  Hi
  how to change from public synonym to private synonym without droping the
  synonym?
  thanks
  -Seema
 
  _
  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: Seema Singh
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 :)
IM: n8xcthome or joen8xct
--
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Miller, Jay
   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: Rachel Carmichael
  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).

An OPS tnsnames question

2001-08-29 Thread Andrey Bronfin


Dear list !
I've got an OPS database named OPS with 2 instances OPS1 and OPS2 .
I want the users to connect to OPS1 and ONLY if it is down , to connect to
OPS2.
It's Oracle 8.0.5.1 on NT4.

I put the following lines in clients' tnsnames.ora file :

OPS.world = (DESCRIPTION_LIST =
(DESCRIPTION = 
  (ADDRESS = (PROTOCOL = tcp) (HOST = DB1) (PORT = 1526))
  (CONNECT_DATA = (SID = OPS1))
)
(DESCRIPTION = 
  (ADDRESS = (PROTOCOL = tcp) (HOST = DB2) (PORT = 1526))
  (CONNECT_DATA = (SID = OPS2))
)
)

This works perfectly fine except for the case when OPS1 instance is down ,
but the listener is up.
Then clients try to connect to OPS1 and fail - Oracle not available .
When i bring the listener on OPS1 host down - everybody perfectly connect to
OPS2.

Is there a solution ?
Thanks a lot in advance !


DBAndrey

* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrey Bronfin
  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: 817 Intermedia on AIX

2001-08-29 Thread Mike J Kurth



You may want to connect as ctxsys and query the user_libraries view
to make sure the library paths are pointing to your new 8.1.7 Oracle_home.
Just a thought.



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mike J Kurth
  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: Drop Recreate table or alter table drop column.

2001-08-29 Thread Ron Rogers


New Bee,
If the table has had the permission granted to the users then it would be better to 
drop the column. If you drop the table and recreate then you have to regrant the 
permissions. Also your packages could very well be invalid if you drop the table and 
recreate.
ROR mª¿ªm

 [EMAIL PROTECTED] 08/29/01 10:21AM 
Hi Gurus,

If the table is empty  U need to drop one of the columns, do you 
1) alter table tab_name drop column col_name or 
2) drop  recreate table

I use option (1). Which is a better choice ?  TIA

Regds,
New Bee

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: CHAN Chor Ling Catherine (CSC)
  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: Ron Rogers
  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: RMAN tuning


Tom,
Does this only work for tape?

Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 29, 2001 9:10 AM


 Michael,

 You might look at the BLKSIZE parameter.  I did some basic tests using NT
 and the EDM client, and found that setting the BLKSIZE to 2 Meg was the
 fastest for my installation.  I think the default is 64k.

 You set the parameter like:

 allocate channel d2 type 'SBT_TAPE' parms 'BLKSIZE=2097152';

 Hope this helps.

 Tom Mercadante
 Oracle Certified Professional


 -Original Message-
 Sent: Tuesday, August 28, 2001 9:26 PM
 To: Multiple recipients of list ORACLE-L



 Hi All,

 I use RMAN to do a full backup of 120G database while the database is up
 running. It takes around 6 hours to finish. I have 61 data files and
 manually allocate 6 channels. For all the RMAN parameters such as
 FILESPERSET, I take the default.

 Does anybody there know how to maximize the throughput?

 Thanks,

 Michael





 This e-mail contains privileged attorney-client communications and/or
 confidential information, and is only for the use by the intended
recipient.
 Receipt by an unintended recipient does not constitute a waiver of any
 applicable privilege.

 Reading, disclosure, discussion, dissemination, distribution or copying of
 this information by anyone other than the intended recipient or his or her
 employees or agents is strictly prohibited.  If you have received this
 communication in error, please immediately notify us and delete the
original
 material from your computer.

 Sempra Energy Trading Corp. (SET) is not the same company as SDGE or
 SoCalGas, the utilities owned by SET's parent company.  SET is not
regulated
 by the California Public Utilities Commission and you do not have to buy
 SET's products and services to continue to receive quality regulated
service
 from the utilities.


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Xin \Michael\ Wu
   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: Mercadante, Thomas F
   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: Ruth Gramolini
  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).

Upgrade of database

2001-08-29 Thread Steven Hovington


Can anyone point me towards the documentation for upgrading Oracle 8i, from
8.1.6
to 8.1.7.

Thanks in advance

Steven H.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Hovington
  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: financial problems with fatcity.com

2001-08-29 Thread Farnsworth, Dave


Maybe Larry could spare a few bucks.  Heck, think of the amount of time that
this list saves Oracle support!

Dave

-Original Message-
Sent: Wednesday, August 29, 2001 10:48 AM
To: Multiple recipients of list ORACLE-L


How about Corporate Sponsorship?




-Original Message-
Sent: Wednesday, August 29, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L


I think that much better than voluntary contributions will be some
s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I
am sure that
everybody working with Oracle and living in US or UK or other developed
country can afford such fees. We will not need to charge people from
developing countries - I am sure these subscription fees will generate more
than $500 per month.

Alex Hillman

-- 
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 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: Haskins, Ed
  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: Farnsworth, Dave
  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: financial problems with fatcity.com

2001-08-29 Thread Robertson Lee - lerobe


Whats that first part of your domain address there Alex  :-)

Perhaps you could help the list out !! 

-Original Message-
Sent: 29 August 2001 16:16
To: Multiple recipients of list ORACLE-L


I think that much better than voluntary contributions will be some
s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I
am sure that
everybody working with Oracle and living in US or UK or other developed
country can afford such fees. We will not need to charge people from
developing countries - I am sure these subscription fees will generate more
than $500 per month.

Alex Hillman

-- 
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 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).


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  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: !! Very important Oracle-L message !!

2001-08-29 Thread DBarbour



I didn't put OT in the header because I think this is very on topic.  I
will be emailing Bruce to see what he needs, or feels is a fair
contribution for my participation in this list through the years.  I have
gained so much from the members of this list.  Without those who
participate, both past and present, I would never have progressed as far
along the DBA route as I have.  Ofttimes, I'll read about a problem someone
has posted here and, although I can't help them, I do copious research to
further my education and knowledge.  Many of these problems have
subsequently cropped up within my DB's, and I am much better prepared to
handle them as a result.  I also save, research, and test many of the
scripts posted here.  Some work, some don't, some can afford to be tweaked,
but playing with them has given me a deeper understanding of what goes into
being a DBA (plus I've now got a great toolkit - just need to learn PERL!).

I pay for my subscription to the daily newspaper.  This forum is at least
as valuable to me as the newspaper (I even get the comic section here).

There is a cost to the Internet - that's why many of us have jobs.  I urge
the members of this community to search their conciouses and give what they
can to help this forum prosper.

Someday I'd like to make it to OOW and meet some of you (heck, I've thought
about driving down to San Antonio just to meet Scott.  Does Mladen ever
leave his cave?)

Regards,

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

-- 
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: An OPS tnsnames question

2001-08-29 Thread claudio cutelli


try with:

OPS =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = tcp) (HOST = DB1) (PORT = 1526))
   (ADDRESS = (PROTOCOL = tcp) (HOST = DB2) (PORT = 1526))
)
(CONNECT_DATA = (SERVICE_NAME = OPS))
  )

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 29, 2001 5:15 PM


 Dear list !
 I've got an OPS database named OPS with 2 instances OPS1 and OPS2 .
 I want the users to connect to OPS1 and ONLY if it is down , to connect to
 OPS2.
 It's Oracle 8.0.5.1 on NT4.

 I put the following lines in clients' tnsnames.ora file :

 OPS.world = (DESCRIPTION_LIST =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = tcp) (HOST = DB1) (PORT = 1526))
   (CONNECT_DATA = (SID = OPS1))
 )
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = tcp) (HOST = DB2) (PORT = 1526))
   (CONNECT_DATA = (SID = OPS2))
 )
 )

 This works perfectly fine except for the case when OPS1 instance is down ,
 but the listener is up.
 Then clients try to connect to OPS1 and fail - Oracle not available .
 When i bring the listener on OPS1 host down - everybody perfectly connect
to
 OPS2.

 Is there a solution ?
 Thanks a lot in advance !


 DBAndrey

 * 03-9254520
 * 053-464562
 * mailto:[EMAIL PROTECTED]


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Andrey Bronfin
   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: claudio cutelli
  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: !! Very important Oracle-L message !!

2001-08-29 Thread Anjan Thakuria


Can we just start pledging ..We have got to keep this form going under. Ideas
.

Anjan

Jenner Mike wrote:

 -Original Message-
 Sent: 28 August 2001 23:29
 To: Multiple recipients of list ORACLE-L

 Ok, now that I have your attention, please read the following message from
 Bruce Bergman,
 owner of fatcity.com.  It concerns the future of this list.

 Please read the entire message before replying.

 Thank you.

 Jared Still  ( List Owner )

 ---

 Hello ORACLE-L list members --

 I would like to take a few minutes of your time for a State of the Union
 address, if you can call it that.  This is a rather serious message, and I
 request that you take the time to read this message entirely.  I've got a
 problem that needs resolution this week, and I'm hoping you folks can help
 me come to a conclusion.  This message turned out to be fairly
 long-winded, so please excuse me for that. :-)

 Fat City (fatcity.com) is my company, and I am the provider of the list
 services that you receive ORACLE-L through.  I've been hosting Internet
 mailing lists for over 10 years, and carry quite a few lists, including a
 big selection of Oracle-related lists (14, in fact).  Fat City has always
 been a labor of love for me.  Over the years it has rarely generated any
 income at all, and it usually does not cover my expenses -- most of the
 time
 it is a monthly loss for me.  The vast majority of my 60+ mailing lists
 have
 been hosted for free, at my expense (as is the ORACLE-L list, for example).
 Yet I have absorbed these costs because I enjoy hosting discussion lists
 and I know a lot of lists can't afford to pay for quality service.

 I am soon to be one of the Rhythms Orphans.  Rhythms, my DSL provider, has
 gone bankrupt and will be out of business by 10-Sep-2001.  I need to find
 another provider of high-speed Internet in order to continue operations.  I
 am at the point of either folding shop completely and going out of business
 myself, or trying to make Fat City a viable, money-making endeavor.  I need
 to make this decision by this Friday (for financial and planning reasons).
 After Friday, I am committed one way or the other.

 My upstream ISP and I are on very good terms, and in fact, I've been a
 customer of theirs since 1985!  As a result, they have graciously offered
 to help me out of this situation at considerable expense to themselves.
 I'm not at liberty to discuss the terms of the contract I would engage in
 with them, but suffice to say that is one of those once-in-a-lifetime
 opportunities that I'd be a fool to pass up.  I have this offer personally
 from the President of that company, if I want it.  Simply said, my ability
 to take them up on their offer and switch Fat City over to a dedicated T1
 or
 better solution revolves around being able to generate quite a bit of
 additional
 income per month, and very soon.  In an effort to be open and up-front with
 you folks about this, I basically need to generate an additional $500 more
 per
 month. Right now that seems daunting, but I've been working hard to line up
 that
 additional income, and I believe I can do it.  Just not right away.  My
 estimates are that it will take me four or five months to come up to that
 level.  I need to get out there and sell website hosting and list hosting
 packages, and get new customers.  That takes time, unfortunately.  I need a
 buffer to enable me to get past this startup phase.

 After some discussions with Jared (the list owner), and some encouragement
 from him, I am coming to you to ask for you help in keeping Fat City
 financially afloat until I can be self sufficient.  I'm not asking for a
 specific dollar amount from anyone, nor am I *expecting* anything from you
 folks.  But if it is within your power to contribute some money towards
 this
 end (and yes, I know these are hard financial times for everyone), I am
 hoping you can help.  If I can get sufficient promise of funds that will
 see
 me through the next few months, I am willing to jump in with both feet and
 make Fat City a viable business.  If it looks like the contributions are
 not
 sufficient to enable me to do that, I will cease operations within the next
 45-60 days.

 Let me be clear about a few things: If I *do* cease operations, I will give
 all of my lists time to find new list providers, and will make every effort
 to aid the shift over to the new provider, provide list dumps, archives,
 mail forwarding, etc.  Even though Rhythms goes out of business on
 10-Sep-2001, I have secured service until at least 10-Oct-2001 to enable
 this to happen.  So don't worry about having to rush into your conversion
 if
 things don't work out.  I would also like to clearly state that this is not
 some attempt to blackmail or coerce anyone into coming up with money.  This
 will either succeed or fail based on what you folks can comfortably and
 willingly contribute.  If I had the ability to cover this

help execution plan changes when using a dblink

2001-08-29 Thread Jeroen van Sluisdam


Hi,

We face the strange problem that an executionplan is changed recently
without
any reason. Now it runs with a full_table scan and it did not do so.
The query is executed  through a dblink and is part of a batch.

- nothing has been changed recently in the app everybody agrees on here,
- analyze runs each weekend and a select count(*) differs slightly between
num_rows in
  dba_tables for the specific table
- when executing the query manually in two parts the subquery first and  ten
the value returned
  hardcoded in the main-query it performs very good
- when I ask for an explain plan in the database the link points to the
explain plan says it uses an index

Details: oracle 7.3.4, hp-ux 10.20
Query:
select * from debtor_claims@deca_link
where debtor_claim_id =
(
select max(debtor_claim_id)
from debtor_claims@deca_link
where res_id = 1291 and
counter_booking_flag = 'N'
)

Tia,

Jeroen
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeroen van Sluisdam
  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: MySQL anyone?

2001-08-29 Thread Christopher Spence


My entire site (www.vampired.net) is mySQL driven, the articles, scripts,
all content is dynamic via PHP and mySQL.  
It is a great database if you are doing something like what I have done, but
if your building an application, it generally isn't a good choice.

It does not have transaction support, limited procedure I believe they have
now, no pk/fk, no locking, and no logging for recovery.  Although some of
these things are not needed in some projects, some are.

But it is VERY quick.

Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 



-Original Message-
Sent: Wednesday, August 29, 2001 10:00 AM
To: Multiple recipients of list ORACLE-L


Hi.

does anyone know anything about MySQL? I was assigned
to a pilot to see whether this is something my company
would want to use. Does anyone use it? Any good/bad
opinions? 

TIA

Gene

=


__
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: Gene Gurevich
  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: 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: HP-UX

2001-08-29 Thread Stuart Graham


Jonathan,

Thanks for the advice, it worked a treat... Used SWINSTALL interactively and
the error messages I then got told me that all the patches I was trying to
install had been superseded by other patches already on the system...

Thanks again...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 29, 2001 2:40 PM


 Stuart,

 I'm not an expert in these matters, but I've just
 installed hp-ux 64-bit using the June release,
 and including the three large-scale quality
 patches.

 During installation I noted that swinstall was
 giving me message like:
 298 files skipped out of 673

 I think this meant it was simply not installing
 patches which were not relevant to my particular
 environment, and I suspect that your messages
 mean the same.

 I prefer with swinstall to invoke the product for
 manual control, rather than using the command
 line. i.e.
 swinstall
 then fill in the screen which specifies the depot
 (the PHCO_17058.depot file in a local directory, then
 choose the install action).

 After the analyze stage you get messages about
 errors and warnings and files skipped - this may be
 more helpful (or perhaps comforting) than the summary
 message you are getting at the end.


 Jonathan Lewis
 http://www.jlcomp.demon.co.uk

 Host to The Co-Operative Oracle Users' FAQ
 http://www.jlcomp.demon.co.uk/faq/ind_faq.html

 Author of:
 Practical Oracle 8i: Building Efficient Databases

 Screen saver or Life saver: http://www.ud.com
 Use spare CPU to assist in cancer research.

 -Original Message-
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Date: 29 August 2001 13:07


 |Ed, the real problem is it's not just this patch... there is a list
 of 10-15
 |patches which all give this error message. I am tempted to just go
 ahead and
 |try the install anyway, how seriously could things go wrong :-)
 |
 |
 |- Original Message -
 |To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 |Sent: Tuesday, August 28, 2001 9:10 PM
 |
 |
 | This is just a stab in the dark:
 |
 | I have never used a \ when installing patches so try running the
 command
 |on
 | a single line
 | like this:
 |
 | # swinstall -x autoreboot=true -x patch_match_target=true -s
 | /tmp/PHCO_17058.depot
 |
 | If that doesn't work and since this seems to be a SAM patch, do you
 have
 |sam
 | installed and working?
 | Try running sam from the command line and see if the system
 administrator
 | tool works.
 | Otherwise I dunno. This might fail if a superseding patch was
 already
 | installed.
 |
 | PHCO_17058 has been replaced by PHCO_23876 (Latest Superseding
 Patch) and
 | PHCO_21187 (Best Available Patch). Try doing:
 |
 | swlist | grep PHCO
 |
 | to see if any of these later patches are already installed.
 |
 | You might want to install one of the later patches. I don't think
 anyone
 | comes out with
 | so many patch udates like HP-UX. Anytime you see documentation that
 says
 |you
 | need to install a certain patch, that patch will have been
 supersceeded 2
 |or
 | more times by the time you read the documentation so don't be
 worried
 |about
 | trying to install one of the supersceeding patches.
 |
 |
 | HTH
 | Ed
 |
 | -Original Message-
 | Sent: Tuesday, August 28, 2001 12:27 PM
 | To: Multiple recipients of list ORACLE-L
 |
 |
 | Hi all, this is slightly off topic, but I am trying to install 9i
 database
 | on an HP-UX 11.00 box.
 |
 | I have v.v.v.v. little experience on HP-UX. This is only a test
 box, but
 | going through ORACLE's install guide, it tells me I need to install
 |various
 | HP-UX patches using swinstall.
 |
 | Many of the patches I try to install are erroring out...
 |
 | I run the command
 |
 | # swinstall -x autoreboot=true -x patch_match_target=true \
 |
 |  -s /tmp/PHCO_17058.depot
 |
 | and get the following output:
 |
 | ===  08/28/01 16:14:35 BST  BEGIN swinstall SESSION
 (non-interactive)
 |
 |  * Session started for user root@ham1.
 |
 | * Beginning Selection
 |
 | * Target connection succeeded for ham1:/.
 | NOTE:The patch match operation failed to find patches for
 target
 | software on ham1 which passed the filter.
 | NOTE:Cannot continue the swinstall task.
 |
 | ===  08/28/01 16:14:50 BST  END swinstall SESSION
 (non-interactive)
 |
 |
 | Does this mean I don't need these patches??
 |
 | TIA,
 |
 | Stuart
 |

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Jonathan 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

RE: results of analyze

2001-08-29 Thread Mercadante, Thomas F


Paul,

You mean user_tab_columns.avg_col_len instead of user_columns, right?

I'm glad to say that your typo made me look at this table again, and I found
this usefull column!  Wish I had seen it last week when I was calculating
how much disk space I am going to need for a new DB.  I had to come up with
a kludgy way of calculating index size by averaging column widths.  This
column would have been much easier to use!

thanks for making me take a look!

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, August 29, 2001 10:00 AM
To: Multiple recipients of list ORACLE-L


Hi Ruth.

{user|all|dba}_tables, {user|all|dba}_columns, {user|all|dba}_indexes

Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, August 29, 2001 9:41 AM
To: Multiple recipients of list ORACLE-L


Good morning all,

Someone asked me where the results of analying tables and indexes goes.  Can
anyone tell me what table(s) holds the statistics generated.

Thanks,
Ruth B. Gramolini
ORACLE  DB2  DBA
VT Dept. of Taxes
ph# 802.828.5708
fax# 802.828..3754
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  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: Paul Baumgartel
  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: Mercadante, Thomas F
  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: HP-UX

2001-08-29 Thread Sherman, Edward


Okay, I just installed patch PHCO_21187 on a test workstation.
It went in okay but when I tried to swinstall it a second time
I got the patch match operation failed to find patches for
target message , apparently because the patch is already installed.

I'm guessing that the patches or superceeded versions of the patches are
already installed on the machine.

Ed



-Original Message-
Sent: Wednesday, August 29, 2001 9:41 AM
To: Multiple recipients of list ORACLE-L


Stuart,

I'm not an expert in these matters, but I've just
installed hp-ux 64-bit using the June release,
and including the three large-scale quality
patches.

During installation I noted that swinstall was
giving me message like:
298 files skipped out of 673

I think this meant it was simply not installing
patches which were not relevant to my particular
environment, and I suspect that your messages
mean the same.

I prefer with swinstall to invoke the product for
manual control, rather than using the command
line. i.e.
swinstall
then fill in the screen which specifies the depot
(the PHCO_17058.depot file in a local directory, then
choose the install action).

After the analyze stage you get messages about
errors and warnings and files skipped - this may be
more helpful (or perhaps comforting) than the summary
message you are getting at the end.


Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 29 August 2001 13:07


|Ed, the real problem is it's not just this patch... there is a list
of 10-15
|patches which all give this error message. I am tempted to just go
ahead and
|try the install anyway, how seriously could things go wrong :-)
|
|
|- Original Message -
|To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
|Sent: Tuesday, August 28, 2001 9:10 PM
|
|
| This is just a stab in the dark:
|
| I have never used a \ when installing patches so try running the
command
|on
| a single line
| like this:
|
| # swinstall -x autoreboot=true -x patch_match_target=true -s
| /tmp/PHCO_17058.depot
|
| If that doesn't work and since this seems to be a SAM patch, do you
have
|sam
| installed and working?
| Try running sam from the command line and see if the system
administrator
| tool works.
| Otherwise I dunno. This might fail if a superseding patch was
already
| installed.
|
| PHCO_17058 has been replaced by PHCO_23876 (Latest Superseding
Patch) and
| PHCO_21187 (Best Available Patch). Try doing:
|
| swlist | grep PHCO
|
| to see if any of these later patches are already installed.
|
| You might want to install one of the later patches. I don't think
anyone
| comes out with
| so many patch udates like HP-UX. Anytime you see documentation that
says
|you
| need to install a certain patch, that patch will have been
supersceeded 2
|or
| more times by the time you read the documentation so don't be
worried
|about
| trying to install one of the supersceeding patches.
|
|
| HTH
| Ed
|
| -Original Message-
| Sent: Tuesday, August 28, 2001 12:27 PM
| To: Multiple recipients of list ORACLE-L
|
|
| Hi all, this is slightly off topic, but I am trying to install 9i
database
| on an HP-UX 11.00 box.
|
| I have v.v.v.v. little experience on HP-UX. This is only a test
box, but
| going through ORACLE's install guide, it tells me I need to install
|various
| HP-UX patches using swinstall.
|
| Many of the patches I try to install are erroring out...
|
| I run the command
|
| # swinstall -x autoreboot=true -x patch_match_target=true \
|
|  -s /tmp/PHCO_17058.depot
|
| and get the following output:
|
| ===  08/28/01 16:14:35 BST  BEGIN swinstall SESSION
(non-interactive)
|
|  * Session started for user root@ham1.
|
| * Beginning Selection
|
| * Target connection succeeded for ham1:/.
| NOTE:The patch match operation failed to find patches for
target
| software on ham1 which passed the filter.
| NOTE:Cannot continue the swinstall task.
|
| ===  08/28/01 16:14:50 BST  END swinstall SESSION
(non-interactive)
|
|
| Does this mean I don't need these patches??
|
| TIA,
|
| Stuart
|

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan 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

RE: OT RE: RE: How do you audit a DBA?

2001-08-29 Thread Miller, Jay


Actually, if my company is any indication it's not a matter of whether they
think the DBA can be trusted it's a matter of being afraid of being sued if
*everything* isn't monitored and audited.
 
Our audit department's current target is the IS Unix Admin group.  They're
insisting that expensive 3rd party software be installed since Unix isn't a
secure operating system (root can do anything).
 
Jay Miller

-Original Message-
Sent: Monday, August 27, 2001 10:25 AM
To: Multiple recipients of list ORACLE-L



C'mon.  I'd vote for The Rock instead, along with all The Rock's witty
comments.  That would be awfully darn distracting, and you could be sure
your DBA would get NOTHING done :)

Honestly, if there's a need to audit the dba, maybe he or she should be
replaced?  Just curious. 

Can you smell...   what huge awful mess the DBA...is cooking? 

Sorry, couldn't resist 

Lisa Koivu 
Oracle Database Administrator 
954-935-4117 




-Original Message- 
Sent:   Monday, August 27, 2001 8:35 AM 
To: Multiple recipients of list ORACLE-L 

I have all of them save two, one of which was mailed to me last
week...  

I think I have way too many Conan novels, it's like Harlequin for
men! 

I have many double copies, I think I'll post them on eBay eventually
to get 
rid of them. 

: ) 

Patrice Boivin 
Systems Analyst (Oracle Certified DBA) 

-Original Message- 
From:   Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] 
Sent:   Thursday, August 23, 2001 6:30 PM 
To: Multiple recipients of list ORACLE-L 
Subject:RE: RE: How do you audit a DBA? 

Why don't you get some Conan the Barbarian lookinn fella to
stand 
behind 
this mistrusted dba all day? 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
http://www.orafaq.com  
-- 
Author: Boivin, Patrice J 
  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: Miller, Jay
  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: DDL CHANGES IN A REPLICATED ENVIRONMENT

2001-08-29 Thread Kevin Lange


Barry;
  We never did put together bi-directional replication, but in our single
directional case we ended up making any DDL changes on BOTH systems. 

Process:
  1. Stop Replication on selected object
  2. Make changes on Primary
  3. Make changes on Secondary
  4. Make changes to replication objects
  5. Restart Replication.



-Original Message-
Sent: Tuesday, August 28, 2001 7:35 PM
To: Multiple recipients of list ORACLE-L


We have just set up advanced replication in our lab (bi-directional)
And it seems to be working .
I am confused by how replication should handle ddl changes
Does replication have to be turned off before executing ddl changes 
(such as add column , drop column rename table etc)

I guess I don't understand why ddl changes won't break replication.


thanks
Barry

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: barry  botuck
  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: Kevin Lange
  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: financial problems with fatcity.com

2001-08-29 Thread Haskins, Ed


How about Corporate Sponsorship?




-Original Message-
Sent: Wednesday, August 29, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L


I think that much better than voluntary contributions will be some
s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I
am sure that
everybody working with Oracle and living in US or UK or other developed
country can afford such fees. We will not need to charge people from
developing countries - I am sure these subscription fees will generate more
than $500 per month.

Alex Hillman

-- 
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 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: Haskins, Ed
  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).

LinuxFS for Oracle

2001-08-29 Thread Bill Buchan



I am about to attempt an Oracle installation on SuSE Linux 7.2.  I need to 
pick a file-system: ext2 or reiserfs.
Does anyone have any comments to share?

All I can see from the docs is:
Oracle8i Server must be able to verify that file writes have been made to 
disk. File
systems that do not support this verification are not supported for use 
with Oracle
databases, although Oracle software can be installed on them.

My knowledge of how the 2 filesystems is 0.  I'd be very grateful for any 
advice and/or interpretation.

Thanks
- Bill.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Buchan
  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: !! Very important Oracle-L message !!

2001-08-29 Thread Jeremiah Wilton


On my web page I maintain an Amazon.com payments paybox, which is for
collecting anonymous donations.  I think if Bruce sets up a paybox for
each list he hosts free of charge, and included a pledge request in
the list footers, there will be a steady stream of donations.

Amazon calls this the Honor System, and it can be found at:

http://auctions.amazon.com/exec/varzea/subst/fx/home.html

It is basically like paypal, etc, but you can put the paybox inline
with any HTML, and it allows anonymous donations. The fee to Amazon is
15% of the total payment per transaction plus 15 cents.

I work for Amazon, so feel free to flame me for shamelessly promoting
my own product as a solution to this.  As an act of contrition, I
promise to pay US$50 into any form of collection that Bruce sets up,
Amazon or not.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Wed, 29 Aug 2001, Anjan Thakuria wrote:

 Can we just start pledging ..We have got to keep this form going under. Ideas

  -Original Message-
  Sent: 28 August 2001 23:29
  To: Multiple recipients of list ORACLE-L
 
  Ok, now that I have your attention, please read the following message from
  Bruce Bergman,
  owner of fatcity.com.  It concerns the future of this list.
 
  Please read the entire message before replying.
 
  ---
 
  Hello ORACLE-L list members --
 
  I would like to take a few minutes of your time for a State of the Union
  address, if you can call it that.  This is a rather serious message, and I
  request that you take the time to read this message entirely.  I've got a
  problem that needs resolution this week, and I'm hoping you folks can help
  me come to a conclusion.  This message turned out to be fairly
  long-winded, so please excuse me for that. :-)
 
  Fat City (fatcity.com) is my company, and I am the provider of the list
  services that you receive ORACLE-L through.  I've been hosting Internet
  mailing lists for over 10 years, and carry quite a few lists, including a
  big selection of Oracle-related lists (14, in fact).  Fat City has always
  been a labor of love for me.  Over the years it has rarely generated any
  income at all, and it usually does not cover my expenses -- most of the
  time
  it is a monthly loss for me.  The vast majority of my 60+ mailing lists
  have
  been hosted for free, at my expense (as is the ORACLE-L list, for example).
  Yet I have absorbed these costs because I enjoy hosting discussion lists
  and I know a lot of lists can't afford to pay for quality service.
 
  I am soon to be one of the Rhythms Orphans.  Rhythms, my DSL provider, has
  gone bankrupt and will be out of business by 10-Sep-2001.  I need to find
  another provider of high-speed Internet in order to continue operations.  I
  am at the point of either folding shop completely and going out of business
  myself, or trying to make Fat City a viable, money-making endeavor.  I need
  to make this decision by this Friday (for financial and planning reasons).
  After Friday, I am committed one way or the other.
 
  My upstream ISP and I are on very good terms, and in fact, I've been a
  customer of theirs since 1985!  As a result, they have graciously offered
  to help me out of this situation at considerable expense to themselves.
  I'm not at liberty to discuss the terms of the contract I would engage in
  with them, but suffice to say that is one of those once-in-a-lifetime
  opportunities that I'd be a fool to pass up.  I have this offer personally
  from the President of that company, if I want it.  Simply said, my ability
  to take them up on their offer and switch Fat City over to a dedicated T1
  or
  better solution revolves around being able to generate quite a bit of
  additional
  income per month, and very soon.  In an effort to be open and up-front with
  you folks about this, I basically need to generate an additional $500 more
  per
  month. Right now that seems daunting, but I've been working hard to line up
  that
  additional income, and I believe I can do it.  Just not right away.  My
  estimates are that it will take me four or five months to come up to that
  level.  I need to get out there and sell website hosting and list hosting
  packages, and get new customers.  That takes time, unfortunately.  I need a
  buffer to enable me to get past this startup phase.
 
  After some discussions with Jared (the list owner), and some encouragement
  from him, I am coming to you to ask for you help in keeping Fat City
  financially afloat until I can be self sufficient.  I'm not asking for a
  specific dollar amount from anyone, nor am I *expecting* anything from you
  folks.  But if it is within your power to contribute some money towards
  this
  end (and yes, I know these are hard financial times for everyone), I am
  hoping you can help.  If I can get sufficient promise of funds that will
  see
  me through the next few months, I am willing to jump in with both feet and

RE: alternative rows

2001-08-29 Thread Jamadagni, Rajendra


For even numbered rows .

select col_1, col_2
from (select col_1, col_2, rownum rnum
from my_table)
where mod(rnum, 2) = 0

For odd numbered rows ...

select col_1, col_2
from (select col_1, col_2, rownum rnum
from my_table)
where mod(rnum, 2)  0

A from clause select is useful because you can perform your ORDER BY etc in
the from clause query and then use the rownum.

HTH
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art !

*2

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.

*2

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  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: Drop Recreate table or alter table drop column. Which is

2001-08-29 Thread William Rogge

Because of any synonyms (which are based off of object numbers), Option 1 
is the only way to go.  That is of course unless you want to perform extra 
work dealing with the synonyms.

-Original Message-
From:   CHAN Chor Ling Catherine (CSC) [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, August 29, 2001 10:21 AM
To: Multiple recipients of list ORACLE-L
Subject:Drop  Recreate table  or  alter table drop column. Which is

Hi Gurus,

If the table is empty  U need to drop one of the columns, do you
1) alter table tab_name drop column col_name or
2) drop  recreate table

I use option (1). Which is a better choice ?  TIA

Regds,
New Bee

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
  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: William Rogge
  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: financial problems with fatcity.com

2001-08-29 Thread Kevin Lange


I for one would even agree to , say , a 25$ a year fee.   This is a very
good site and there are a lot of good ideas bandied about here every day.

Kevin

-Original Message-
Sent: Wednesday, August 29, 2001 10:16 AM
To: Multiple recipients of list ORACLE-L


I think that much better than voluntary contributions will be some
s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I
am sure that
everybody working with Oracle and living in US or UK or other developed
country can afford such fees. We will not need to charge people from
developing countries - I am sure these subscription fees will generate more
than $500 per month.

Alex Hillman

-- 
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 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: Kevin Lange
  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: MySQL anyone?

2001-08-29 Thread Jon Baker

Title: RE: MySQL anyone?





Attached is a note from another list member, Guy Hammond.


I agree with most of what Guy says, except that MySqueel does have master-slave replication (though slave cannot be a writeable slave). And I'd add no point-in-time recovery, no incremental backup capability, and though they elude to it, it is not SQL ANSI-92 compliant (they merely *follow* not *comply* with the SQL ANSI-92 entry level requirements).

MySqueel is fine to play with, but not what you want for a production environment. It's not an RDBMS, but a DBS (plain old database system). If you have a really simple application that is for internal use, it is free, but remember, you do get what you pay for.




- Guy Hammand response ---
Wow, looks like MySQL is better than Oracle!


Oh, apart from the fact that it doesn't have transactions, foreign keys,
stored procedures, replication, object type definitions, bitmap indexes,
subselects, or indeed, everything else a real database takes for
granted.


Get it? Granted? It doesn't have roles either, heh heh heh




-Original Message-
From: Gene Gurevich [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 10:00 AM
To: Multiple recipients of list ORACLE-L
Subject: MySQL anyone?



Hi.


does anyone know anything about MySQL? I was assigned
to a pilot to see whether this is something my company
would want to use. Does anyone use it? Any good/bad
opinions? 


TIA


Gene

RE: financial problems with fatcity.com


What're you, communist? I'd be willing to pay a subscription fee, but
not if it were subsidising politically correct nonsense.

g


-Original Message-
Sent: Wednesday, August 29, 2001 4:16 PM
To: Multiple recipients of list ORACLE-L


I think that much better than voluntary contributions will be some
s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year.
I
am sure that
everybody working with Oracle and living in US or UK or other developed
country can afford such fees. We will not need to charge people from
developing countries - I am sure these subscription fees will generate
more
than $500 per month.

Alex Hillman

-- 
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 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: Guy Hammond
  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: financial problems with fatcity.com

2001-08-29 Thread Ivan_Rivera

Title: RE: financial problems with fatcity.com





Alex, that is an excellent idea! I second that notion. 


I have learned just as much if not more from this list than the average $40-80 dba book out there (101 tuning and dba excluded, I've just ordered practical 8i and await that one). I think we can easily come up with the $500 a month figure, and that's this list alone. If you sum up all the rest of the lists...Bruce may be able to bring it down to 6 bucks a year maybe.

12 bucks a yearsh*t (Ladies forgive me here, I'm just a young buck trying to make a point) I've spent more than that for a lap dance and that was only to have someone rub an @ss on me, where you all have saved MY @SS literally more than once!!! This list is invaluable. Put me down for 12 bucks a year. Ivan 

ps. I by no means wanted to offend anyone, if so I am sorry and please forgive me. ;) Long Live the List!
-Original Message-
From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L
Subject: financial problems with fatcity.com



I think that much better than voluntary contributions will be some
s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I
am sure that
everybody working with Oracle and living in US or UK or other developed
country can afford such fees. We will not need to charge people from
developing countries - I am sure these subscription fees will generate more
than $500 per month.


Alex Hillman


-- 
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 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: financial problems with fatcity.com

2001-08-29 Thread Vergara, Michael (TEM)


Yeah...like maybe Oracle?  Or Quilogy (used to be Solutech)...they do 
Oracle training there in Mission Valley.

The downside of that would be the advertising...

---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation
(909) 914-2304


-Original Message-
Sent: Wednesday, August 29, 2001 8:48 AM
To: Multiple recipients of list ORACLE-L


How about Corporate Sponsorship?




-Original Message-
Sent: Wednesday, August 29, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L


I think that much better than voluntary contributions will be some
s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I
am sure that
everybody working with Oracle and living in US or UK or other developed
country can afford such fees. We will not need to charge people from
developing countries - I am sure these subscription fees will generate more
than $500 per month.

Alex Hillman

-- 
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 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: Haskins, Ed
  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: Vergara, Michael (TEM)
  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: financial problems with fatcity.com

2001-08-29 Thread ODell, Charles


I seldom chime in, but I feel no truer statement
was made.

Especially since you are more likely to get a right
answer from this list.


-Original Message-
Sent: Wednesday, August 29, 2001 12:43 PM
To: Multiple recipients of list ORACLE-L


Maybe Larry could spare a few bucks.  Heck, think of the amount of time that
this list saves Oracle support!

Dave

-Original Message-
Sent: Wednesday, August 29, 2001 10:48 AM
To: Multiple recipients of list ORACLE-L


How about Corporate Sponsorship?




-Original Message-
Sent: Wednesday, August 29, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L


I think that much better than voluntary contributions will be some
s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I
am sure that
everybody working with Oracle and living in US or UK or other developed
country can afford such fees. We will not need to charge people from
developing countries - I am sure these subscription fees will generate more
than $500 per month.

Alex Hillman

-- 
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 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: Haskins, Ed
  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: Farnsworth, Dave
  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: ODell, Charles
  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: !! Very important Oracle-L message !!

2001-08-29 Thread Gogala, Mladen

Just publish the address where to send the money orders to 
and my $20 will be on it's way tomorrow.

 -Original Message-
 From: Anjan Thakuria [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 29, 2001 11:21 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: !! *Very* important Oracle-L message !!

 Can we just start pledging ..We have got to keep this form 
 going under. Ideas
 .

 Anjan

 Jenner Mike wrote:

  -Original Message-
  Sent: 28 August 2001 23:29
  To: Multiple recipients of list ORACLE-L

  Ok, now that I have your attention, please read the 
 following message from
  Bruce Bergman,
  owner of fatcity.com.  It concerns the future of this list.

  Please read the entire message before replying.

  Thank you.

  Jared Still  ( List Owner )

  ---

  Hello ORACLE-L list members --

  I would like to take a few minutes of your time for a 
 State of the Union
  address, if you can call it that.  This is a rather serious 
 message, and I
  request that you take the time to read this message 
 entirely.  I've got a
  problem that needs resolution this week, and I'm hoping you 
 folks can help
  me come to a conclusion.  This message turned out to be fairly
  long-winded, so please excuse me for that. :-)

  Fat City (fatcity.com) is my company, and I am the provider 
 of the list
  services that you receive ORACLE-L through.  I've been 
 hosting Internet
  mailing lists for over 10 years, and carry quite a few 
 lists, including a
  big selection of Oracle-related lists (14, in fact).  Fat 
 City has always
  been a labor of love for me.  Over the years it has rarely 
 generated any
  income at all, and it usually does not cover my expenses -- 
 most of the
  time
  it is a monthly loss for me.  The vast majority of my 60+ 
 mailing lists
  have
  been hosted for free, at my expense (as is the ORACLE-L 
 list, for example).
  Yet I have absorbed these costs because I enjoy hosting 
 discussion lists
  and I know a lot of lists can't afford to pay for quality service.

  I am soon to be one of the Rhythms Orphans.  Rhythms, my 
 DSL provider, has
  gone bankrupt and will be out of business by 10-Sep-2001.  
 I need to find
  another provider of high-speed Internet in order to 
 continue operations.  I
  am at the point of either folding shop completely and going 
 out of business
  myself, or trying to make Fat City a viable, money-making 
 endeavor.  I need
  to make this decision by this Friday (for financial and 
 planning reasons).
  After Friday, I am committed one way or the other.

  My upstream ISP and I are on very good terms, and in fact, 
 I've been a
  customer of theirs since 1985!  As a result, they have 
 graciously offered
  to help me out of this situation at considerable expense to 
 themselves.
  I'm not at liberty to discuss the terms of the contract I 
 would engage in
  with them, but suffice to say that is one of those 
 once-in-a-lifetime
  opportunities that I'd be a fool to pass up.  I have this 
 offer personally
  from the President of that company, if I want it.  Simply 
 said, my ability
  to take them up on their offer and switch Fat City over to 
 a dedicated T1
  or
  better solution revolves around being able to generate 
 quite a bit of
  additional
  income per month, and very soon.  In an effort to be open 
 and up-front with
  you folks about this, I basically need to generate an 
 additional $500 more
  per
  month. Right now that seems daunting, but I've been working 
 hard to line up
  that
  additional income, and I believe I can do it.  Just not 
 right away.  My
  estimates are that it will take me four or five months to 
 come up to that
  level.  I need to get out there and sell website hosting 
 and list hosting
  packages, and get new customers.  That takes time, 
 unfortunately.  I need a
  buffer to enable me to get past this startup phase.

  After some discussions with Jared (the list owner), and 
 some encouragement
  from him, I am coming to you to ask for you help in keeping Fat City
  financially afloat until I can be self sufficient.  I'm not 
 asking for a
  specific dollar amount from anyone, nor am I *expecting* 
 anything from you
  folks.  But if it is within your power to contribute some 
 money towards
  this
  end (and yes, I know these are hard financial times for 
 everyone), I am
  hoping you can help.  If I can get sufficient promise of 
 funds that will
  see
  me through the next few months, I am willing to jump in 
 with both feet and
  make Fat City a viable business.  If it looks like the 
 contributions are
  not
  sufficient to enable me to do that, I will cease operations 
 within the next
  45-60 days.

  Let me be clear about a few things: If I *do* cease 
 operations, I will give
  all of my lists time to find new list providers, and will 
 make every effort
  to aid the shift over to the new provider, provide list 
 dumps,

help execution plan changes when using a dblink

2001-08-29 Thread Jeroen van Sluisdam




 -Oorspronkelijk bericht-
 Van:  Jeroen van Sluisdam 
 Verzonden:woensdag 29 augustus 2001 17:02
 Aan:  '[EMAIL PROTECTED]'
 Onderwerp:help execution plan changes when using a dblink
 
 Hi,
 
 We face the strange problem that an executionplan is changed 
 recently without
 any reason. Now it runs with a full_table scan and it did not do so.
 The query is executed  through a dblink and is part of a batch.
 
 - nothing has been changed recently in the app everybody 
 agrees on here,
 - analyze runs each weekend and a select count(*) differs 
 slightly between num_rows in
   dba_tables for the specific table
 - when executing the query manually in two parts the subquery 
 first and  ten the value returned
   hardcoded in the main-query it performs very good
 - when I ask for an explain plan in the database the link 
 points to the explain plan says it uses an index
 
 Details: oracle 7.3.4, hp-ux 10.20
 Query:
 select * from debtor_claims@deca_link
 where debtor_claim_id =
 (
 select max(debtor_claim_id)
 from debtor_claims@deca_link
 where res_id = 1291 and
 counter_booking_flag = 'N'
 )
 
 Tia,
 
 Jeroen
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeroen van Sluisdam
  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: !! Very important Oracle-L message !!

2001-08-29 Thread Valuthur, Srikanth


I agree to David.  We should basically have Bruce decide what is the amount
needed to maintain this list.  Also I would think since most of us are using
this site on a day to day basis, It wouldnt be fair that one person paying
25$ and another person pays nothing.  My 2 cents would be Since Bruce knows
how many members, He could assign the amount and divde it by number of
members.  Now that value could be the base amount.  Its left to everyones
consciousness and how much they think they have benifited from this list to
donate more or less or nothing.  I am sure most of us go by consiciousness
and would rate a fair value to ourselves and for maintaining this site.

But how much is too much is the big question, Which Bruce has to answer?

This is just my idea and need not be followed if it dosen't makes any sense.

Srikanth
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 10:42 AM
To: Multiple recipients of list ORACLE-L



I didn't put OT in the header because I think this is very on topic.  I
will be emailing Bruce to see what he needs, or feels is a fair
contribution for my participation in this list through the years.  I have
gained so much from the members of this list.  Without those who
participate, both past and present, I would never have progressed as far
along the DBA route as I have.  Ofttimes, I'll read about a problem someone
has posted here and, although I can't help them, I do copious research to
further my education and knowledge.  Many of these problems have
subsequently cropped up within my DB's, and I am much better prepared to
handle them as a result.  I also save, research, and test many of the
scripts posted here.  Some work, some don't, some can afford to be tweaked,
but playing with them has given me a deeper understanding of what goes into
being a DBA (plus I've now got a great toolkit - just need to learn PERL!).

I pay for my subscription to the daily newspaper.  This forum is at least
as valuable to me as the newspaper (I even get the comic section here).

There is a cost to the Internet - that's why many of us have jobs.  I urge
the members of this community to search their conciouses and give what they
can to help this forum prosper.

Someday I'd like to make it to OOW and meet some of you (heck, I've thought
about driving down to San Antonio just to meet Scott.  Does Mladen ever
leave his cave?)

Regards,

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

-- 
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: Valuthur, Srikanth
  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: results of analyze

2001-08-29 Thread Gogala, Mladen

That command is deprecated, but still exists. I believe
that the replacement is 
ANAYZE TABLE xxx VALIDATE STRUCTURE CASCADE;

 -Original Message-
 From: Jared Still [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 29, 2001 10:56 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: results of analyze

 In addition the INDEX_STATS view will be populated by
 the VALIDATE INDEX INDEX_NAME; command.

 It will have a most one row in it, so you need to check 
 it after each validate.

 Jared

 On Wednesday 29 August 2001 07:00, Paul Baumgartel wrote:
  Hi Ruth.

  {user|all|dba}_tables, {user|all|dba}_columns, 
 {user|all|dba}_indexes

  Paul Baumgartel
  MortgageSight Holdings, LLC
  [EMAIL PROTECTED]

  -Original Message-
  Sent: Wednesday, August 29, 2001 9:41 AM
  To: Multiple recipients of list ORACLE-L

  Good morning all,

  Someone asked me where the results of analying tables and 
 indexes goes. 
  Can anyone tell me what table(s) holds the statistics generated.

  Thanks,
  Ruth B. Gramolini
  ORACLE  DB2  DBA
  VT Dept. of Taxes
  ph# 802.828.5708
  fax# 802.828..3754
  [EMAIL PROTECTED]
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Jared Still
   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: Gogala, Mladen
  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: help execution plan changes when using a dblink

2001-08-29 Thread Nicoll, Iain (Calanais)


Have had problems before where anything over a db link was flaky explain
plan wise.  If you can have the basic query as a view stored remotely on the
db you link too it should work more consistently.

Iain Nicoll

-Original Message-
Sent: 29 August 2001 17:01
To: Multiple recipients of list ORACLE-L


Hi,

We face the strange problem that an executionplan is changed recently
without
any reason. Now it runs with a full_table scan and it did not do so.
The query is executed  through a dblink and is part of a batch.

- nothing has been changed recently in the app everybody agrees on here,
- analyze runs each weekend and a select count(*) differs slightly between
num_rows in
  dba_tables for the specific table
- when executing the query manually in two parts the subquery first and  ten
the value returned
  hardcoded in the main-query it performs very good
- when I ask for an explain plan in the database the link points to the
explain plan says it uses an index

Details: oracle 7.3.4, hp-ux 10.20
Query:
select * from debtor_claims@deca_link
where debtor_claim_id =
(
select max(debtor_claim_id)
from debtor_claims@deca_link
where res_id = 1291 and
counter_booking_flag = 'N'
)

Tia,

Jeroen
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeroen van Sluisdam
  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: Nicoll, Iain (Calanais)
  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: !! Very important Oracle-L message !!

2001-08-29 Thread John Carlson




As I see it, he needs $500 per month for 4 or 5 months. 
Lets just round that to 6 months times $500 or $3000.

I don't know how many people are on his 60+ mailing list but just guessing, 
I believe if only 1/4th the people contributed $1 per month for 6 months or just 
$6 that would cover it.

I am willing to donate up to $5 per month for up to 6 months paid either 
monthly or a lump sum depending on what he needs.
Just like in Public Television or Radio, I challenge everyone on the list 
to join me with an equal pledge.

Regards,
John Carlson
[EMAIL PROTECTED]
http://www.cj.com
 [EMAIL PROTECTED] 08/28/01 03:28PM 
Ok, now that I have your attention, please read the 
following message fromBruce Bergman,owner of fatcity.com. It 
concerns the future of this list.Please read the entire message before 
replying.Thank you.Jared Still ( List Owner 
)---Hello ORACLE-L 
list members --I would like to take a few minutes of your time for a 
"State of the Union"address, if you can call it that. This is a rather 
serious message, and Irequest that you take the time to read this message 
entirely. I've got aproblem that needs resolution this week, and I'm 
hoping you folks can helpme come to a conclusion. This message turned 
out to be fairlylong-winded, so please excuse me for that. :-)Fat 
City (fatcity.com) is my company, and I am the provider of the listservices 
that you receive ORACLE-L through. I've been hosting Internetmailing 
lists for over 10 years, and carry quite a few lists, including abig 
selection of Oracle-related lists (14, in fact). Fat City has 
alwaysbeen a labor of love for me. Over the years it has rarely 
generated anyincome at all, and it usually does not cover my expenses -- 
most of thetimeit is a monthly loss for me. The vast majority of 
my 60+ mailing listshavebeen hosted for free, at my expense (as is the 
ORACLE-L list, for example).Yet I have absorbed these costs because I enjoy 
hosting discussion listsand I know a lot of lists can't afford to pay for 
quality service.I am soon to be one of the Rhythms Orphans. 
Rhythms, my DSL provider, hasgone bankrupt and will be out of business by 
10-Sep-2001. I need to findanother provider of high-speed Internet in 
order to continue operations. Iam at the point of either folding shop 
completely and going out of businessmyself, or trying to make Fat City a 
viable, money-making endeavor. I needto make this decision by this 
Friday (for financial and planning reasons).After Friday, I am committed one 
way or the other.My upstream ISP and I are on very good terms, and in 
fact, I've been acustomer of theirs since 1985! As a result, they have 
graciously offeredto help me out of this situation at considerable expense 
to themselves.I'm not at liberty to discuss the terms of the contract I 
would engage inwith them, but suffice to say that is one of those 
once-in-a-lifetimeopportunities that I'd be a fool to pass up. I have 
this offer personallyfrom the President of that company, if I want it. 
Simply said, my abilityto take them up on their offer and switch Fat City 
over to a dedicated T1orbetter solution revolves around being able to 
generate quite a bit ofadditionalincome per month, and very soon. 
In an effort to be open and up-front withyou folks about this, I basically 
need to generate an additional $500 morepermonth. Right now that seems 
daunting, but I've been working hard to line upthatadditional income, 
and I believe I can do it. Just not right away. Myestimates are 
that it will take me four or five months to come up to thatlevel. I 
need to get out there and sell website hosting and list hostingpackages, and 
get new customers. That takes time, unfortunately. I need 
abuffer to enable me to get past this startup phase.After some 
discussions with Jared (the list owner), and some encouragementfrom him, I 
am coming to you to ask for you help in keeping Fat Cityfinancially afloat 
until I can be self sufficient. I'm not asking for aspecific dollar 
amount from anyone, nor am I *expecting* anything from youfolks. But 
if it is within your power to contribute some money towardsthisend (and 
yes, I know these are hard financial times for everyone), I amhoping you can 
help. If I can get sufficient promise of funds that willseeme 
through the next few months, I am willing to jump in with both feet andmake 
Fat City a viable business. If it looks like the contributions 
arenotsufficient to enable me to do that, I will cease operations within 
the next45-60 days.Let me be clear about a few things: If I *do* 
cease operations, I will giveall of my lists time to find new list 
providers, and will make every effortto aid the shift over to the new 
provider, provide list dumps, archives,mail forwarding, etc. Even 
though Rhythms goes out of business on10-Sep-2001, I have secured service 
until at least 10-Oct-2001 to enablethis to happen. So don't worry 
about having to rush into your

RE: financial problems with fatcity.com

2001-08-29 Thread Mark Leith


I would quite happily pay a subscription fee of £12 per year, or a squid a
month :) Damn, let's face it - you couldn't buy a decent Oracle book for
that, yet you have most of the more prestigious authors as members of this
list - interactively!!

Mark me up for a subscription. If you can't sort subscriptions out, let me
know and I'm happy to make a donation. This list *ROCKS*, and I think
loosing it would be a great loss in both Oracle technical knowledge for me,
as well as a great source of entertainment from time to time :)

Bruce/Jared - I hope all goes well over the next couple of months!! You have
done a GREAT job up to now, and hopefully we can keep this list going for
some time to come..

I'll even auction off my shiny red shoes.. Can I hear $50?

-Original Message-
Sent: Wednesday, August 29, 2001 16:48
To: Multiple recipients of list ORACLE-L


How about Corporate Sponsorship?




-Original Message-
Sent: Wednesday, August 29, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L


I think that much better than voluntary contributions will be some
s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I
am sure that
everybody working with Oracle and living in US or UK or other developed
country can afford such fees. We will not need to charge people from
developing countries - I am sure these subscription fees will generate more
than $500 per month.

Alex Hillman

--
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 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: Haskins, Ed
  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: Mark Leith
  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: financial problems with fatcity.com

2001-08-29 Thread Stephen Andert




I second that motion. I just spent over $100 to get my 2 
boys signed up for Cub Scouts and one of them has weekly dues of 
$1.00. For me it $12/yr would be worth it. Maybe offer a lifetime 
membership of $25 or something.
My 2 cents worth

Stephen Andert
 [EMAIL PROTECTED] 08/29/01 08:15AM 
I think that much better than voluntary contributions will be 
somes*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. 
Iam sure thateverybody working with Oracle and living in US or UK or 
other developedcountry can afford such fees. We will not need to charge 
people fromdeveloping countries - I am sure these subscription fees will 
generate morethan $500 per month.Alex 
Hillman

Re: alternative rows

2001-08-29 Thread claudio cutelli


select * from (
  select rownum,a,b,c from table) x
where mod(x.rownum,2) = 1


- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 29, 2001 5:35 PM


 Hi lists
 
 can anybody post me to find alternative rows in a table.
 
 1,3,5 ...
 
 or 2,4,6 
 
 srinivas
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Tatireddy, Shrinivas (MED, Keane)
   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: claudio cutelli
  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: financial problems with fatcity.com

2001-08-29 Thread John Lewis

Title: RE: financial problems with fatcity.com

And..
uh... Ivan, Please don't feel like you have to share any more lap dancing
experiences.
;-)

-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 29,
2001 9:51 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: financial problems with
fatcity.com
Alex, that is an excellent idea! I second that notion.

I have learned just as much if not more from this list than
the average $40-80 dba book out there (101 tuning and dba excluded, I've just
ordered practical 8i and await that one). I think we can easily come up with
the $500 a month figure, and that's this list alone. If you sum up all the
rest of the lists...Bruce may be able to bring it down to 6 bucks a year
maybe.
12 bucks a yearsh*t (Ladies forgive me here, I'm just a
young buck trying to make a point) I've spent more than that for a lap dance
and that was only to have someone rub an @ss on me, where you all have saved
MY @SS literally more than once!!! This list is invaluable. Put me down
for 12 bucks a year. Ivan
ps. I by no means wanted to offend anyone, if so I am sorry
and please forgive me. ;) Long Live the List! -Original Message- From: Hillman, Alex
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Subject: financial problems with fatcity.com
I think that much better than voluntary contributions will be
some s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month
or better $12 per year. I am sure that
everybody working with Oracle and living in US or UK or other
developed country can afford such fees. We will not
need to charge people from developing countries - I am
sure these subscription fees will generate more than
$500 per month.
Alex Hillman
-- 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 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: alternative rows

2001-08-29 Thread Mark Leith


How about analysing the table, finding out the total number of rows within
the table, and then using the SAMPLE clause with a value of 50%?

Mark

-Original Message-
Shrinivas (MED, Keane)
Sent: Wednesday, August 29, 2001 16:36
To: Multiple recipients of list ORACLE-L


Hi lists

can anybody post me to find alternative rows in a table.

1,3,5 ...

or 2,4,6 

srinivas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tatireddy, Shrinivas (MED, Keane)
  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: Mark Leith
  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: !! Very important Oracle-L message !!

2001-08-29 Thread John Kanagaraj


Jared/Bruce,

Count me in. I would suggest a standard amount of say US$20 (or more) per
month and see a show of hands (including mine), and take it from there. For
convenience's sake, I suppose this will mostly be from US based Listers.
C'mon guys and gals - we don't even have to dig deep into our pockets for
this.

John Kanagaraj
Oracle Applications DBA
DB Soft Inc
Work : (408) 970 7002

Listen to great, commercial-free christian music 24x7x365 at
http://www.klove.com

** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 3:29 PM
To: Multiple recipients of list ORACLE-L
Subject: !! *Very* important Oracle-L message !!



Ok, now that I have your attention, please read the following 
message from
Bruce Bergman,
owner of fatcity.com.  It concerns the future of this list.

Please read the entire message before replying.

Thank you.

Jared Still  ( List Owner )


---

Hello ORACLE-L list members --

I would like to take a few minutes of your time for a State 
of the Union
address, if you can call it that.  This is a rather serious 
message, and I
request that you take the time to read this message entirely.  
I've got a
problem that needs resolution this week, and I'm hoping you 
folks can help
me come to a conclusion.  This message turned out to be fairly
long-winded, so please excuse me for that. :-)

Fat City (fatcity.com) is my company, and I am the provider of the list
services that you receive ORACLE-L through.  I've been hosting Internet
mailing lists for over 10 years, and carry quite a few lists, 
including a
big selection of Oracle-related lists (14, in fact).  Fat City 
has always
been a labor of love for me.  Over the years it has rarely 
generated any
income at all, and it usually does not cover my expenses -- most of the
time
it is a monthly loss for me.  The vast majority of my 60+ mailing lists
have
been hosted for free, at my expense (as is the ORACLE-L list, 
for example).
Yet I have absorbed these costs because I enjoy hosting 
discussion lists
and I know a lot of lists can't afford to pay for quality service.

I am soon to be one of the Rhythms Orphans.  Rhythms, my DSL 
provider, has
gone bankrupt and will be out of business by 10-Sep-2001.  I 
need to find
another provider of high-speed Internet in order to continue 
operations.  I
am at the point of either folding shop completely and going 
out of business
myself, or trying to make Fat City a viable, money-making 
endeavor.  I need
to make this decision by this Friday (for financial and 
planning reasons).
After Friday, I am committed one way or the other.

My upstream ISP and I are on very good terms, and in fact, I've been a
customer of theirs since 1985!  As a result, they have 
graciously offered
to help me out of this situation at considerable expense to themselves.
I'm not at liberty to discuss the terms of the contract I 
would engage in
with them, but suffice to say that is one of those once-in-a-lifetime
opportunities that I'd be a fool to pass up.  I have this 
offer personally
from the President of that company, if I want it.  Simply 
said, my ability
to take them up on their offer and switch Fat City over to a 
dedicated T1
or
better solution revolves around being able to generate quite a bit of
additional
income per month, and very soon.  In an effort to be open and 
up-front with
you folks about this, I basically need to generate an 
additional $500 more
per
month. Right now that seems daunting, but I've been working 
hard to line up
that
additional income, and I believe I can do it.  Just not right away.  My
estimates are that it will take me four or five months to come 
up to that
level.  I need to get out there and sell website hosting and 
list hosting
packages, and get new customers.  That takes time, 
unfortunately.  I need a
buffer to enable me to get past this startup phase.

After some discussions with Jared (the list owner), and some 
encouragement
from him, I am coming to you to ask for you help in keeping Fat City
financially afloat until I can be self sufficient.  I'm not 
asking for a
specific dollar amount from anyone, nor am I *expecting* 
anything from you
folks.  But if it is within your power to contribute some money towards
this
end (and yes, I know these are hard financial times for everyone), I am
hoping you can help.  If I can get sufficient promise of funds 
that will
see
me through the next few months, I am willing to jump in with 
both feet and
make Fat City a viable business.  If it looks like the 
contributions are
not
sufficient to enable me to do that, I will cease operations 
within the next
45-60 days.

Let me be clear about a few things: If I *do* cease 
operations, I will give
all of my lists time to find new list providers, and will make 
every effort
to aid the shift

RE: An OPS tnsnames question

2001-08-29 Thread Andrey Bronfin


Hi Claudio !
Thanks a lot for your reply.
Another question ,please : How can i define SERVICE_NAME = OPS ?

I have 2 instances named OPS1  OPS2 , so , for example , in listener.ora on
DB2 i have :

LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp) (HOST = DB2) (PORT =
1526)))
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = OPS2)))

How can i tranlate that (SID_DESC = (SID_NAME = OPS2)) into SERVICE_NAME
= OPS ?

Thanks a lot !


DBAndrey

* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]



-Original Message-
Sent: Wednesday, August 29, 2001 6:36 PM
To: Multiple recipients of list ORACLE-L


try with:

OPS =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = tcp) (HOST = DB1) (PORT = 1526))
   (ADDRESS = (PROTOCOL = tcp) (HOST = DB2) (PORT = 1526))
)
(CONNECT_DATA = (SERVICE_NAME = OPS))
  )

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 29, 2001 5:15 PM


 Dear list !
 I've got an OPS database named OPS with 2 instances OPS1 and OPS2 .
 I want the users to connect to OPS1 and ONLY if it is down , to connect to
 OPS2.
 It's Oracle 8.0.5.1 on NT4.

 I put the following lines in clients' tnsnames.ora file :

 OPS.world = (DESCRIPTION_LIST =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = tcp) (HOST = DB1) (PORT = 1526))
   (CONNECT_DATA = (SID = OPS1))
 )
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = tcp) (HOST = DB2) (PORT = 1526))
   (CONNECT_DATA = (SID = OPS2))
 )
 )

 This works perfectly fine except for the case when OPS1 instance is down ,
 but the listener is up.
 Then clients try to connect to OPS1 and fail - Oracle not available .
 When i bring the listener on OPS1 host down - everybody perfectly connect
to
 OPS2.

 Is there a solution ?
 Thanks a lot in advance !


 DBAndrey

 * 03-9254520
 * 053-464562
 * mailto:[EMAIL PROTECTED]


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Andrey Bronfin
   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: claudio cutelli
  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: Andrey Bronfin
  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: 817 Intermedia on AIX

2001-08-29 Thread Koivu, Lisa

Title: RE: 817 Intermedia on AIX





Also - I ran into this problem on hp/ux: you may have to create the library hard coded with the oracle home path. REferencing $ORACLE_HOME (in user_libraries) did not work.

Lisa Koivu
The Bootylicious DBA
Ft. Lauderdale, FL, USA


-Original Message-
From: Mike J Kurth [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 11:21 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: 817 Intermedia on AIX



You may want to connect as ctxsys and query the user_libraries view
to make sure the library paths are pointing to your new 8.1.7 Oracle_home.
Just a thought.




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mike J Kurth
 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).

Novice Question

2001-08-29 Thread Kishore


Hello gurus

I am in a position to export a user and drop it then
create again and import it. Why I am doing this is
because I want to change the default tablespace of the
user to a different one and also its tabel are out of
extents. 

Now , my question ; may be very stupid though, Would
it break anything like indexes and views depends on
it. Once imported back everything would be same as it
was before.

Is there a way I know how many views , indexes and
every other objects depend on this user before even I
export.

All help is much appreciated.

Thank you very much



__
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: Kishore
  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: !! Very important Oracle-L message !!

2001-08-29 Thread Cherie_Machler



I would let Bruce speak for himself but I have to assume that it would be a
lot
of work and hassle to set up a subscription and then deny access to those
who
have not paid.

Is that true, Bruce.

If so, perhaps we should all just voluntarily send in some money.
$25 would be a drop in the bucket for most U.S. DBAs and less than
I spend on my other database magazine subscriptions.  Those
magazines don't come anywhere close to this mailing list in
usefulness.

Let us know what would be easiest for you administraters.

I second another motion.  If you post a mailing address, I will
send a check in the mail today.   Then you could have an idea
by Friday as to whether you could generate enough money to
keep going.

Cherie Machler
Oracle DBA
Gelco Information Network


   

Kathy Duret

KathyD@belkin   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]   
.comcc:   

Sent by: Subject: RE: !! *Very* important Oracle-L 
message !!  
[EMAIL PROTECTED] 

om 

   

   

08/29/01 01:11 

PM 

Please respond 

to ORACLE-L

   

   





IMHO

How about a monthly and a yearly subscription fee.

So newbies could join and pay a monthly subscription so if they don't like
it they could bail.

Other like me who would trade the list for anything could pay a yearly
subscription fee.

The yearly fee could be a bit lower than the monthly fee to encourage
people to pay the whole year up front.  It would be less overhead for Bruce
dealing with payments every month.

In any case I am will either to do a subscription or voluntary
contribution.  This list has save me so much time and money (and
frustration not having to always learn the hard way!).  Not to mention made
me a better DBA so I can command a better salary.

If Bruce does start making money he can always revert the list back to
being free.  Or he can wait a bit and recoup some of the money he has put
into the list as that is only fair.  Bruce shouldn't feel guilty about
anything!

Kathy

-Original Message-
Sent: Wednesday, August 29, 2001 10:22 AM
To: Multiple recipients of list ORACLE-L


I think a subscription is a decent suggestion. I know Bruce wants to keep
it
free but it still sounds the most feasible to me. After all the electronic
friends I have made on the list, and of course its primary aim as a
second-to-none technical resource/forum, I would hate to see it go.

Regards

Lee

-Original Message-
Sent: 29 August 2001 11:36
To: Multiple recipients of list ORACLE-L




-Original Message-
Sent: 28 August 2001 23:29
To: Multiple recipients of list ORACLE-L



Ok, now that I have your attention, please read the following message from
Bruce Bergman,
owner of fatcity.com.  It concerns the future of this list.

Please read the entire message before replying.

Thank you.

Jared Still  ( List Owner )


---

Hello ORACLE-L list members --

I would like to take a few minutes of your time for a State of the Union
address, if you can call it that.  This is a rather serious message, and I
request that you take the time to read this message entirely.  I've got a
problem that needs resolution this week, and I'm hoping you folks can help
me come to a conclusion.  This message turned out to be fairly
long-winded, so please excuse me for that. :-)

Fat City (fatcity.com) is my company, and I am the provider of the list
services that you receive ORACLE-L through.  I've been hosting Internet
mailing lists for over 10 years, and carry quite a few lists,

RE: financial problems with fatcity.com

2001-08-29 Thread Mohammad Rafiq


I think we should request Jared to decide about it for a possible solution 
and we should back him with any financial support to keep this fantastic 
list/forum alive
Regards

MOHAMMAD RAFIQ



Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 29 Aug 2001 08:36:19 -0800

I would quite happily pay a subscription fee of £12 per year, or a squid a
month :) Damn, let's face it - you couldn't buy a decent Oracle book for
that, yet you have most of the more prestigious authors as members of this
list - interactively!!

Mark me up for a subscription. If you can't sort subscriptions out, let me
know and I'm happy to make a donation. This list *ROCKS*, and I think
loosing it would be a great loss in both Oracle technical knowledge for me,
as well as a great source of entertainment from time to time :)

Bruce/Jared - I hope all goes well over the next couple of months!! You have
done a GREAT job up to now, and hopefully we can keep this list going for
some time to come..

I'll even auction off my shiny red shoes.. Can I hear $50?

-Original Message-
Sent: Wednesday, August 29, 2001 16:48
To: Multiple recipients of list ORACLE-L


How about Corporate Sponsorship?




-Original Message-
Sent: Wednesday, August 29, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L


I think that much better than voluntary contributions will be some
s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I
am sure that
everybody working with Oracle and living in US or UK or other developed
country can afford such fees. We will not need to charge people from
developing countries - I am sure these subscription fees will generate more
than $500 per month.

Alex Hillman

--
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 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: Haskins, Ed
   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: Mark Leith
   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: !! Very important Oracle-L message !!

2001-08-29 Thread Robertson Lee - lerobe


I think a subscription is a decent suggestion. I know Bruce wants to keep it
free but it still sounds the most feasible to me. After all the electronic
friends I have made on the list, and of course its primary aim as a
second-to-none technical resource/forum, I would hate to see it go.

Regards

Lee

-Original Message-
Sent: 29 August 2001 11:36
To: Multiple recipients of list ORACLE-L




-Original Message-
Sent: 28 August 2001 23:29
To: Multiple recipients of list ORACLE-L



Ok, now that I have your attention, please read the following message from
Bruce Bergman,
owner of fatcity.com.  It concerns the future of this list.

Please read the entire message before replying.

Thank you.

Jared Still  ( List Owner )


---

Hello ORACLE-L list members --

I would like to take a few minutes of your time for a State of the Union
address, if you can call it that.  This is a rather serious message, and I
request that you take the time to read this message entirely.  I've got a
problem that needs resolution this week, and I'm hoping you folks can help
me come to a conclusion.  This message turned out to be fairly
long-winded, so please excuse me for that. :-)

Fat City (fatcity.com) is my company, and I am the provider of the list
services that you receive ORACLE-L through.  I've been hosting Internet
mailing lists for over 10 years, and carry quite a few lists, including a
big selection of Oracle-related lists (14, in fact).  Fat City has always
been a labor of love for me.  Over the years it has rarely generated any
income at all, and it usually does not cover my expenses -- most of the
time
it is a monthly loss for me.  The vast majority of my 60+ mailing lists
have
been hosted for free, at my expense (as is the ORACLE-L list, for example).
Yet I have absorbed these costs because I enjoy hosting discussion lists
and I know a lot of lists can't afford to pay for quality service.

I am soon to be one of the Rhythms Orphans.  Rhythms, my DSL provider, has
gone bankrupt and will be out of business by 10-Sep-2001.  I need to find
another provider of high-speed Internet in order to continue operations.  I
am at the point of either folding shop completely and going out of business
myself, or trying to make Fat City a viable, money-making endeavor.  I need
to make this decision by this Friday (for financial and planning reasons).
After Friday, I am committed one way or the other.

My upstream ISP and I are on very good terms, and in fact, I've been a
customer of theirs since 1985!  As a result, they have graciously offered
to help me out of this situation at considerable expense to themselves.
I'm not at liberty to discuss the terms of the contract I would engage in
with them, but suffice to say that is one of those once-in-a-lifetime
opportunities that I'd be a fool to pass up.  I have this offer personally
from the President of that company, if I want it.  Simply said, my ability
to take them up on their offer and switch Fat City over to a dedicated T1
or
better solution revolves around being able to generate quite a bit of
additional
income per month, and very soon.  In an effort to be open and up-front with
you folks about this, I basically need to generate an additional $500 more
per
month. Right now that seems daunting, but I've been working hard to line up
that
additional income, and I believe I can do it.  Just not right away.  My
estimates are that it will take me four or five months to come up to that
level.  I need to get out there and sell website hosting and list hosting
packages, and get new customers.  That takes time, unfortunately.  I need a
buffer to enable me to get past this startup phase.

After some discussions with Jared (the list owner), and some encouragement
from him, I am coming to you to ask for you help in keeping Fat City
financially afloat until I can be self sufficient.  I'm not asking for a
specific dollar amount from anyone, nor am I *expecting* anything from you
folks.  But if it is within your power to contribute some money towards
this
end (and yes, I know these are hard financial times for everyone), I am
hoping you can help.  If I can get sufficient promise of funds that will
see
me through the next few months, I am willing to jump in with both feet and
make Fat City a viable business.  If it looks like the contributions are
not
sufficient to enable me to do that, I will cease operations within the next
45-60 days.

Let me be clear about a few things: If I *do* cease operations, I will give
all of my lists time to find new list providers, and will make every effort
to aid the shift over to the new provider, provide list dumps, archives,
mail forwarding, etc.  Even though Rhythms goes out of business on
10-Sep-2001, I have secured service until at least 10-Oct-2001 to enable
this to happen.  So don't worry about having to rush into your conversion
if
things don't work out.  I would also like to clearly state that this is not

FW: An OPS tnsnames question

2001-08-29 Thread Andrey Bronfin


Hi Claudio !
Thanks a lot for your reply.
Another question ,please : How can i define SERVICE_NAME = OPS ?

I have 2 instances named OPS1  OPS2 , so , for example , in listener.ora on
DB2 i have :

LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp) (HOST = DB2) (PORT =
1526)))
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = OPS2)))

How can i tranlate that (SID_DESC = (SID_NAME = OPS2)) into SERVICE_NAME
= OPS ?

Thanks a lot !


DBAndrey

* 03-9254520
* 053-464562
* mailto:[EMAIL PROTECTED]



-Original Message-
Sent: Wednesday, August 29, 2001 6:36 PM
To: Multiple recipients of list ORACLE-L


try with:

OPS =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = tcp) (HOST = DB1) (PORT = 1526))
   (ADDRESS = (PROTOCOL = tcp) (HOST = DB2) (PORT = 1526))
)
(CONNECT_DATA = (SERVICE_NAME = OPS))
  )

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 29, 2001 5:15 PM


 Dear list !
 I've got an OPS database named OPS with 2 instances OPS1 and OPS2 .
 I want the users to connect to OPS1 and ONLY if it is down , to connect to
 OPS2.
 It's Oracle 8.0.5.1 on NT4.

 I put the following lines in clients' tnsnames.ora file :

 OPS.world = (DESCRIPTION_LIST =
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = tcp) (HOST = DB1) (PORT = 1526))
   (CONNECT_DATA = (SID = OPS1))
 )
 (DESCRIPTION =
   (ADDRESS = (PROTOCOL = tcp) (HOST = DB2) (PORT = 1526))
   (CONNECT_DATA = (SID = OPS2))
 )
 )

 This works perfectly fine except for the case when OPS1 instance is down ,
 but the listener is up.
 Then clients try to connect to OPS1 and fail - Oracle not available .
 When i bring the listener on OPS1 host down - everybody perfectly connect
to
 OPS2.

 Is there a solution ?
 Thanks a lot in advance !


 DBAndrey

 * 03-9254520
 * 053-464562
 * mailto:[EMAIL PROTECTED]


 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Andrey Bronfin
   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: claudio cutelli
  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: Andrey Bronfin
  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).

!! Keeping the list alive

2001-08-29 Thread Jared . Still



This list is apparently a more valuable resource to many of you than I
realized.

I'm literally bowled over by the generosity.  I've received so many emails
about
this that I really can't personally reply to them all right now.

Many of you have asked some questions I would like to answer now.

Q.  How many members are there on this list.
A.  About 1500

Q. Why don't we just divide the amount needed by the number of
members and ask everyone for that amount?
A.  Not too practical.   This list is international.  It could present a
hardship for some.  Not everyone feels they get the same benefit
from the list.

Q.  Why not make this a fee based subscription?
A.  Charging a fee presents all kinds of additional complexity that
I don't care to introduce.

Q.  How much should I give?
A. That's up to you.  Don't make it a burden though.  Don't clean
out your savings, or anything like that. Many are pledging $10 or
$20 U.S.,  some more.  We don't want it to hurt.  :)

Q.  How can I send you some money?
A.  Details forthcoming.  You can send it to Bruce via PayPal.
Some want to send checks, what have you.  We'll post a PayPal
account and an address.


Thanks

Jared



-- 
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: awk, sed, windoze, sql*loader, other fun stuff

2001-08-29 Thread Jon Baker

Title: awk, sed, windoze, sql*loader, other fun stuff



try 
perl.

www.activestate.com
www.cpan.org
www.perl.com

it's 
free and easy to load. 



  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 29, 2001 
  2:27 PMTo: Multiple recipients of list ORACLE-LSubject: 
  awk, sed, windoze, sql*loader, other fun stuff
  Hello all, 
  I'm working on sql*loader scripts and I 
  realize that I'd probably be DONE by now if I had awk and sed to use. Of 
  course, as unix-deficient as I am, I don't have it. Does anyone know of 
  a windows version of these utilities? 
  Also I seem to remember someone had 
  created a dynamic create-control-file-based-on-a-table script in the past and 
  shared it with the list. Does anyone remember where that was? 
  
  Gracias 
  Lisa Koivu The Bootylicious DBA Ft. Lauderdale, FL, USA

ODBC link from Oracle to Access