date:20020304


I am not sure about this... just a guess
They may have included catrep.sql as a part of something
mandatory like catproc or catalog
So, one does not need to run that separatly...

Did you read the documentation? Do they say that if DB has to
be created manually then run catrep.sql separatly?

+R
  ___   ______   ___   ___
 /  /\ /  /\  /  /\ /  /\ /  /\
/  /::\   /  /::\/  /://  /://  /:/
   /  /:/\:\ /  /:/:|   /  /://  /://  /:/
  /  /::\ \:\   /  /:/|:|  /  /::\  __   /  /:/  ___   /  /:/
 /__/:/\:\_\:\ /__/::\|:| /__/:/\:\/ /\ /__/:/  /  /\ /__/:/
 \__\/~|::\/:/ \__\/\:\:| \__\/  \:\/:/ \  \:\ /  /:/ \  \:\
|  |:|::/ \__\::|  \__\::/   \  \:\  /:/   \  \:\
|  |:|\/   |  |:|  /  /:/ \  \:\/:/ \  \:\
|__|:| |__|:| /__/:/   \  \::/   \  \:\
 \__\|  \__\| \__\/ \__\/ \__\/

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, March 04, 2002 5:08 AM


 During install of Oracle9i EE software, I have checked replication
option.

 Afterwards, when I run Database Configuration Assistant there is no
check
 box related to replication???

 When I run Oracle Installer after the install, it confirms that
 replication option is present.

 Platform is 9i on Win2000.

 Thanks in advance

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Vladimir Barac - posao
   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: Rahul Dandekar
  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: replication question




Depends on your need.
You can have read only snapshots, updatable 
snapshots
or multimaster...
Again if you think of multimaster... then you would 
need to make decision
based on your application requirements about sync 
or async

I donot have any expereince of snapshot 
replication.
But, if you are planning multimaster replication, 
then better
spend a couple of months studying it and testing on 
test boxes...

Make 100% sure that your applicationreally 
needs the replication
and there is no other simpler 
option...

Just 2 cents...

+Rahul

  - Original Message - 
  From: 
  Bunyamin K. Karadeniz 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, March 04, 2002 3:33 
AM
  Subject: replication question
  
  Dear Gurus,
  The clients will enter records to a database all 
  day and I will update the other database . 
  I need to replicate 10 tables in a database to 
  other database at a specific time. 
  
  Do I need Advanced replication or basic 
  replication . ?
  How can I understand that replication is 
  supported in my both databases. ?
  
  Bunyamin

RE: Planning Test Backup/Recovery

2002-03-04 Thread


There should not be any problem to test the backup.
However we are testing the restores to another machine,
not on the production machine.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: Eca Eca [SMTP:[EMAIL PROTECTED]]
 Sent: Mon, March 04, 2002 1:18 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Planning Test Backup/Recovery
 
 
 Hi all :
 
 Does anyone have a planning for test backup and recovery ?
 
 I have the scripts and i am doing the backup and now we need to test it
 in production environment.
 
 I have tested it at another environment and got sucess.
 
 but at production ... it need to be very very careful ...
 
 Any sugestion ?
 
 Regards
 
 Eriovaldo
 
 
 
 
 _
 O MSN Photos é o jeito mais fácil de compartilhar, editar e imprimir suas 
 fotos preferidas: http://photos.msn.com.br/support/worldwide.aspx
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Eca Eca
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-8?Q?àãø_éçéàì?  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: Replication - Oracle 9i - problem

2002-03-04 Thread


Replication is not part of database configuration.
After you build the database and create objects inside
you use the replication manager to create the replication
on the objects you want to replicate.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: Vladimir Barac - posao [SMTP:[EMAIL PROTECTED]]
 Sent: Mon, March 04, 2002 12:08 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Replication - Oracle 9i - problem
 
 During install of Oracle9i EE software, I have checked replication
 option.
 
 Afterwards, when I run Database Configuration Assistant there is no
 check
 box related to replication???
 
 When I run Oracle Installer after the install, it confirms that
 replication option is present.
 
 Platform is 9i on Win2000.
 
 Thanks in advance
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Vladimir Barac - posao
   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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  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: Seperating indexes and tables

2002-03-04 Thread Connor McDonald


Basically separating data and indexes is a special
case of separating disparate IO operations to achieve
sensible load balancing across your IO subsystem.

Its a little obsolete - basically being a throwback to
the days when Oracle did nested loops and not much
else.  Nowadays, with operations that could be
parallel, fast full scans, index joins, etc etc, it
could be a more complicated exercise.

Unless you're in a high end environment, a reasonable
compromise is spreading all the database across one or
more stripe sets.

hth
connor

 --- Jack van Zanen [EMAIL PROTECTED] wrote:  Hi All,
 
 
 I used to learn that due to performance reasons
 (disk head going back and
 forth) indexes need to be seperated from tables
 (different
 disks/controllers).
 Later I have heard other people say that this is not
 an issue because the
 disk head does not stop and wait for you on a
 production system with normal
 activity. The reason for seperating indexes and
 tables now only done for
 administrating purposes.
 
 I tend to lean towards the second opinion but would
 like to have your
 opinion on this
 
 
 TIA
 
 
 
 Jack
 

===
 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: Jack van Zanen
   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). 

=
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!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
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

Re: replication question

2002-03-04 Thread Bunyamin K. Karadeniz




Thank you Rahul , 
Do you acceptvisa or bank check ? 
:)

Bunyamin 

  - Original Message - 
  From: 
  Rahul 
  Dandekar 
  To: Multiple recipients of list ORACLE-L 
  Sent: Monday, March 04, 2002 2:43 
PM
  Subject: Re: replication question
  
  Depends on your need.
  You can have read only snapshots, updatable 
  snapshots
  or multimaster...
  Again if you think of multimaster... then you 
  would need to make decision
  based on your application requirements about sync 
  or async
  
  I donot have any expereince of snapshot 
  replication.
  But, if you are planning multimaster replication, 
  then better
  spend a couple of months studying it and testing 
  on test boxes...
  
  Make 100% sure that your applicationreally 
  needs the replication
  and there is no other simpler 
  option...
  
  Just 2 cents...
  
  +Rahul
  
- Original Message - 
From: 
Bunyamin K. Karadeniz 
To: Multiple 
recipients of list ORACLE-L 
Sent: Monday, March 04, 2002 3:33 
AM
Subject: replication question

Dear Gurus,
The clients will enter records to a database 
all day and I will update the other database . 
I need to replicate 10 tables in a database to 
other database at a specific time. 

Do I need Advanced replication or basic 
replication . ?
How can I understand that replication is 
supported in my both databases. ?

Bunyamin

Re: Re:FW: Expiration of your subscription to the ORACLE-L list

2002-03-04 Thread Ruth Gramolini


That is another listserv hosted by suny (State University of New York). It
is not very active but it is not a hoax.

Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 4:18 PM


 Nope, and since the list is supported out of Fatcity it would appear to be
a
 hoax.

 Reply Separator
 Author: Hamid Alavi [EMAIL PROTECTED]
 Date:   3/1/2002 10:48 AM

 List,
 I want to know if any of you received a message like this for
 re-subscribe???

 -Original Message-
 [mailto:[EMAIL PROTECTED]]
 Sent: Friday, March 01, 2002 3:00 AM
 To: Hamid Alavi


 Fri, 1 Mar 2002 06:00:01

 Your subscription to the ORACLE-L list has expired and you have failed to
 confirm  it in  the 7  day  delay that  you  had been  granted. You  have
 therefore been automatically removed from  the list. You can re-subscribe
 to  the  list, if  you  want  to, by  sending  the  following command  to
 [EMAIL PROTECTED]:

SUBscribe ORACLE-L
 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:
   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).

VTOS-4845:Cannot retrieve data from table error

2002-03-04 Thread Farnsworth, Dave


In DBA Studio, when I try to refine a query on a table to bring back only certain 
records I am getting this error message; 

VTOS-4845:Cannot retrieve data from table 

It only happens on this table. I see no errors or trace files generated. I can run the 
query in SQLPlus just fine. Is this a bug in OEM 

Thanks,

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

LOBs SPACE ?


Hi
How much space occupied by LOB column of any tables?
Thx
-Seema


_
Chat with friends online, try MSN Messenger: http://messenger.msn.com

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

Re: Replication - Oracle 9i - problem


I think what Vladimir is referring is the DBCA screen
(atleast in 8i) which asks if Replication option is
to be used or not. And if checked, it calls catrep.sql
after dbcreate - catalog - catproc

+Rahul

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, March 04, 2002 7:53 AM


 Replication is not part of database configuration.
 After you build the database and create objects inside
 you use the replication manager to create the replication
 on the objects you want to replicate.

 Yechiel Adar, Mehish Computer Services
 [EMAIL PROTECTED]

  -Original Message-
  From: Vladimir Barac - posao [SMTP:[EMAIL PROTECTED]]
  Sent: Mon, March 04, 2002 12:08 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Replication - Oracle 9i - problem
 
  During install of Oracle9i EE software, I have checked replication
  option.
 
  Afterwards, when I run Database Configuration Assistant there is no
  check
  box related to replication???
 
  When I run Oracle Installer after the install, it confirms that
  replication option is present.
 
  Platform is 9i on Win2000.
 
  Thanks in advance
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Vladimir Barac - posao
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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
   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: Rahul Dandekar
  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: New iMac as dba workstation

2002-03-04 Thread George Schlossnagle


I'm using a Titanium G4 as a workstation, does that count?  ;)

I've had marginal luck using products like SQLGrinder (native OSX app, 
uses JDBC for connectivity).  Ultimately though, I fell back to using 
Tora X-forwarded back to my box (I'm running XDarwin on top of Agua).  I

This is all part of a grand experiment, and I have to say that for me 
it's a marginal success at best.  The cut-and-paste between Aqua and 
XDarwin is poor, which makes Tora only marginally useful for me.  I 
would kill for OCI libs for OSX and a port of Golden.

George

On Monday, March 4, 2002, at 06:23 AM, Jan Pruner wrote:

 Is anybody using iMac as workstation (db admin,  programming Oracle 
 stuff
 etc.)?
 Is there net8 client verison for PowerPC or have I to run sqlplus (or 
 TOra)
 remote?

 Thanks

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

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


// George Schlossnagle
// Principal Consultant
// OmniTI, Inc  http://www.omniti.com
// (c) 301.343.6422   (e) [EMAIL PROTECTED]
// 1024D/1100A5A0  1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: George Schlossnagle
  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: Uncle Larry is Number Five

2002-03-04 Thread Boivin, Patrice J


He was first for a month or two, then Billy overtook him again.

Friday Oracle announced they would not meet their next earnings target,
their shares went into freefall, but at the end of the day about 3.5% lost
in share value.

So Larry lost worth again.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

 -Original Message-
Sent:   Monday, March 04, 2002 4:13 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Uncle Larry is Number Five

Most of them are from IT world,

emmm... we are at right path.

-Original Message-
Sent: 02 March 2002 07:08
To: Multiple recipients of list ORACLE-L



Go uncle Larry!!

Make me feel all warm and fuzzy inside.

On Friday 01 March 2002 14:39, you wrote:
 The ranking of the world's 100 richest people as estimated by Forbes
 magazine. Listings include rank, name, home country, age where known,
 wealth in billions of dollars and source of the money. 1. Gates, William
H.
 III, United States, 46, dlrs 52.8, Microsoft
 2. Buffett, Warren E., United States, 71, dlrs 35.0, Berkshire Hathaway
 3. Albrecht, Karl and Theo, Germany, dlrs 26.8, retail
 4. Allen, Paul G., United States, 49, dlrs 25.2, Microsoft
 5. Ellison, Lawrence J., United States, 57, dlrs 23.5, Oracle

 Jerry Whittle
 ACIFICS DBA
 NCI Information Systems Inc.
 [EMAIL PROTECTED]
 618-622-4145
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ltiu
  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: Sinard Xing
  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: 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).

Re: Manager decrees his data warehouse design. Help!

2002-03-04 Thread bill thater


[EMAIL PROTECTED] wrote:

I had a teacher in college who could program the machine by flipping
the switches on the front.

that's how you IPLed the 360 and 1440 series.



We had paper tape, a step up from the plugs :)

IBM 403 Accounting Machine.  lots and lots of room for plugs, and lots 
of scratches on your hands from trying to get the damn things in and out 
of the board.;-)


-- 
--
Bill Shrek Thater  ORACLE DBA
[EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

God is real, unless declared integer.






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: bill thater
  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: Planning Test Backup/Recovery

2002-03-04 Thread Mercadante, Thomas F


Eriovaldo,

If I were you, I would create a small test database on the production
machine, and perform backup/restore of that test database to be sure that
everything is working before I would try it on a production database.

Once you are convinced that everything works, schedule a down time where you
can test backup/restore of the production database.

I would also keep the test db on the production box, and as a regular
monthly schedule, test backup and restore of that database - just to make
sure that it continues to work.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, March 04, 2002 7:48 AM
To: Multiple recipients of list ORACLE-L


There should not be any problem to test the backup.
However we are testing the restores to another machine,
not on the production machine.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: Eca Eca [SMTP:[EMAIL PROTECTED]]
 Sent: Mon, March 04, 2002 1:18 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Planning Test Backup/Recovery
 
 
 Hi all :
 
 Does anyone have a planning for test backup and recovery ?
 
 I have the scripts and i am doing the backup and now we need to test it
 in production environment.
 
 I have tested it at another environment and got sucess.
 
 but at production ... it need to be very very careful ...
 
 Any sugestion ?
 
 Regards
 
 Eriovaldo
 
 
 
 
 _
 O MSN Photos é o jeito mais fácil de compartilhar, editar e imprimir suas 
 fotos preferidas: http://photos.msn.com.br/support/worldwide.aspx
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Eca Eca
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?  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: Replication - Oracle 9i - problem

2002-03-04 Thread Jesse, Rich


In 9i, catrep is now called from catproc, so AR is installed automatically.
At least that's what the New Features Guide says.  And in the Linux
version, it's true.

HTH!  GL!  :)

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA


-Original Message-
Sent: Monday, March 04, 2002 8:48 AM
To: Multiple recipients of list ORACLE-L


I think what Vladimir is referring is the DBCA screen
(atleast in 8i) which asks if Replication option is
to be used or not. And if checked, it calls catrep.sql
after dbcreate - catalog - catproc

+Rahul

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, March 04, 2002 7:53 AM


 Replication is not part of database configuration.
 After you build the database and create objects inside
 you use the replication manager to create the replication
 on the objects you want to replicate.

 Yechiel Adar, Mehish Computer Services
 [EMAIL PROTECTED]

  -Original Message-
  From: Vladimir Barac - posao [SMTP:[EMAIL PROTECTED]]
  Sent: Mon, March 04, 2002 12:08 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Replication - Oracle 9i - problem
 
  During install of Oracle9i EE software, I have checked replication
  option.
 
  Afterwards, when I run Database Configuration Assistant there is no
  check
  box related to replication???
 
  When I run Oracle Installer after the install, it confirms that
  replication option is present.
 
  Platform is 9i on Win2000.
 
  Thanks in advance
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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 are the snapshots refreshed ?

2002-03-04 Thread claudio cutelli




you should define the interval
in the snapshot's DDL.
ES.START WITH sysdate NEXT 
sysdate + (1/24)/30  

  - Original Message - 
  From: 
  Bunyamin K. Karadeniz 
  To: Multiple recipients of list ORACLE-L 
  Sent: Monday, March 04, 2002 1:58 
PM
  Subject: how are the snapshots refreshed 
  ?
  
  Dear Gurus,
  
  I have made 10 tables as snapshots . And I want 
  to refresh them for specific intervals. 
  How can I do that ;
  I have tried DBMS_SNAPSHOT.REFRESH_ALL_MVIEWS but 
  could not succeed . 
  How is it done ?
  Bunyamin

Changing the SID of a database

2002-03-04 Thread rick


I'm going to take the datafiles from a cold backup and use them for a new
database. However, to do this, I need to change the SID of the new db. I've read
that it's possible, but not how to do it. Is this an easy thing to do, or would
it be better to extract the tables and create the new db that way?

Thanks for any help.
Rick
-- 
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: replication question




The 
way I see it . the question comes down to whether or not you need two 
way replication or just one way. If both databases can update those 
tables and you need them synced between the databases then Advanced Replication 
would be the route. If all you need are data changes from 1 database 
to be replicated to another database then simple replication is all you 
need.

  -Original Message-From: Rahul Dandekar 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 6:43 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  replication question
  Depends on your need.
  You can have read only snapshots, updatable 
  snapshots
  or multimaster...
  Again if you think of multimaster... then you 
  would need to make decision
  based on your application requirements about sync 
  or async
  
  I donot have any expereince of snapshot 
  replication.
  But, if you are planning multimaster replication, 
  then better
  spend a couple of months studying it and testing 
  on test boxes...
  
  Make 100% sure that your applicationreally 
  needs the replication
  and there is no other simpler 
  option...
  
  Just 2 cents...
  
  +Rahul
  
- Original Message - 
From: 
Bunyamin K. Karadeniz 
To: Multiple recipients of list ORACLE-L 

Sent: Monday, March 04, 2002 3:33 
AM
Subject: replication question

Dear Gurus,
The clients will enter records to a database 
all day and I will update the other database . 
I need to replicate 10 tables in a database to 
other database at a specific time. 

Do I need Advanced replication or basic 
replication . ?
How can I understand that replication is 
supported in my both databases. ?

Bunyamin

Making rule-based optimizer choose correct index

2002-03-04 Thread Frederik Lindberg


Hi,

I'm trying to do a join that is best done by a fast full scan of one
index and a lookup in another. Using the rule-based optimizer and
Oracle 8.1.6, I can't get the optimizer to do what I want. Is there a
way? Any enlightenment would be greatly appreciated.

[Yes, we are moving to cost-based, but some applications need
straightening out first).

- details ---
TABLE U
-UID number,
-EMAIL varchar2(100),
-CLIENT_ID number

unique index on (UID,EMAIL,CLIENT_ID)

TABLE D
-UID number
... lots of data columns

unique index on UID

Query: select D.UID,U.EMAIL from U,D where U.UID = D.UID (so in
essence, I want the UID-EMAIL translation for all UID that exist in
the D table).

The optimizer does a table access full on D and a range scan on the U
table index. Same query with /*+ INDEX_FFS(D-index) */ results in a
fast full scan of the _U_ index followed by a unique scan of the D
index. Adding nonsense criteria such as ... and D.UID  0 doesn't
make things better.

The D table is very wide, so a lot of I/O is wasted by doing a full
table scan.

Thanks!


-- Sincerely, Fred
Frederik Lindberg, CTO, CheetahMail


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Frederik Lindberg
  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: Linux for Big(ish) Databases

2002-03-04 Thread Steven Lembark




 We've got a new database to put together.  OLTP, 100-200 users, ~250Gb
 data.  We haven't decided on a platform for this yet.  Is Intel/Linux
 worth considering for this size of thing?

No reason why not. Might also want to consider linux
on a Sparc or Alpha.



--
Steven Lembark   2930 W. Palmer
Workhorse Computing   Chicago, IL 60647
+1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Lembark
  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: Changing the SID of a database

2002-03-04 Thread SARKAR, Samir


Take a backup of the controlfile statement by doing a 

 alter system backup controlfile to trace;

Then use this script to create a new controlfile with the new SID
after u have transferred all the datafiles, redolog files and archive
log files. The first line of the create controlfile script may look 
aomething like :

 CREATE CONTROLFILE REUSE SET DATABASE NAME OF NEW DB RESETLOGS
ARCHIVELOG

Change the path of the log files and other datafiles in the script if they
happen to
be different than the old database. Remember to run the create controlfile
script in 
nomount mode.

Remember to change the db_name parameter in ur parameter 
file for the new database. 

After creating the controlfile, startup the database using the resetlogs
option :

 alter database open resetlogs;

Hope this helps,

Samir

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
[EMAIL PROTECTED] 
Phone : +44 (0) 115 - 957 6217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018


-Original Message-
Sent: 04 March 2002 15:23
To: Multiple recipients of list ORACLE-L


I'm going to take the datafiles from a cold backup and use them for a new
database. However, to do this, I need to change the SID of the new db. I've
read
that it's possible, but not how to do it. Is this an easy thing to do, or
would
it be better to extract the tables and create the new db that way?

Thanks for any help.
Rick
-- 
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).


___
This email is confidential and intended solely for the use of the 
individual to whom it is addressed. Any views or opinions presented are 
solely those of the author and do not necessarily represent those of 
SchlumbergerSema. 
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or 
copying of this email is strictly prohibited.

If you have received this email in error please notify the SchlumbergerSema Helpdesk 
by telephone on +44 (0) 121 627 5600.
___

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: SARKAR, Samir
  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: Changing the SID of a database

2002-03-04 Thread Rachel Carmichael


it's doable. You will need to do a number of things before you can open
the database, including recreating the controlfile (to change the sid)
and renaming all the datafiles to new locations (so you don't overwrite
the original database)

The easiest way (but not the shortest time) to do this would be to do a
full database export, create the new database, with the SID you want
and all the tablespaces with the new datafiles, import the full export
with DESTROY=N and IGNORE=Y (this is VERY important! or you will
overwrite the original datafiles).

you can also export every user individually and import them into the
new database safest way but most time-consuming and biggest pain in
the butt way to do it


--- [EMAIL PROTECTED] wrote:
 I'm going to take the datafiles from a cold backup and use them for a
 new
 database. However, to do this, I need to change the SID of the new
 db. I've read
 that it's possible, but not how to do it. Is this an easy thing to
 do, or would
 it be better to extract the tables and create the new db that way?
 
 Thanks for any help.
 Rick
 -- 
 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).


__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
-- 
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).

RE: help with a SQL self-join

2002-03-04 Thread Pardee, Roy E


If I understand correctly, it sounds like you need a *recursive* self-join.
Depending on the version of your db (certainly in 8i or later) you may be
able to use the CONNECT BY PRIOR syntax to get what you're after.

Have a look at the SQL reference for 'hierarchical queries'.  Here's a link
to the 9i docs:

http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/qu
eries2.htm#2053937

(please watch for line wraps)

for reference.

HTH,

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Friday, March 01, 2002 10:53 AM
To: Multiple recipients of list ORACLE-L


I need help with a self-join.  I have two tables:  DEPT_TBL and TREENODE.

One table holds dept data.  Depts report to one another at at different 
levels, and are rolled-up for different purposes.  This roll-up 
information is stored in the TREENODE table.

Each tree_node in TREENODE has a corresponding PARENT_TREE_NUM, which 
corresponds to it's roll-up level.  DEPT_TBL holds dept ID and dept 
description, but no level information.  TREENODE holds tree_descriptions.

The a.deptid = b.tree_node, so that's a possible join.

Question:  How do I pull a dept ID and it's corresponding roll-up 
node/deptid?

This is what I have so far;

select DISTINCT a.tree_node DEPT, b.tree_node COLL
from treenode a, treenode b
where a.tree_node  b.tree_node
and a.tree_name = 'DEPT_SECURITY'
and a.tree_node = 'H0086'
and a.parent_node_num = b.parent_node_num;

this pulls a dept and all the depts that roll-up at the same level, but 
not the roll-up level.  For example, Dept 'H0086', and 27 depts that rollup 
at the same level.   I simply want a single row with two columns:  a deptID,

and a rollup ID.

How do I do this?

Any help is really appreciated.

Thanks--
Edward Lock
[EMAIL PROTECTED]








_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Edward Lock
  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: Pardee, Roy E
  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: Changing the SID of a database

2002-03-04 Thread Bill Gentry


Rick, here is how I do it.  Contact me if there are any questions.


Make a copy of 'prod' on LAWDB to 'test' on LAWDB from Cold Backup

Introduction

The 'prod' Oracle instance sometimes need to be replicated, on demand, for
testing and/or training purposes. The replication is done using a 'Cold'
backup copy of the 'prod' instance using either the backup directory
(/dbkup) or the ADSM backup. The procedure is very much the same for
creating either 'test' or 'train'. This section will assume creating a 'test
' database.


Procedure

? Take a cold backup of 'prod'

? Shutdown 'test' instance

The 'test' instance should be shutdown using 'immediate' option.


ORACLE_SID=test

export ORACLE_SID

svrmgrl

SVRMGR connect / as sysdba;
connected;

SVRMGR select name from v$database;
NAME
-
TEST
1 row selected.

SVRMGR oradebug ipc

SVRMGR shutdown immediate;

SVRMGR exit;

? Copy the datafiles files from the cold backup

Delete ALL TEST database related files, i.e. *.dbf, *.ctl, *.log

Use the cold backup to copy the .dbf files to the test instance
mountpoints


? Re-create control files  redo logs for the test instance.
(See example belos)

Use the 'make control file' script

ORACLE_SID=test

export ORACLE_SID

cd $HOME/test/admin

svrmgrl

SVRMGR connect / as sysdba

SVRMGR @mkctrl

SVRMGR select name from v$database;



Example  of creating control files  redo logs:

STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE lawtst5 RESETLOGS NOARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 200
MAXINSTANCES 8
MAXLOGHISTORY 800
LOGFILE
  GROUP 1 '/db/u05/oradata/lawtst5/redo01.log'  SIZE 64M,
  GROUP 2 '/db/u06/oradata/lawtst5/redo02.log'  SIZE 64M,
  GROUP 3 '/db/u07/oradata/lawtst5/redo03.log'  SIZE 64M
DATAFILE
  '/db/u05/oradata/lawtst5/system01.dbf',
.
.
.
. '/db/u04/oradata/lawtst5/index22.dbf',
  '/db/u04/oradata/lawtst5/index23.dbf',
  '/db/u04/oradata/lawtst5/index24.dbf'
;
ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE RENAME GLOBAL_NAME TO LAWTST5.WORLD;


Bill Gentry
DBA
Allina Health System
Minneapolis, MN 55403
612-775-1190
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, March 04, 2002 9:23 AM


 I'm going to take the datafiles from a cold backup and use them for a new
 database. However, to do this, I need to change the SID of the new db.
I've read
 that it's possible, but not how to do it. Is this an easy thing to do, or
would
 it be better to extract the tables and create the new db that way?

 Thanks for any help.
 Rick
 --
 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: Bill Gentry
  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: ftp from unix session to your local harddrive-How?

2002-03-04 Thread Tirumala, Surendra


Hi List,

I just want to extent discussion in this thread instead of opening a new
one...

How can we ftp on to a Network drive from unix machine?
We have an issue to automate the ftping of db audit files to a network drive
on monthly basis.

Any help is appreciated.

Thanks,
Surendra

-Original Message-
Sent: Tuesday, February 26, 2002 2:46 PM
To: Multiple recipients of list ORACLE-L


I am very happy with the product WS-FTP from www.ipswitch.com for
transfering files to and from unix /windoz. It has a trial period and
the registered product is very inexpensive.
ROR mª¿ªm

 [EMAIL PROTECTED] 02/25/02 03:45PM 
You'd need to run an FTP server on your local machine - do a search on
www.download.com 


-- 
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tirumala, Surendra
  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: Linux for Big(ish) Databases

2002-03-04 Thread Jesse, Rich


The problem with Linux on Sparc or Alpha is that Oracle doesn't have
binaries for them.  I've requested Alpha binaries, but haven't had any
response, despite the 1-2 business days response.  sigh

GL!

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA


-Original Message-
Sent: Monday, March 04, 2002 9:53 AM
To: Multiple recipients of list ORACLE-L




 We've got a new database to put together.  OLTP, 100-200 users, ~250Gb
 data.  We haven't decided on a platform for this yet.  Is Intel/Linux
 worth considering for this size of thing?

No reason why not. Might also want to consider linux
on a Sparc or Alpha.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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: ftp from unix session to your local harddrive-How?

2002-03-04 Thread Michael Cupp


Either need to ftp from the network drive, use samba, or run an ftp server on the 
network so you can ftp to it.

-Original Message-
Sent: Monday, March 04, 2002 11:44 AM
To: Multiple recipients of list ORACLE-L


Hi List,

I just want to extent discussion in this thread instead of opening a new one...

How can we ftp on to a Network drive from unix machine?
We have an issue to automate the ftping of db audit files to a network drive on 
monthly basis.

Any help is appreciated.

Thanks,
Surendra

-Original Message-
Sent: Tuesday, February 26, 2002 2:46 PM
To: Multiple recipients of list ORACLE-L


I am very happy with the product WS-FTP from www.ipswitch.com for transfering files to 
and from unix /windoz. It has a trial period and the registered product is very 
inexpensive. ROR mª¿ªm

 [EMAIL PROTECTED] 02/25/02 03:45PM 
You'd need to run an FTP server on your local machine - do a search on 
www.download.com 


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

Multimaster Replication Doubt...


1.
It is my understanding that Oracle 7.x has continuous purge
of the propogated deftrans. There is no option of scheduling
periodic purge at specific time. Am I correct?

2.
How to schedule continuous purge of propogated deftrans in
Oracle 8i from command line?

prompt  SCHEDULE PURGE AT MASTER SITE 
BEGIN
DBMS_DEFER_SYS.SCHEDULE_PURGE (
NEXT_DATE = SYSDATE,
INTERVAL = 'SYSDATE + 1/24',
DELAY_SECONDS = 0,
ROLLBACK_SEGMENT = '');
END;
/

Manual says set DELAY_SECONDS to 500,000 and set INTERVAL to a value less
than
DELAY_SECONDS. I could not understand exactly how this works...

+Rahul

  ___   ______   ___   ___
 /  /\ /  /\  /  /\ /  /\ /  /\
/  /::\   /  /::\/  /://  /://  /:/
   /  /:/\:\ /  /:/:|   /  /://  /://  /:/
  /  /::\ \:\   /  /:/|:|  /  /::\  __   /  /:/  ___   /  /:/
 /__/:/\:\_\:\ /__/::\|:| /__/:/\:\/ /\ /__/:/  /  /\ /__/:/
 \__\/~|::\/:/ \__\/\:\:| \__\/  \:\/:/ \  \:\ /  /:/ \  \:\
|  |:|::/ \__\::|  \__\::/   \  \:\  /:/   \  \:\
|  |:|\/   |  |:|  /  /:/ \  \:\/:/ \  \:\
|__|:| |__|:| /__/:/   \  \::/   \  \:\
 \__\|  \__\| \__\/ \__\/ \__\/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul Dandekar
  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: Planning Test Backup/Recovery - Tom

2002-03-04 Thread Eca Eca



Tom :

I am thinking something like that ..
I have already did the test at another machine ...
It worked right...

but the instance was diferente ...

So, in your opinion i need to create a instance, in the production machine, 
with the same parameters of production and apply the test there, righ ...

But , how can i to create a instance with the same parameters ?
Should i use the init.ora of the production instance ?

Thanks.
Eriovaldo


From: Mercadante, Thomas F [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Planning Test Backup/Recovery
Date: Mon, 04 Mar 2002 06:18:22 -0800

Eriovaldo,

If I were you, I would create a small test database on the production
machine, and perform backup/restore of that test database to be sure that
everything is working before I would try it on a production database.

Once you are convinced that everything works, schedule a down time where 
you
can test backup/restore of the production database.

I would also keep the test db on the production box, and as a regular
monthly schedule, test backup and restore of that database - just to make
sure that it continues to work.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, March 04, 2002 7:48 AM
To: Multiple recipients of list ORACLE-L


There should not be any problem to test the backup.
However we are testing the restores to another machine,
not on the production machine.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

  -Original Message-
  From:   Eca Eca [SMTP:[EMAIL PROTECTED]]
  Sent:   Mon, March 04, 2002 1:18 PM
  To: Multiple recipients of list ORACLE-L
  Subject:Planning Test Backup/Recovery
 
 
  Hi all :
 
  Does anyone have a planning for test backup and recovery ?
 
  I have the scripts and i am doing the backup and now we need to test it
  in production environment.
 
  I have tested it at another environment and got sucess.
 
  but at production ... it need to be very very careful ...
 
  Any sugestion ?
 
  Regards
 
  Eriovaldo
 
 
 
 
  _
  O MSN Photos é o jeito mais fácil de compartilhar, editar e imprimir 
suas
  fotos preferidas: http://photos.msn.com.br/support/worldwide.aspx
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Eca Eca
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?  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).




_
Converse com amigos on-line, experimente o MSN Messenger: 
http://messenger.msn.com.br

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

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

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

RE: Linux for Big(ish) Databases

2002-03-04 Thread Gogala, Mladen

May be they'll release the source code and distribute it under the GPL
license?

 -Original Message-
 From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
 Sent: Monday, March 04, 2002 12:03 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Linux for Big(ish) Databases

 The problem with Linux on Sparc or Alpha is that Oracle doesn't have
 binaries for them.  I've requested Alpha binaries, but haven't had any
 response, despite the 1-2 business days response.  sigh

 GL!

 Rich Jesse   System/Database Administrator
 [EMAIL PROTECTED]  Quad/Tech International, 
 Sussex, WI USA

 -Original Message-
 Sent: Monday, March 04, 2002 9:53 AM
 To: Multiple recipients of list ORACLE-L

  We've got a new database to put together.  OLTP, 100-200 
 users, ~250Gb
  data.  We haven't decided on a platform for this yet.  Is 
 Intel/Linux
  worth considering for this size of thing?

 No reason why not. Might also want to consider linux
 on a Sparc or Alpha.
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Jesse, Rich
   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).

EXTENTS?


Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema



_
Join the worlds largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

[Q] difference between DEveloper 6i and 6i rel2?

2002-03-04 Thread dist cash


I just checked ORACLE OTN site and their has ORACLE Developer 6i Release 2
can download.  The CD pack we have is Developer 6i.  Can anyone tell me
what is difference between 6i and 6i rel2?

Thanks

_
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: dist cash
  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: New iMac as dba workstation

2002-03-04 Thread Jan Pruner


Yes, thank You.

JP

On Mon 4. March 2002 15:38, you wrote:
 I'm using a Titanium G4 as a workstation, does that count?  ;)

 I've had marginal luck using products like SQLGrinder (native OSX app,
 uses JDBC for connectivity).  Ultimately though, I fell back to using
 Tora X-forwarded back to my box (I'm running XDarwin on top of Agua).  I

 This is all part of a grand experiment, and I have to say that for me
 it's a marginal success at best.  The cut-and-paste between Aqua and
 XDarwin is poor, which makes Tora only marginally useful for me.  I
 would kill for OCI libs for OSX and a port of Golden.

 George

 On Monday, March 4, 2002, at 06:23 AM, Jan Pruner wrote:
  Is anybody using iMac as workstation (db admin,  programming Oracle
  stuff
  etc.)?
  Is there net8 client verison for PowerPC or have I to run sqlplus (or
  TOra)
  remote?
 
  Thanks
 
  JP
  --
  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).
 
  ---
  --
  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).

 // George Schlossnagle
 // Principal Consultant
 // OmniTI, Inchttp://www.omniti.com
 // (c) 301.343.6422   (e) [EMAIL PROTECTED]
 // 1024D/1100A5A0  1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0
-- 
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: replication question

2002-03-04 Thread James Ambursley




Is 
replication faster than a standby database.As I understand it, the standby 
database will be receive arch logs at preset intervals. Does replication 
have the same functionality and about how much data is sent to the replicated 
site.



  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: 
  Monday, March 04, 2002 10:44 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: replication question
  The 
  way I see it . the question comes down to whether or not you need 
  two way replication or just one way. If both databases can update 
  those tables and you need them synced between the databases then Advanced 
  Replication would be the route. If all you need are data changes 
  from 1 database to be replicated to another database then simple replication 
  is all you need.
  
-Original Message-From: Rahul Dandekar 
[mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 6:43 
AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
replication question
Depends on your need.
You can have read only snapshots, updatable 
snapshots
or multimaster...
Again if you think of multimaster... then you 
would need to make decision
based on your application requirements about 
sync or async

I donot have any expereince of snapshot 
replication.
But, if you are planning multimaster 
replication, then better
spend a couple of months studying it and 
testing on test boxes...

Make 100% sure that your 
applicationreally needs the replication
and there is no other simpler 
option...

Just 2 cents...

+Rahul

  - Original Message - 
  From: 
  Bunyamin K. Karadeniz 
  To: Multiple 
  recipients of list ORACLE-L 
  Sent: Monday, March 04, 2002 3:33 
  AM
  Subject: replication question
  
  Dear Gurus,
  The clients will enter records to a database 
  all day and I will update the other database . 
  I need to replicate 10 tables in a database 
  to other database at a specific time. 
  
  Do I need Advanced replication or basic 
  replication . ?
  How can I understand that replication is 
  supported in my both databases. ?
  
  Bunyamin

RE: EXTENTS?

2002-03-04 Thread Nelson Flores

Title: RE: EXTENTS?





it´s the other way around... how many db blocks in an extent.
an extent is a number of contiguous data blocks ...



-Mensaje original-
De: Seema Singh [mailto:[EMAIL PROTECTED]]
Enviado el: Lunes, 04 de Marzo de 2002 15:19
Para: Multiple recipients of list ORACLE-L
Asunto: EXTENTS?



Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema




_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


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

Re: EXTENTS?

2002-03-04 Thread Igor Neyman


Depends on the size of the extent.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]
  

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, March 04, 2002 1:18 PM


Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema



_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

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


Depends on your extent size    

-Original Message-
Sent: Monday, March 04, 2002 12:19 PM
To: Multiple recipients of list ORACLE-L


Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema



_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

-- 
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).
-- 
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: Planning Test Backup/Recovery - Tom

2002-03-04 Thread Mercadante, Thomas F


Eriovaldo,

If you already have a backup script, then you need to test it on the
production machine.  The test db you create does not necessarily have to be
the same size as the production db (init.ora params can be smaller).  But
what you are testing is that your backup scripts run as expected on the
production machine.
  Your init.ora params can be smaller (like a smaller SGA) to prove that it
works ok.

Hope this helps

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, March 04, 2002 12:39 PM
To: Multiple recipients of list ORACLE-L



Tom :

I am thinking something like that ..
I have already did the test at another machine ...
It worked right...

but the instance was diferente ...

So, in your opinion i need to create a instance, in the production machine, 
with the same parameters of production and apply the test there, righ ...

But , how can i to create a instance with the same parameters ?
Should i use the init.ora of the production instance ?

Thanks.
Eriovaldo


From: Mercadante, Thomas F [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Planning Test Backup/Recovery
Date: Mon, 04 Mar 2002 06:18:22 -0800

Eriovaldo,

If I were you, I would create a small test database on the production
machine, and perform backup/restore of that test database to be sure that
everything is working before I would try it on a production database.

Once you are convinced that everything works, schedule a down time where 
you
can test backup/restore of the production database.

I would also keep the test db on the production box, and as a regular
monthly schedule, test backup and restore of that database - just to make
sure that it continues to work.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, March 04, 2002 7:48 AM
To: Multiple recipients of list ORACLE-L


There should not be any problem to test the backup.
However we are testing the restores to another machine,
not on the production machine.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

  -Original Message-
  From:   Eca Eca [SMTP:[EMAIL PROTECTED]]
  Sent:   Mon, March 04, 2002 1:18 PM
  To: Multiple recipients of list ORACLE-L
  Subject:Planning Test Backup/Recovery
 
 
  Hi all :
 
  Does anyone have a planning for test backup and recovery ?
 
  I have the scripts and i am doing the backup and now we need to test it
  in production environment.
 
  I have tested it at another environment and got sucess.
 
  but at production ... it need to be very very careful ...
 
  Any sugestion ?
 
  Regards
 
  Eriovaldo
 
 
 
 
  _
  O MSN Photos é o jeito mais fácil de compartilhar, editar e imprimir 
suas
  fotos preferidas: http://photos.msn.com.br/support/worldwide.aspx
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Eca Eca
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?  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: EXTENTS?

2002-03-04 Thread Rachel Carmichael


you have it backwards... extents don't fit into blocks, blocks fit into
extents

and extent size is dependent on tablespace storage parameters and
objectg storage parameters


--- Seema Singh [EMAIL PROTECTED] wrote:
 Hi
 If DB block size is 8k then how many extents in one db block?
 Thanks
 -Seema
 
 
 
 _
 Join the worlds largest e-mail service with MSN Hotmail. 
 http://www.hotmail.com
 
 -- 
 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).


__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
-- 
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).

RE: Linux for Big(ish) Databases

2002-03-04 Thread lembark




-- Jesse, Rich [EMAIL PROTECTED] on 03/04/02 09:03:28 -0800

 The problem with Linux on Sparc or Alpha is that Oracle doesn't have
 binaries for them.  I've requested Alpha binaries, but haven't had any
 response, despite the 1-2 business days response.  sigh

Remember: They're Oracle, you're not. Be glad they take
their precious time to not answer your questions!

The main problem with Intel boxes is a narrow I/O bus and
latency issues with the chipsets. The VIA set tends to be
faster so far as I've seen. Combined with good SCSI boards
and LVM striping you can get decent throughput, but it'll
never match something like a V-box or 6500 for full-bore
speed. The real alpha motherboards (not NT compatable
toys) use wide I/O channels to keep the chip fed.

If you're considering linux look carefully at clusters.
They can be an immense help dealing with large databases.

--
Steven Lembark  2930 W. Palmer
Workhorse Computing  Chicago, IL 60647
   +1 800 762 1582
-- 
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).

Automatic PGA Memory Management via PGA_AGGREGATE_TARGET paramete

2002-03-04 Thread David Wagoner

I just stumbled upon the Automatic PGA Memory Management section of
the 9i docs. Ive never heard of
this before. Does anyone know how
long its been around? Anyone
using it found any bugs, concerns, etc.?

Granted, this is intended for *dedicated* server mode, it seems
like a good option for our Test databases and perhaps other databases that have
only a handful of users and dont require MTS. By setting PGA_AGGREGATE_TARGET=X, where X can be a value in
K, M, or G, Oracle will automatically distribute this memory allocation to
dedicated sessions instead of using SORT_AREA_SIZE. Heres an excerpt from the docs:

Oracle does
not recommend using the SORT_AREA_SIZE parameter unless the instance is
configured with the shared server option.
Oracle recommends that you enable automatic sizing of SQL working areas
by setting PGA_AGGREGATE_TARGET instead. SORT_AREA_SIZE is retained for backward compatibility.

Learn something
new every day in Oracle land

david

David B. Wagoner

Database Administrator

Arsenal Digital Solutions Worldwide, Inc.

8000 Regency
Parkway, Suite 110

Cary, NC
27511-8582

Tel. (919)
466-6723

Fax (919)
466-6783

Mobile (919)
225-4962

[EMAIL PROTECTED]

http://www.arsenaldigital.com/

*** NOTICE ***

This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, 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 the sender by phone or email and delete this e-mail message
from your computer. Thank you.

RE: EXTENTS?

2002-03-04 Thread Nick Wagner

Title: RE: EXTENTS?





I'm going to say 1. I don't think you can have multiple tables in the same DB block. 


-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 10:19 AM
To: Multiple recipients of list ORACLE-L
Subject: EXTENTS?



Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema




_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


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

Re: EXTENTS?

2002-03-04 Thread Jared . Still


None.

The lowest level of granularity of storage in Oracle is a block.

block-extent-segment

Time to hit the books, the Concepts manual in this case.

Jared






Seema Singh [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/04/02 10:18 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:EXTENTS?


Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema



_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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



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

Names server

2002-03-04 Thread Yahoo




Hi ALL:
 Is any one using 
names server out there? How the it works? Any infor are 
wellcome.

How TO KNOW TABLE SIZE


Hi
How can I know how much space a table occupied?
Can BLOCKS columns in dba_tables helps?
Or I have to use dba_extents and dba_segments tables?
Thx
-Seema



_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

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

RE: replication question




I have 
used both. 

Replication, like archive log movement , happens whenever you set it up 
to happen. That can be anywhere from every minute to once a day to 
beyond. It just depends on your needs. In the case of my old job, we 
had replication happeningat different times for different 
tables. Our key table was replicating IMMEDIATELY uponany 
changes to the parent table. This happened via 
trigger.Other , not so important tables, would replicate at 
anywhere from 30 to 60 
minutes. We did this using scheduled jobs.

I see 
two realnice advantages ofreplicated databases. One, they are 
accessible.i.e. you can run reports, queries, etc on them. 
They are nothing more than instancesthat get updated via a foreign 
database. Two,depending on what kind of software you use, you can 
update the database from an outside source. We used to have data 
sent down from our DB2 database into our Oracle database using an oracle product 
called Replication Services (nothing more than triggers and a specific data 
structure) and an IBM product called Data Propogator. 

Archive log transport for standbys can happen in 
multiple ways also. The newer oracle versions support direct archiving 
from a production database to a standby database. I have not tried this 
yet but we are looking into it. Our current standby databases are 
brought up to date with a shell script that is scheduled via cron every 20 
minutes.

The thing about the standbys, they areall or 
nothing ... you can not just say I want only tables 1-10 to be updated. 
They all are. Also, in the older oracle versions, the standbys could not 
be accessed via software so you could not use them as any sort of read only 
database. This is not the case in a replicated database. But, 
they are also very easy to rebuild and resetup. Just copy your production 
files over, create a standby control file, and bring the databse up in standby 
mode. Very easy.

Now... which would I recommend ??? Depends 
on your needs.

If you really need to access that copy of the database 
for other purposes and you only want certain tables to be updated, then I would 
consider replication. If, on the other hand, you do not have to 
access the data (until such a time as your production gets killed and you need 
your standby up) and you need a fast way to rebuild the second database, I would 
suggest the Standby approach.

Kevin

  -Original Message-From: James Ambursley 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 12:24 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  replication question
  Is 
  replication faster than a standby database.As I understand it, the 
  standby database will be receive arch logs at preset intervals. Does 
  replication have the same functionality and about how much data is sent to the 
  replicated site.
  
  
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: 
Monday, March 04, 2002 10:44 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: replication question
The way I see it . the question comes down to whether or 
not you need two way replication or just one way. If both 
databases can update those tables and you need them synced between the 
databases then Advanced Replication would be the route. If all 
you need are data changes from 1 database to be replicated to another 
database then simple replication is all you need.

  -Original Message-From: Rahul Dandekar 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 
  6:43 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: replication question
  Depends on your need.
  You can have read only snapshots, updatable 
  snapshots
  or multimaster...
  Again if you think of multimaster... then you 
  would need to make decision
  based on your application requirements about 
  sync or async
  
  I donot have any expereince of snapshot 
  replication.
  But, if you are planning multimaster 
  replication, then better
  spend a couple of months studying it and 
  testing on test boxes...
  
  Make 100% sure that your 
  applicationreally needs the replication
  and there is no other simpler 
  option...
  
  Just 2 cents...
  
  +Rahul
  
- Original Message - 
From: 
Bunyamin K. Karadeniz 
To: Multiple recipients of list 
ORACLE-L 
Sent: Monday, March 04, 2002 3:33 
AM
Subject: replication question

Dear Gurus,
The clients will enter records to a 
database all day and I will update the other database . 
I need to replicate 10 tables in a database 
to other database at a specific time. 

Do I need Advanced replication or 
basic replication . ?
How can I understand that replication is

TABLE SIZE?


Hi
If I have value num_rows and avg_row_len then can I know the size of tables?
Table size(Bytes)=num_rows*avg_row_len

Thx
-seema


_
Join the worlds largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

RE: Automatic PGA Memory Management via PGA_AGGREGATE_TARGET para

2002-03-04 Thread Freeman, Robert


I cover this topic and many others in my Oracle9i New Features book :-))
 
RF
 

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.

 

-Original Message-
Sent: Monday, March 04, 2002 1:58 PM
To: Multiple recipients of list ORACLE-L



I just stumbled upon the Automatic PGA Memory Management section of the 9i
docs.  I've never heard of this before.  Does anyone know how long it's been
around?  Anyone using it found any bugs, concerns, etc.?

 

Granted, this is intended for *dedicated* server mode, it seems like a good
option for our Test databases and perhaps other databases that have only a
handful of users and don't require MTS.  By setting PGA_AGGREGATE_TARGET=X,
where X can be a value in K, M, or G, Oracle will automatically distribute
this memory allocation to dedicated sessions instead of using
SORT_AREA_SIZE.  Here's an excerpt from the docs:

 

Oracle does not recommend using the SORT_AREA_SIZE parameter unless the
instance is configured with the shared server option.  Oracle recommends
that you enable automatic sizing of SQL working areas by setting
PGA_AGGREGATE_TARGET instead.  SORT_AREA_SIZE is retained for backward
compatibility.

 

 

Learn something new every day in Oracle land...

 

 

david

 

David B. Wagoner

Database Administrator

Arsenal Digital Solutions Worldwide, Inc.

8000 Regency Parkway, Suite 110

Cary, NC 27511-8582

Tel. (919) 466-6723

Fax (919) 466-6783

Mobile (919) 225-4962

[EMAIL PROTECTED] 

 http://www.arsenaldigital.com/ http://www.arsenaldigital.com/

 

 
***  NOTICE  ***

This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged, 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 the sender by phone or email and delete this e-mail
message from your computer.  Thank you.

 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Freeman, Robert 
  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: EXTENTS?

2002-03-04 Thread Godlewski, Melissa

Title: RE: EXTENTS?





The Server Concepts manual Chapter on Data Blocks, Extents, and Segments would be a helpful Chapter to read.


-Original Message-
From: Kevin Lange [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 1:28 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: EXTENTS?



Depends on your extent size  


-Original Message-
Sent: Monday, March 04, 2002 12:19 PM
To: Multiple recipients of list ORACLE-L



Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema




_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


-- 
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).
-- 
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: replication question




Well, you could open standby DB only for 
read only access (8i) whereas in replication, both or
all (more than 2) databases could be up 
and open to users all the times.

Each DML causes substantial overhead as 
each transaction needs to be propogated and applied
at all the master sites (whereas 
inOracle Parallel Server,there is centralized database accessed 

by multiple instances, there is no need 
for this).

So, if you donot need two databases at two 
geographically separate locations, open for users,
then Standby DB or OPSmight be 
better option. Again, in OPS, if the hardware cluster fails then
you are in trouble...

About speed, if you could tune up sending 
of logs and application of it, then Standby database
would consume substantially lesser 
resources than replication, hence higher throughput...
The primary database in Standby DB just 
needs to send the archivelogs (simple file transfer)
and then log application happens on the 
secondary server...
Whereas, in replication, the database 
would have to propogate and apply each and every
transaction individually

+Rahul

  - Original Message - 
  From: 
  James 
  Ambursley 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, March 04, 2002 1:24 
PM
  Subject: RE: replication question
  
  Is 
  replication faster than a standby database.As I understand it, the 
  standby database will be receive arch logs at preset intervals. Does 
  replication have the same functionality and about how much data is sent to the 
  replicated site.
  
  
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: 
Monday, March 04, 2002 10:44 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: replication question
The way I see it . the question comes down to whether or 
not you need two way replication or just one way. If both 
databases can update those tables and you need them synced between the 
databases then Advanced Replication would be the route. If all 
you need are data changes from 1 database to be replicated to another 
database then simple replication is all you need.

  -Original Message-From: Rahul Dandekar 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 
  6:43 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: replication question
  Depends on your need.
  You can have read only snapshots, updatable 
  snapshots
  or multimaster...
  Again if you think of multimaster... then you 
  would need to make decision
  based on your application requirements about 
  sync or async
  
  I donot have any expereince of snapshot 
  replication.
  But, if you are planning multimaster 
  replication, then better
  spend a couple of months studying it and 
  testing on test boxes...
  
  Make 100% sure that your 
  applicationreally needs the replication
  and there is no other simpler 
  option...
  
  Just 2 cents...
  
  +Rahul
  
- Original Message - 
From: 
Bunyamin K. Karadeniz 
To: Multiple recipients of list 
ORACLE-L 
Sent: Monday, March 04, 2002 3:33 
AM
Subject: replication question

Dear Gurus,
The clients will enter records to a 
database all day and I will update the other database . 
I need to replicate 10 tables in a database 
to other database at a specific time. 

Do I need Advanced replication or 
basic replication . ?
How can I understand that replication is 
supported in my both databases. ?

Bunyamin

Re: EXTENTS?


Isn't the minimum extent size something like 5 times the DB_BLOCK_SIZE?

If that's true then maximum .2 extents in DB block.

Or you are looking for this info?

   db_block_size  Max Extents 
   -- --- 
2K121 
4K249 
8K505 
   16K   1017 
   32K   2041


+Rahul

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, March 04, 2002 1:28 PM


 Depends on your extent size 
 
 -Original Message-
 Sent: Monday, March 04, 2002 12:19 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi
 If DB block size is 8k then how many extents in one db block?
 Thanks
 -Seema
 
 
 
 _
 Join the world's largest e-mail service with MSN Hotmail.
 http://www.hotmail.com
 
 --
 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).
 --
 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).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul Dandekar
  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 KNOW TABLE SIZE

2002-03-04 Thread Bill Gentry


This is what I use.  Hope it helps.

spool table_space_usage.log 
set pagesize 0  
set linesize 80   
select   substr (segment_name,1,20)   
  ,bytes / 1024 kbytes 
  ,extents 
  ,blocks  
  from sys.dba_segments  
  where  owner = 'LAWSON'
   and segment_name like 'AR%'  
   and segment_type = 'TABLE'
  order by  segment_name 
/
spool off;   

Bill Gentry
DBA
Allina Health System
Minneapolis, MN 55403
612-775-1190
[EMAIL PROTECTED]
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, March 04, 2002 1:08 PM


 Hi
 How can I know how much space a table occupied?
 Can BLOCKS columns in dba_tables helps?
 Or I have to use dba_extents and dba_segments tables?
 Thx
 -Seema
 
 
 
 _
 MSN Photos is the easiest way to share and print your photos: 
 http://photos.msn.com/support/worldwide.aspx
 
 -- 
 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).

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

2002-03-04 Thread Mercadante, Thomas F


Seema,

You got it backwards.

If Db Block Size is 8k, and you create a table with it's initial extent of
32k, the you have 4 db blocks making up the extent.

An Extent is composed of one or more Db Blocks.  A Db Block is defined when
you create the db (although I heard that different tablespaces can have
different Db Block sizes in 9i - correct anybody?)

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Monday, March 04, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L


Hi
If DB block size is 8k then how many extents in one db block?
Thanks
-Seema



_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

-- 
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).
-- 
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: EXTENTS?

2002-03-04 Thread Rachel Carmichael


nick, you're thinking segments not extents.

and I was off as well, if your extent size is less than the blocksize
then you can have more than one extent in a block (divide the block
size by the extent size and round DOWN)

in general though, extents are not usually sized as small as the
database block size


--- Nick Wagner [EMAIL PROTECTED] wrote:
 I'm going to say 1. I don't think you can have multiple tables in the
 same
 DB block.  
 
 -Original Message-
 Sent: Monday, March 04, 2002 10:19 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi
 If DB block size is 8k then how many extents in one db block?
 Thanks
 -Seema
 
 
 
 _
 Join the world's largest e-mail service with MSN Hotmail. 
 http://www.hotmail.com
 
 -- 
 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).
 


__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
-- 
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).

Re: How TO KNOW TABLE SIZE

2002-03-04 Thread Gene Gurevich


I usually do

select sum(bytes) from dba_Segments
where segment_name = 'TABLENAME';

HTH
--- Seema Singh [EMAIL PROTECTED] wrote:
 Hi
 How can I know how much space a table occupied?
 Can BLOCKS columns in dba_tables helps?
 Or I have to use dba_extents and dba_segments
 tables?
 Thx
 -Seema
 
 
 

_
 MSN Photos is the easiest way to share and print
 your photos: 
 http://photos.msn.com/support/worldwide.aspx
 
 -- 
 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).


=


__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.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).

LIKE and % operator

2002-03-04 Thread Nguyen, David M


I am running oracle8i on solaris8.  I have a word ( General ) in my column
named subject, I try to run SQL using LIKE and % to grep any data having
the word ( General ) but it displayed no rows selected.  Does someone have
any idea why?  Below is my SQL I used.

SQL select * from sonusrpt where subject like '%general%';

no rows selected.


Thanks,
David
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nguyen, David M
  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: TABLE SIZE?

2002-03-04 Thread Ora NT DBA


This would be true if and only if you ignored block header space and ignored
free space in blocks.

What do you want to know

The number of blocks under the high water mark?

The total size of extents allocated to the table segment?

The space allocated within those blocks?

The total number of blocks allocated to the table?

Any one of these could be answered none of them would be the answer you 
arrived at.

John


John

[EMAIL PROTECTED] wrote:

 Hi
 If I have value num_rows and avg_row_len then can I know the size of 
 tables?
 Table size(Bytes)=num_rows*avg_row_len

 Thx
 -seema


 _
 Join the world's largest e-mail service with MSN Hotmail. 
 http://www.hotmail.com



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ora NT DBA
  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 KNOW TABLE SIZE

2002-03-04 Thread Tomita Koga, Alex - (Per)


Check this note from metalink.


***

Title: Script to compute table size

Disclaimer:
This script is provided for educational purposes only. It is NOT
supported by Oracle Support Services.  The script has been
tested and appears to work as intended.  However, you should always
test any script before relying on it.

PROOFREAD THIS SCRIPT PRIOR TO USING IT!  Due to differences in the
way text editors, email packages and operating systems handle text
formatting (spaces, tabs and carriage returns), this script may not
be in an executable state when you first receive it.  Check over the 
script to ensure that errors of this type are corrected.

Abstract:
It is sometimes necessary to calculate the exact size (exact 
number of bytes) of a table. 

The function 'VSIZE' gives the exact number of bytes allocated
by Oracle for data.
 
For example, if you have a table called 'table1' with n columns  
say, 'col1', 'col2',  , 'coln', execute the following SQL
statement to find the exact size of the table:
  
SELECT SUM(VSIZE(col1)) + SUM(VSIZE(col2)) + ... + 
   SUM(VSIZE(coln)) FROM table1;

In the scott/tiger schema, the following SQL statement can be
executed to find the exact table size of the 'DEPT' table:

SQL SELECT SUM(VSIZE(deptno)) + SUM(VSIZE(dname)) +
 SUM(VSIZE(loc)) FROM dept;

SUM(VSIZE(DEPTNO))+SUM(VSIZE(DNAME))+SUM(VSIZE(LOC))

 88
Requirements:
None

Version Testing:
This script was tested on Oracle 7.3.3 to 8.1.6 and SQL*Plus 


***


ATT Latin America
Alex Tomita Koga - ITS
e-mail: [EMAIL PROTECTED]
phone: (51) 1 610- extension 2619
Av. Larco 1301 Torre Parque Mar - Miraflores




-Mensaje original-
De: Seema Singh [mailto:[EMAIL PROTECTED]]
Enviado el: Lunes, 04 de Marzo de 2002 02:08 p.m.
Para: Multiple recipients of list ORACLE-L
Asunto: How TO KNOW TABLE SIZE


Hi
How can I know how much space a table occupied?
Can BLOCKS columns in dba_tables helps?
Or I have to use dba_extents and dba_segments tables?
Thx
-Seema



_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tomita Koga, Alex  - (Per)
  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: LIKE and % operator

2002-03-04 Thread Guidry, Chris


Try,

SQL select * from sonusrpt where subject like '%GENERAL%';
or
SQL select * from sonusrpt where lower(subject) like '%general%';


--
Chris J. Guidry  P.Eng. EE
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]


 -Original Message-
 From: Nguyen, David M [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, March 04, 2002 01:33 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  LIKE  and % operator
 
 I am running oracle8i on solaris8.  I have a word ( General ) in my column
 named subject, I try to run SQL using LIKE and % to grep any data having
 the word ( General ) but it displayed no rows selected.  Does someone have
 any idea why?  Below is my SQL I used.
 
 SQL select * from sonusrpt where subject like '%general%';
 
 no rows selected.
 
 
 Thanks,
 David
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Nguyen, David M
   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: Guidry, Chris
  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: Names server

2002-03-04 Thread Wong, Bing




Names 
server will beobsolete in 9i, I think.

  -Original Message-From: Yahoo 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 11:33 
  AMTo: Multiple recipients of list ORACLE-LSubject: Names 
  server
  Hi ALL:
   Is any one using 
  names server out there? How the it works? Any infor are 
  wellcome.

RE: LIKE and % operator

2002-03-04 Thread Shaw John-P55297


The search is case sensitive, try something like
select * from sonusrpt where upper(subject) like '%GENERAL%';

-Original Message-
Sent: Monday, March 04, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L


I am running oracle8i on solaris8.  I have a word ( General ) in my column
named subject, I try to run SQL using LIKE and % to grep any data having
the word ( General ) but it displayed no rows selected.  Does someone have
any idea why?  Below is my SQL I used.

SQL select * from sonusrpt where subject like '%general%';

no rows selected.


Thanks,
David
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nguyen, David M
  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: Shaw John-P55297
  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: EXTENTS?

2002-03-04 Thread bill thater


[EMAIL PROTECTED] wrote:



in general though, extents are not usually sized as small as the
database block size

should extents be multiples of block size?


-- 
--
Bill Shrek Thater  ORACLE DBA
[EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

God is real, unless declared integer.






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

2002-03-04 Thread Rajesh . Rao



I am confused. Are you talking of multiple extents in a block? Throws my
fundamentals topsyturvy.

Raj




   
 
Rachel 
 
Carmichael   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]
wisernet100@cc:   
 
YAHOO.COM   Subject: RE: EXTENTS? 
 
Sent by:   
 
root@fatcity.  
 
com
 
   
 
   
 
March 04,  
 
2002 03:13 PM  
 
Please 
 
respond to 
 
ORACLE-L   
 
   
 
   
 




nick, you're thinking segments not extents.

and I was off as well, if your extent size is less than the blocksize
then you can have more than one extent in a block (divide the block
size by the extent size and round DOWN)

in general though, extents are not usually sized as small as the
database block size


--- Nick Wagner [EMAIL PROTECTED] wrote:
 I'm going to say 1. I don't think you can have multiple tables in the
 same
 DB block.

 -Original Message-
 Sent: Monday, March 04, 2002 10:19 AM
 To: Multiple recipients of list ORACLE-L


 Hi
 If DB block size is 8k then how many extents in one db block?
 Thanks
 -Seema



 _
 Join the world's largest e-mail service with MSN Hotmail.
 http://www.hotmail.com

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



__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
--
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).




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

Sun Cluster and VCS failover

2002-03-04 Thread Nick Wagner




Situation: Sun 
Cluster, or VERITAS Cluster. Oracle 8, 8i, or 9i
2 node Sun E6500s w/ 
8 CPUs

If the primary node 
fails, how long does it take before a user is able to connect to the secondary 
node, and continue their activity? I'm sure reality, and marketing 
times are different... I'm really interested in reality times, but at this point 
either would be nice. 

Thanks!! 


Nick

RE: LIKE and % operator

2002-03-04 Thread Whittle Jerome Contr NCI


David,

If you have General with an upper case G and are looking for general with a lower case 
g, you won't return any records. It's that old case sensitive thing.

Try this:

select * from sonusrpt where Upper(subject) like '%GENERAL%';

Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145

 -Original Message-
 From: Nguyen, David M [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, March 04, 2002 2:33 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  LIKE  and % operator
 
 I am running oracle8i on solaris8.  I have a word ( General ) in my column
 named subject, I try to run SQL using LIKE and % to grep any data having
 the word ( General ) but it displayed no rows selected.  Does someone have
 any idea why?  Below is my SQL I used.
 
 SQL select * from sonusrpt where subject like '%general%';
 
 no rows selected.
 
 Thanks,
 David
 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
  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: LIKE and % operator

2002-03-04 Thread Viktor


Try changing the query to say:

select * 
from sonusrpt 
where lower(subject) like '%general%'
/


--- Nguyen, David M [EMAIL PROTECTED] wrote:
 I am running oracle8i on solaris8.  I have a word (
 General ) in my column
 named subject, I try to run SQL using LIKE and %
 to grep any data having
 the word ( General ) but it displayed no rows
 selected.  Does someone have
 any idea why?  Below is my SQL I used.
 
 SQL select * from sonusrpt where subject like
 '%general%';
 
 no rows selected.
 
 
 Thanks,
 David
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.com
 -- 
 Author: Nguyen, David M
   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!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viktor
  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: LIKE and % operator

2002-03-04 Thread Suzy Vordos



Case needs to be considered, eg., '%General%' or use of upper/lower
functions.

Nguyen, David M wrote:
 
 I am running oracle8i on solaris8.  I have a word ( General ) in my column
 named subject, I try to run SQL using LIKE and % to grep any data having
 the word ( General ) but it displayed no rows selected.  Does someone have
 any idea why?  Below is my SQL I used.
 
 SQL select * from sonusrpt where subject like '%general%';
 
 no rows selected.
 
 Thanks,
 David
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Nguyen, David M
   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: Suzy Vordos
  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: LIKE and % operator

2002-03-04 Thread Rick_Cale



select * from sonusrpt where UPPER(subject) like '%GENERAL%';

Rick



   

Nguyen,   

David M To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]   
david.m.nguycc:   

[EMAIL PROTECTED]   Subject: LIKE  and % operator 

Sent by:   

root@fatcity.  

com

   

   

03/04/2002 

03:33 PM   

Please 

respond to 

ORACLE-L   

   

   





I am running oracle8i on solaris8.  I have a word ( General ) in my column
named subject, I try to run SQL using LIKE and % to grep any data having
the word ( General ) but it displayed no rows selected.  Does someone have
any idea why?  Below is my SQL I used.

SQL select * from sonusrpt where subject like '%general%';

no rows selected.


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

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

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




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

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

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

RE: LIKE and % operator

2002-03-04 Thread Bellows, Bambi


Looks like you're running into a case-sensitivity issue.  Try 

select * from sonusrpt where upper(subject) like upper('%general%');

HTH.
-Original Message-
Sent: Monday, March 04, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L

I am running oracle8i on solaris8.  I have a word ( General ) in my column
named subject, I try to run SQL using LIKE and % to grep any data having
the word ( General ) but it displayed no rows selected.  Does someone have
any idea why?  Below is my SQL I used.

SQL select * from sonusrpt where subject like '%general%';

no rows selected.


Thanks,
David
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nguyen, David M
  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: Bellows, Bambi
  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: LIKE and % operator

2002-03-04 Thread Pardee, Roy E


Are the results any different if you say

select * from sonusrpt where subject like '%GENERAL%';

?

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Monday, March 04, 2002 12:33 PM
To: Multiple recipients of list ORACLE-L


I am running oracle8i on solaris8.  I have a word ( General ) in my column
named subject, I try to run SQL using LIKE and % to grep any data having
the word ( General ) but it displayed no rows selected.  Does someone have
any idea why?  Below is my SQL I used.

SQL select * from sonusrpt where subject like '%general%';

no rows selected.


Thanks,
David
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nguyen, David M
  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: Pardee, Roy E
  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: Names server

2002-03-04 Thread Freeman, Robert


Names server is depreciated in 9i, but still there.
They were going to remove it, but I think there was a bit of a backlash, so
they have delayed
the removal.
OID (LDAP) is the replacement.
 
We use names server here, have found it to be pretty stable and reduced
tnsnames.ora
administration nicely.
 
RF
 

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.

 

-Original Message-
Sent: Monday, March 04, 2002 3:53 PM
To: Multiple recipients of list ORACLE-L


Names server will be obsolete in 9i, I think.

-Original Message-
Sent: Monday, March 04, 2002 11:33 AM
To: Multiple recipients of list ORACLE-L


Hi ALL:
Is any one using names server out there?  How the it works?  Any infor
are wellcome.

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

Defaults for ANALYZE

2002-03-04 Thread Jesse, Rich


Hi all,

From my testing in 8.1.6 and 8.1.7, it appears to me that the ANALYZE
defaults to FOR ALL COLUMNS SIZE 1.  I found this by checking the
DBA_TAB_HISTOGRAMS view before and after an ANALYZE TABLE bleah COMPUTE
STATISTICS.  I then compared those results to a before/after using
DBMS_STATS first with METHOD_OPT = NULL, then METHOD_OPT = 'FOR ALL
COLUMNS SIZE 1'.

So, can anyone tell me where the hell this is documented for the ANALYZE
command?  It's not in Oracle8i SQL Reference under ANALYZE, where one
would think it should be, nor does it show up in a search on
http://tahiti.oracle.com.  Same for Metaclink.

I've been pulling my hair out trying to determine why I've been getting
different explain plans between DBMS_STATS and ANALYZE, until I discovered
this.  DBA need beer.  One Three Floyd's left in fridge.  M...

TIA,
Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA
http://www.realbeer.com/battleofthebeers
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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: ORA-600 [1158] on 8.1.7

2002-03-04 Thread Veronica Levin


Hi, 
I'm working on Oracle 8.1.7.2 , AIX 4.3.3 and haven't got any problems...
had a lot before the patch, but not ORA-600.
I suggest you apply the patch and monitor the instance.
Hope this helps!

Saludos,
Verónica Levin Enríquez.
Compañía Cervecera de Nicaragua.


-Mensaje original-
De: Mohammad Rafiq [mailto:[EMAIL PROTECTED]]
Enviado el: Thursday, February 14, 2002 11:54 AM
Para: Multiple recipients of list ORACLE-L
Asunto: Re: ORA-600 [1158] on 8.1.7


With every parchset they provide list of fixes in readme file. You can check

it before downloading or applying patches...However, it is better to go to 
8.1.7.2 which has lot of fixes...

Regards
Rafiq




Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 14 Feb 2002 08:23:34 -0800

Hi,

We have a database running version 8.1.7.0 on AIX 4.3.3 that intermittently
crashes with an
ORA-600 [1158] error. Oracle's ORA-600 lookup tool did not have any hits.
There was no specific
resolution from Oracle support for this error - just a general suggestion to
upgrade to the latest
patch  levels.  This is something we are reluctant to do without specific 
patch
information addressing
our problem.

Has anyone seen this error on 8.1.7 before?

Regards,

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




MOHAMMAD RAFIQ


_
Join the world's largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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

2002-03-04 Thread Jack C. Applewhite


Yes, this one will get a lot of traffic, I'll bet.

I just looked in the 8.1.7 docs (SQL Reference - Storage Clause) and it says
that the minimum INITIAL is 2 DB blocks for non-bitmapped segments, 3 for
bitmapped segments.  The minimum for NEXT is 1 DB block.

Unlesss it's a new 9i feature, a DB block can belong to one and only one
Extent.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
[EMAIL PROTECTED]
Sent: Monday, March 04, 2002 3:13 PM
To: Multiple recipients of list ORACLE-L



I am confused. Are you talking of multiple extents in a block? Throws my
fundamentals topsyturvy.

Raj




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  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 are the snapshots refreshed ?

2002-03-04 Thread dgoulet


Bunyamin,

OK, some of this may be a little off the wall since I'm at home on a day
off.  Can't believe I'm answering the mail on a day off!!  But you got to do
something while waiting for the glue to dry!!

Anyway, there are two init parameters that need to be set,
job_queue_interval and job_queue_processes.  After that bounce your database to
start things.  There after, the parameters you set for 'next' will take over. 
Now if you need to make changes, look in the user_jobs table.  There you will
find the next_date column and a procedure dbms_job.next_date to adjust matters.

Dick Goulet

Reply Separator
Author: Bunyamin K. Karadeniz [EMAIL PROTECTED]
Date:   3/4/2002 4:58 AM

Dear Gurus,

I have made 10 tables as snapshots . And I want to refresh them for specific
intervals. 
How can I do that ;
I have tried DBMS_SNAPSHOT.REFRESH_ALL_MVIEWS but could not succeed . 
How is it done ?
Bunyamin

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEAD
META content=text/html; charset=iso-8859-9 http-equiv=Content-Type
META content=MSHTML 5.00.2014.210 name=GENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=#ff
DIVFONT face=Arial size=2Dear Gurus,/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=Arial size=2I have made 10 tables as snapshots . And I want to 
refresh them for specific intervals. /FONT/DIV
DIVFONT face=Arial size=2How can I do that ;/FONT/DIV
DIVFONT face=Arial size=2I have tried DBMS_SNAPSHOT.REFRESH_ALL_MVIEWS but 
could not succeed . /FONT/DIV
DIVFONT face=Arial size=2How is it done ?/FONT/DIV
DIVFONT face=Arial size=2Bunyamin/FONT/DIV/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 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: Sun Cluster and VCS failover

2002-03-04 Thread Baker, Barbara


Nick:
On our SunCluster 2-node E4500's with 8 CPU's (Oracle 8.0.5)
it takes us around 12 to 15 minutes.

HTH.
Barb


 --
 From: Nick Wagner[SMTP:[EMAIL PROTECTED]]
 Reply To: [EMAIL PROTECTED]
 Sent: Monday, March 04, 2002 2:23 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Sun Cluster and VCS failover 
 
 Situation:  Sun Cluster, or VERITAS Cluster. Oracle 8, 8i, or 9i
 2 node Sun E6500s w/ 8 CPUs
  
 If the primary node fails, how long does it take before a user is able to
 connect to the secondary node, and continue their activity?   I'm sure
 reality, and marketing times are different... I'm really interested in
 reality times, but at this point either would be nice.  
  
 Thanks!! 
  
 Nick 
  
  
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  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: Automatic PGA Memory Management via PGA_AGGREGATE_TARGET para

2002-03-04 Thread David Wagoner


I bet if you wowed us with a really good explanation of this new feature
then some readers would be inclined to go check out your book :).



david

David B. Wagoner
Database Administrator
Arsenal Digital Solutions Worldwide, Inc.
8000 Regency Parkway, Suite 110
Cary, NC 27511-8582
Tel. (919) 466-6723
Fax (919) 466-6783
Mobile (919) 225-4962
[EMAIL PROTECTED] 
http://www.arsenaldigital.com/

 
***  NOTICE  ***
This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged, 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 the sender by phone or email and delete this e-mail
message from your computer.  Thank you.

-Original Message-
Sent: Monday, March 04, 2002 2:53 PM
To: Multiple recipients of list ORACLE-L

I cover this topic and many others in my Oracle9i New Features book :-))

RF


Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.



-Original Message-
Sent: Monday, March 04, 2002 1:58 PM
To: Multiple recipients of list ORACLE-L



I just stumbled upon the Automatic PGA Memory Management section of the 9i
docs.  I've never heard of this before.  Does anyone know how long it's been
around?  Anyone using it found any bugs, concerns, etc.?



Granted, this is intended for *dedicated* server mode, it seems like a good
option for our Test databases and perhaps other databases that have only a
handful of users and don't require MTS.  By setting PGA_AGGREGATE_TARGET=X,
where X can be a value in K, M, or G, Oracle will automatically distribute
this memory allocation to dedicated sessions instead of using
SORT_AREA_SIZE.  Here's an excerpt from the docs:



Oracle does not recommend using the SORT_AREA_SIZE parameter unless the
instance is configured with the shared server option.  Oracle recommends
that you enable automatic sizing of SQL working areas by setting
PGA_AGGREGATE_TARGET instead.  SORT_AREA_SIZE is retained for backward
compatibility.





Learn something new every day in Oracle land...





david



David B. Wagoner

Database Administrator

Arsenal Digital Solutions Worldwide, Inc.

8000 Regency Parkway, Suite 110

Cary, NC 27511-8582

Tel. (919) 466-6723

Fax (919) 466-6783

Mobile (919) 225-4962

[EMAIL PROTECTED]

 http://www.arsenaldigital.com/ http://www.arsenaldigital.com/




***  NOTICE  ***

This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged, 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 the sender by phone or email and delete this e-mail
message from your computer.  Thank you.



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
  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: David Wagoner
  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: replication question

2002-03-04 Thread James A




Thanks 
tons Kevin, that is the information I was looking for.
Great, 
quick response.


  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: 
  Monday, March 04, 2002 2:43 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: replication question
  I 
  have used both. 
  
  Replication, like archive log movement , happens whenever you set it up 
  to happen. That can be anywhere from every minute to once a day to 
  beyond. It just depends on your needs. In the case of my old job, 
  we had replication happeningat different times for different 
  tables. Our key table was replicating IMMEDIATELY uponany 
  changes to the parent table. This happened via 
  trigger.Other , not so important tables, would replicate at 
  anywhere from 30 to 60 
  minutes. We did this using scheduled jobs.
  
  I 
  see two realnice advantages ofreplicated databases. One, 
  they are accessible.i.e. you can run reports, queries, etc on 
  them. They are nothing more than instancesthat get updated via a 
  foreign database. Two,depending on what kind of software you use, 
  you can update the database from an outside source. We used to 
  have data sent down from our DB2 database into our Oracle database using an 
  oracle product called Replication Services (nothing more than triggers and a 
  specific data structure) and an IBM product called Data Propogator. 
  
  
  Archive log transport for standbys can happen in 
  multiple ways also. The newer oracle versions support direct archiving 
  from a production database to a standby database. I have not tried this 
  yet but we are looking into it. Our current standby databases are 
  brought up to date with a shell script that is scheduled via cron every 20 
  minutes.
  
  The thing about the standbys, they areall or 
  nothing ... you can not just say I want only tables 1-10 to be updated. 
  They all are. Also, in the older oracle versions, the standbys could not 
  be accessed via software so you could not use them as any sort of read only 
  database. This is not the case in a replicated database. 
  But, they are also very easy to rebuild and resetup. Just copy your 
  production files over, create a standby control file, and bring the databse up 
  in standby mode. Very easy.
  
  Now... which would I recommend ??? 
  Depends on your needs.
  
  If you really need to access that copy of the 
  database for other purposes and you only want certain tables to be updated, 
  then I would consider replication. If, on the other hand, you do 
  not have to access the data (until such a time as your production gets killed 
  and you need your standby up) and you need a fast way to rebuild the second 
  database, I would suggest the Standby 
  approach.
  
  Kevin
  
-Original Message-From: James Ambursley 
[mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 12:24 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
replication question
Is 
replication faster than a standby database.As I understand it, the 
standby database will be receive arch logs at preset intervals. Does 
replication have the same functionality and about how much data is sent to 
the replicated site.



  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin LangeSent: 
  Monday, March 04, 2002 10:44 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: replication question
  The way I see it . the question comes down to whether or 
  not you need two way replication or just one way. If both 
  databases can update those tables and you need them synced between the 
  databases then Advanced Replication would be the route. If all 
  you need are data changes from 1 database to be replicated to another 
  database then simple replication is all you need.
  
-Original Message-From: Rahul Dandekar 
[mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 
6:43 AMTo: Multiple recipients of list 
ORACLE-LSubject: Re: replication 
question
Depends on your need.
You can have read only snapshots, updatable 
snapshots
or multimaster...
Again if you think of multimaster... then 
you would need to make decision
based on your application requirements 
about sync or async

I donot have any expereince of snapshot 
replication.
But, if you are planning multimaster 
replication, then better
spend a couple of months studying it and 
testing on test boxes...

Make 100% sure that your 
applicationreally needs the replication
and there is no other simpler 
option...

Just 2 cents...

+Rahul

  - Original Message - 
  From: 
  Bunyamin K.

SSL and non-SSL requests on same Apache server in 9iAS?

2002-03-04 Thread Ben Poels


Hi,

I want to host SSL and non-SSL requests on one physical server
running one 9iAS.

After installing 9iAS the httpd.conf file specifies by default
that it is listening on port . Later on in httpd.conf it 
has an SSL directive that says it's listening on port 80 and 443.
Does this mean that this one Apache server can service non-SSL
requests on  and SSL requests on 443 at the same time?

There is a document on Metalink(135231.1) that describes how to run two
Apache servers in one 9iAS home. Again what is not clear to me
is whether or not one could be handling SSL and the other non-SSL.

Anyone have any recommendations on how to do this? I may also be asked
to host 40-bit and 128-bit encryption on the same web site. Again any
recommendations?

Thanks. 

==
 Ben Poels - Senior Technical Analyst - Queen's University at Kingston
 Phone: 613.533.2449  Fax: 613.533.2168  Email: [EMAIL PROTECTED]
==

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

2002-03-04 Thread Jared . Still


 and I was off as well, if your extent size is less than the blocksize
 then you can have more than one extent in a block (divide the block
 size by the extent size and round DOWN)

Huh?

Jared





Rachel Carmichael [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/04/02 12:13 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: EXTENTS?


nick, you're thinking segments not extents.

and I was off as well, if your extent size is less than the blocksize
then you can have more than one extent in a block (divide the block
size by the extent size and round DOWN)

in general though, extents are not usually sized as small as the
database block size


--- Nick Wagner [EMAIL PROTECTED] wrote:
 I'm going to say 1. I don't think you can have multiple tables in the
 same
 DB block. 
 
 -Original Message-
 Sent: Monday, March 04, 2002 10:19 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi
 If DB block size is 8k then how many extents in one db block?
 Thanks
 -Seema
 
 
 
 _
 Join the world's largest e-mail service with MSN Hotmail. 
 http://www.hotmail.com
 
 -- 
 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).
 


__
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
-- 
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).



-- 
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: Names server

2002-03-04 Thread Jared . Still


Completely removing names from Oracle would be a mistake IMO.

Reason:  Name is fairly easy to implement,  LDAP is anything but.

Jared





Freeman, Robert  [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/04/02 01:38 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: Names server


Names server is depreciated in 9i, but still there.
They were going to remove it, but I think there was a bit of a backlash, 
so
they have delayed
the removal.
OID (LDAP) is the replacement.
 
We use names server here, have found it to be pretty stable and reduced
tnsnames.ora
administration nicely.
 
RF
 

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.

 

-Original Message-
Sent: Monday, March 04, 2002 3:53 PM
To: Multiple recipients of list ORACLE-L


Names server will be obsolete in 9i, I think.

-Original Message-
Sent: Monday, March 04, 2002 11:33 AM
To: Multiple recipients of list ORACLE-L


Hi ALL:
Is any one using names server out there?  How the it works?  Any infor
are wellcome.

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

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

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



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

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

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

RE: Names server