Mailing List Archives

[Muqeem Sherwani]

Hi Everybody,
Does anybody have access access to mailing list archives forOAS, WebDB, DBA  email ,   than please let me know. 
Would really appreciate your replyHave a Nice Day!Do You Yahoo!?
Yahoo! Auctions $2 Million Sweepstakes  -  Got something to sell?

ORA-00904

[PHU,JULIA (HP-Sunnyvale,ex2)]

Greetings,

I'm lost on the 'ORA-00904: invalid column name' error message. Can someone
shed some light on it? It is 8i on NT box with sp6a.

Regards,
Julia Phu

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: PHU,JULIA (HP-Sunnyvale,ex2)
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Exporting and Importing table statistics

[Jared Still]

On Friday 25 May 2001 18:36, Weaver, Walt wrote:
> FWIW, all those people who like to slam Oracle Support should pay special
> attention to Anita's posts. Cool stuff.


There's a number of Oracle folks that really know their stuff.

If you don't hang out on mailing lists and search them out
at IOUG though, you'll never get to pick their brain, as you
usually don't get them when you contact support.

2 exceptions:  there are some good folks that monitor the
MetaLink forums, many of them veterans of several years
of Oracle's forums on CompuServe.

Tom Kyte is another exception, he is very accessible through
his website and usenet.

Jared

> --Walt Weaver
>   Bozeman, Montana, USA
>
> -Original Message-
> To: Multiple recipients of list ORACLE-L
> Sent: 5/25/2001 6:50 PM
>
> Jared,
>
> Yes, DBMS_STATS can be used to move statistics from
> one db to another for the SAME table/index.  It's
> great for moving prod stats into a dev db for sql
> tuning.  You can also use it to set specific values
> (e.g. to set NUM_ROWS to 100).
>
> You might want to check out the following doc on
> metalink:
>
> Note: 117203.1 "How to Use DBMS_STATS to Move
> Statistics to a Different Database"
>
> One caveat, it was not designed to copy stats to a
> different schema owner.  You won't get an error
> running the procedure, it just won't reset any stats.
> You can get around this by hacking the stats table
> generated by DBMS_STATS and changing the username
> column to the new schema owner.  The column names are
> rather cryptic, but if I remember it's C5.
>
> HTH,
>
> -- Anita
>
> --- Jared Still <[EMAIL PROTECTED]> wrote:
> > On Friday 25 May 2001 13:46,
> >
> > [EMAIL PROTECTED] wrote:
> > > I have no experience with this, but I think the
> >
> > package  DBSTATS allows you
> >
> > > to export stats to a table and then import those
> >
> > stats back into the data
> >
> > > dictionary. I think outline perserves a query plan
> >
> > but ignores the dd
> >
> > > stats.
> >
> > You're referring to the DBMS_STATS package.  After
> > spending a few minutes
> > perusing the docs, it's unclear whether this can be
> > used for recreating
> > statistics on another database.  The docs refer to
> > using CREATE OUTLINE
> > for this.
> >
> >
> > Jared
> >
> > > Chaim
> > >
> > >
> > >
> > >
> > > Jared Still <[EMAIL PROTECTED]> on 05/25/2001
> >
> > 03:32:54 PM
> >
> > > Please respond to [EMAIL PROTECTED]
> > >
> > > To:   Multiple recipients of list ORACLE-L
> >
> > <[EMAIL PROTECTED]>
> >
> > > cc:(bcc: Chaim Katz/Completions/Bombardier)
> > >
> > > On Friday 25 May 2001 01:05, Saurabh Sharma wrote:
> > > > i feel this is at the full database export
> >
> > level.
> >
> > > > once u export ur database, u can import it as it
> >
> > is into another database
> >
> > > > and it'll create allthe required definitions for
> >
> > u.
> >
> > > > the statistics are exported with the tablespace
> >
> > and table definitions.
> >
> > > > hope i'm sure. if not pls correct.
> > >
> > > OK, not correct.  Statistics are not exported,
> >
> > check the manual.
> >
> > > EXP will recalculate statistics, but doesn't
> >
> > export them.  At least
> >
> > > I can find no indication of it.
> > >
> > > You can use Oracle's plan stability feature
> >
> > however via CREATE OUTLINE.
> >
> > > Jared
> > >
> > > > saurabh
> > > > - Original Message -
> > > > To: Multiple recipients of list ORACLE-L
> >
> > <[EMAIL PROTECTED]>
> >
> > > > Sent: Friday, May 25, 2001 3:48 AM
> > > >
> > > > > Hi all,
> > > > > According to the 8i utilities manual I should
> >
> > be able to export a
> >
> > > > > tables' statistics
> > > > > from one database, then import those
> >
> > statistics into another database.
> >
> > > > > I have tried various combinations of export
> >
> > and import scripts but
> >
> > > > > nothing seems to
> > > > > work. My table has none of the restrictions
> >
> > described in the utilities
> >
> > > > > manual that
> > > > > would prevent the statistics from being
> >
> > exported and then imported.
> >
> > > > > Can this export/import of statistics be done
> >
> > at a single table level or
> >
> > > > > does it have
> > > > > to be a full database export? If not at the
> >
> > table level can it be done
> >
> > > > > at the schema
> > > > > level?
> > > > >
> > > > > Thanks everyone,
> > > > > Gary Bonner
> > > > > [EMAIL PROTECTED]
> > > > >
> > > > > --
> > > > > 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'

Re: FW: Transient Delivery Failure

[Jared Still]

It was annoying me too, so I removed it.  :)

Jared


On Friday 25 May 2001 18:15, Rajaram wrote:
> Someone please do something about this... This stupid southampton address
> keep coming to my mail box... I hope its happening the same with the other
> listers
> Will anyone look at it and   remove it?
>
> Rajaram
> (PS: the Failed message follows)
>
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, May 25, 2001 5:41 PM
> To:   [EMAIL PROTECTED]
> Subject:  Transient Delivery Failure
>
> The attached message had transient non-fatal delivery errors
>
> THIS IS A WARNING MESSAGE ONLY - YOU DO NOT NEED TO RESEND YOUR MESSAGE!
>
> This server is configured to automatically retry delivery at configured
> intervals.  Subsequent attempts to deliver this message are pending.
>
> --- Partial Session Transcript ---
>   Host [sccemail] resolved to [172.21.4.74]
>   Waiting for socket connection...
>   30 second wait for connect timeout exceeded.
>   This message is 61 minutes old; it has 0 minutes left in this queue
>   Primary queue lifetime exceeded; message placed in retry queue
> --- End Transcript ---
>
> : Message contains [1] file attachments
>
> -Original Message-
> From: Rajaram [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, May 25, 2001 5:01 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Bad SQL.
>
> Remember - Drink responsibly - Kidding.
>
> Raj.
>
>
> -Original Message-
> From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, May 25, 2001 3:26 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Bad SQL.
>
> Thank you very much.  I was thinking that I needed to do a nested select.
> It worked great.  I'll have a beer for you after I leave work!  :)
>
> Dave
>
> -Original Message-
> Sent: Friday, May 25, 2001 1:46 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I think it's just Friday.  You need to rewrite your statement to read
> something like this:
>
> UPDATE AVAILABLE_POWER SET available_power_driver_terminated = 'Y'
> where available_power.driver_id in (select manpowerprofile.mpp_id
> from manpowerprofile where manpowerprofile.mpp_terminationdt <>
> to_date('31-DEC-2049','DD-MON-') )
>
> At 09:01 AM 5/25/01 -0800, you wrote:
> >I am trying to write an update statement but seem to be having problems.
> >Below is my statement and the error in SQL*Plus.
> >
> >
> >   1  UPDATE AVAILABLE_POWER SET available_power.driver_terminated = 'Y'
> >   2WHERE available_power.driver_id = manpowerprofile.mpp_id
> >   3*and manpowerprofile.mpp_terminationdt <>
> >TO_DATE('31-DEC-2049','DD-MON-')
> >SQL> /
> >and manpowerprofile.mpp_terminationdt <>
> >TO_DATE('31-DEC-2049','DD-MON-')
> >*
> >ERROR at line 3:
> >ORA-00904: invalid column name
> >
> >
> >I know that manpowerprofile.mpp_terminationdt is a valid table column.  Do
>
> I
>
> >need to do some type of join on these two tables?  Or is it just Friday
>
> and
>
> >I should give up and go have a cold beer!!:o)  Any advice would be
> >appreciated.
> >
> >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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Regina Harter
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Farnsworth, Dave
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') a

Re: backspace in Oracle.

[Jared Still]

On Friday 25 May 2001 18:26, Weaver, Walt wrote:
> Ditto. I support Jared's backspace claims 100%, and I don't think he should
> be removed from the list.

I sure appreciate that Walt!

> I've heard there are other operating systems out there besides Linux and
> Solaris. Is this true?

A nasty rumor.  There's an upstart startup in WA that claims to have
something akin to an OS, but it keeps failing the 30 day stability test.

Jared


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

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

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

RE: OT: RE: Steve Adam's Removal

[Weaver, Walt]

Hey, this whole thing is one of those classic "lose-lose" situations.
Nothing constructive is gonna come out of it, no matter how hard you try.

You people are making me sad. STOP IT!!! STOP IT!!!

HELP

--Walt Weaver
  Bozeman, Montana, USA

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/25/2001 5:56 PM

I quote "Apparently you again know what everybody else should do and
think - 
which topic to discuss and which not."

I find that comment insulting


>From: "Hillman, Alex" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT: RE: Steve Adam's Removal
>Date: Fri, 25 May 2001 14:01:55 -0800
>
>I do not see anything insulting in my post. If disagreement with you is
an
>insult - it is your problem. I did not begin this thread but I was
qurious
>why Steve was excluded from the list. I did not know about a thread on
>lazydba when I posted, but it does not matter.
>
>Alex Hillman
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: backspace in Oracle.

[Weaver, Walt]

Ditto. I support Jared's backspace claims 100%, and I don't think he should
be removed from the list.

We're working on Linux (Red Hat and SUSE) and Solaris here, and we have this
problem only on Linux.

I've heard there are other operating systems out there besides Linux and
Solaris. Is this true?

--Walt Weaver
  Bozeman, Montana, USA

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/25/2001 5:24 PM

On Friday 25 May 2001 13:05, Deshpande, Kirti wrote:
> Jared,
>  Is that something specific to Linux?
>  The other way (without the -V) works fine on HP-UX and AIX.
> - Kirti


Apparently so.  I've two different brands/versions of linux,  and I
have to do this in both.

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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Exporting and Importing table statistics

[Jared Still]

Anita,

Thanks for clearing that up.

I had seemed to recall that this was possible when someone
asked about it, but all I could recall and/or find was CREATE OUTLINE.

Probably one of those things I learned in 8i DBA class and
forgot because I haven't used it.

Jared


On Friday 25 May 2001 16:52, A. Bardeen wrote:
> Jared,
>
> Yes, DBMS_STATS can be used to move statistics from
> one db to another for the SAME table/index.  It's
> great for moving prod stats into a dev db for sql
> tuning.  You can also use it to set specific values
> (e.g. to set NUM_ROWS to 100).
>
> You might want to check out the following doc on
> metalink:
>
> Note: 117203.1 "How to Use DBMS_STATS to Move
> Statistics to a Different Database"
>
> One caveat, it was not designed to copy stats to a
> different schema owner.  You won't get an error
> running the procedure, it just won't reset any stats.
> You can get around this by hacking the stats table
> generated by DBMS_STATS and changing the username
> column to the new schema owner.  The column names are
> rather cryptic, but if I remember it's C5.
>
> HTH,
>
> -- Anita
>
> --- Jared Still <[EMAIL PROTECTED]> wrote:
> > On Friday 25 May 2001 13:46,
> >
> > [EMAIL PROTECTED] wrote:
> > > I have no experience with this, but I think the
> >
> > package  DBSTATS allows you
> >
> > > to export stats to a table and then import those
> >
> > stats back into the data
> >
> > > dictionary. I think outline perserves a query plan
> >
> > but ignores the dd
> >
> > > stats.
> >
> > You're referring to the DBMS_STATS package.  After
> > spending a few minutes
> > perusing the docs, it's unclear whether this can be
> > used for recreating
> > statistics on another database.  The docs refer to
> > using CREATE OUTLINE
> > for this.
> >
> >
> > Jared
> >
> > > Chaim
> > >
> > >
> > >
> > >
> > > Jared Still <[EMAIL PROTECTED]> on 05/25/2001
> >
> > 03:32:54 PM
> >
> > > Please respond to [EMAIL PROTECTED]
> > >
> > > To:   Multiple recipients of list ORACLE-L
> >
> > <[EMAIL PROTECTED]>
> >
> > > cc:(bcc: Chaim Katz/Completions/Bombardier)
> > >
> > > On Friday 25 May 2001 01:05, Saurabh Sharma wrote:
> > > > i feel this is at the full database export
> >
> > level.
> >
> > > > once u export ur database, u can import it as it
> >
> > is into another database
> >
> > > > and it'll create allthe required definitions for
> >
> > u.
> >
> > > > the statistics are exported with the tablespace
> >
> > and table definitions.
> >
> > > > hope i'm sure. if not pls correct.
> > >
> > > OK, not correct.  Statistics are not exported,
> >
> > check the manual.
> >
> > > EXP will recalculate statistics, but doesn't
> >
> > export them.  At least
> >
> > > I can find no indication of it.
> > >
> > > You can use Oracle's plan stability feature
> >
> > however via CREATE OUTLINE.
> >
> > > Jared
> > >
> > > > saurabh
> > > > - Original Message -
> > > > To: Multiple recipients of list ORACLE-L
> >
> > <[EMAIL PROTECTED]>
> >
> > > > Sent: Friday, May 25, 2001 3:48 AM
> > > >
> > > > > Hi all,
> > > > > According to the 8i utilities manual I should
> >
> > be able to export a
> >
> > > > > tables' statistics
> > > > > from one database, then import those
> >
> > statistics into another database.
> >
> > > > > I have tried various combinations of export
> >
> > and import scripts but
> >
> > > > > nothing seems to
> > > > > work. My table has none of the restrictions
> >
> > described in the utilities
> >
> > > > > manual that
> > > > > would prevent the statistics from being
> >
> > exported and then imported.
> >
> > > > > Can this export/import of statistics be done
> >
> > at a single table level or
> >
> > > > > does it have
> > > > > to be a full database export? If not at the
> >
> > table level can it be done
> >
> > > > > at the schema
> > > > > level?
> > > > >
> > > > > Thanks everyone,
> > > > > Gary Bonner
> > > > > [EMAIL PROTECTED]
> > > > >
> > > > > --
> > > > > 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: Jared Still
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services   

RE: Exporting and Importing table statistics

[Weaver, Walt]

FWIW, all those people who like to slam Oracle Support should pay special
attention to Anita's posts. Cool stuff.

--Walt Weaver
  Bozeman, Montana, USA

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/25/2001 6:50 PM

Jared,

Yes, DBMS_STATS can be used to move statistics from
one db to another for the SAME table/index.  It's
great for moving prod stats into a dev db for sql
tuning.  You can also use it to set specific values
(e.g. to set NUM_ROWS to 100).  

You might want to check out the following doc on
metalink:

Note: 117203.1 "How to Use DBMS_STATS to Move
Statistics to a Different Database"

One caveat, it was not designed to copy stats to a
different schema owner.  You won't get an error
running the procedure, it just won't reset any stats. 
You can get around this by hacking the stats table
generated by DBMS_STATS and changing the username
column to the new schema owner.  The column names are
rather cryptic, but if I remember it's C5.

HTH,

-- Anita

--- Jared Still <[EMAIL PROTECTED]> wrote:
> On Friday 25 May 2001 13:46,
> [EMAIL PROTECTED] wrote:
> > I have no experience with this, but I think the
> package  DBSTATS allows you
> > to export stats to a table and then import those
> stats back into the data
> > dictionary. I think outline perserves a query plan
> but ignores the dd
> > stats.
> >
> 
> You're referring to the DBMS_STATS package.  After
> spending a few minutes
> perusing the docs, it's unclear whether this can be
> used for recreating 
> statistics on another database.  The docs refer to
> using CREATE OUTLINE 
> for this.
> 
> 
> Jared
> 
> > Chaim
> >
> >
> >
> >
> > Jared Still <[EMAIL PROTECTED]> on 05/25/2001
> 03:32:54 PM
> >
> > Please respond to [EMAIL PROTECTED]
> >
> > To:   Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> > cc:(bcc: Chaim Katz/Completions/Bombardier)
> >
> > On Friday 25 May 2001 01:05, Saurabh Sharma wrote:
> > > i feel this is at the full database export
> level.
> > > once u export ur database, u can import it as it
> is into another database
> > > and it'll create allthe required definitions for
> u.
> > > the statistics are exported with the tablespace
> and table definitions.
> > >
> > > hope i'm sure. if not pls correct.
> >
> > OK, not correct.  Statistics are not exported,
> check the manual.
> >
> > EXP will recalculate statistics, but doesn't
> export them.  At least
> > I can find no indication of it.
> >
> > You can use Oracle's plan stability feature
> however via CREATE OUTLINE.
> >
> > Jared
> >
> > > saurabh
> > > - Original Message -
> > > To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> > > Sent: Friday, May 25, 2001 3:48 AM
> > >
> > > > Hi all,
> > > > According to the 8i utilities manual I should
> be able to export a
> > > > tables' statistics
> > > > from one database, then import those
> statistics into another database.
> > > > I have tried various combinations of export
> and import scripts but
> > > > nothing seems to
> > > > work. My table has none of the restrictions
> described in the utilities
> > > > manual that
> > > > would prevent the statistics from being
> exported and then imported.
> > > > Can this export/import of statistics be done
> at a single table level or
> > > > does it have
> > > > to be a full database export? If not at the
> table level can it be done
> > > > at the schema
> > > > level?
> > > >
> > > > Thanks everyone,
> > > > Gary Bonner
> > > > [EMAIL PROTECTED]
> > > >
> > > > --
> > > > 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: Jared Still
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing Lists
> >
>

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

FW: Transient Delivery Failure

[Rajaram]

Someone please do something about this... This stupid southampton address 
keep coming to my mail box... I hope its happening the same with the other 
listers
Will anyone look at it and   remove it?

Rajaram
(PS: the Failed message follows)

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, May 25, 2001 5:41 PM
To: [EMAIL PROTECTED]
Subject:Transient Delivery Failure

The attached message had transient non-fatal delivery errors

THIS IS A WARNING MESSAGE ONLY - YOU DO NOT NEED TO RESEND YOUR MESSAGE!

This server is configured to automatically retry delivery at configured
intervals.  Subsequent attempts to deliver this message are pending.

--- Partial Session Transcript ---
  Host [sccemail] resolved to [172.21.4.74]
  Waiting for socket connection...
  30 second wait for connect timeout exceeded.
  This message is 61 minutes old; it has 0 minutes left in this queue
  Primary queue lifetime exceeded; message placed in retry queue
--- End Transcript ---

: Message contains [1] file attachments


-Original Message-
From:   Rajaram [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, May 25, 2001 5:01 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Bad SQL.

Remember - Drink responsibly - Kidding.

Raj.


-Original Message-
From:   Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, May 25, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Bad SQL.

Thank you very much.  I was thinking that I needed to do a nested select.
It worked great.  I'll have a beer for you after I leave work!  :)

Dave

-Original Message-
Sent: Friday, May 25, 2001 1:46 PM
To: Multiple recipients of list ORACLE-L


I think it's just Friday.  You need to rewrite your statement to read
something like this:

UPDATE AVAILABLE_POWER SET available_power_driver_terminated = 'Y'
where available_power.driver_id in (select manpowerprofile.mpp_id
from manpowerprofile where manpowerprofile.mpp_terminationdt <>
to_date('31-DEC-2049','DD-MON-') )

At 09:01 AM 5/25/01 -0800, you wrote:
>I am trying to write an update statement but seem to be having problems.
>Below is my statement and the error in SQL*Plus.
>
>
>   1  UPDATE AVAILABLE_POWER SET available_power.driver_terminated = 'Y'
>   2WHERE available_power.driver_id = manpowerprofile.mpp_id
>   3*and manpowerprofile.mpp_terminationdt <>
>TO_DATE('31-DEC-2049','DD-MON-')
>SQL> /
>and manpowerprofile.mpp_terminationdt <>
>TO_DATE('31-DEC-2049','DD-MON-')
>*
>ERROR at line 3:
>ORA-00904: invalid column name
>
>
>I know that manpowerprofile.mpp_terminationdt is a valid table column.  Do
I
>need to do some type of join on these two tables?  Or is it just Friday 
and
>I should give up and go have a cold beer!!:o)  Any advice would be
>appreciated.
>
>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).

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

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

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

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

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

NetZero Platinum
No Banner Ads and Unlimited Access
Sign Up Today - Only $9.95 per month!
http://www.netzero.net
--
Ple

Dumping tables using perl

[David Turner]

I sent email earlier and got some great suggestions on how to dump tables, but I had 
some
questions. I would like my perl dump script to work on basically any table so I can 
send
it out to everyone here when I'm done with it. However, say I have a table with a lob 
in
it and I have know idea what is in the field. How should I delimit the file, and can I 
use
sql loader to load the lob info? I've used sqlloader for everything but lobs fine.

Thanks, Dave

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Exporting and Importing table statistics

[A. Bardeen]

Jared,

Yes, DBMS_STATS can be used to move statistics from
one db to another for the SAME table/index.  It's
great for moving prod stats into a dev db for sql
tuning.  You can also use it to set specific values
(e.g. to set NUM_ROWS to 100).  

You might want to check out the following doc on
metalink:

Note: 117203.1 "How to Use DBMS_STATS to Move
Statistics to a Different Database"

One caveat, it was not designed to copy stats to a
different schema owner.  You won't get an error
running the procedure, it just won't reset any stats. 
You can get around this by hacking the stats table
generated by DBMS_STATS and changing the username
column to the new schema owner.  The column names are
rather cryptic, but if I remember it's C5.

HTH,

-- Anita

--- Jared Still <[EMAIL PROTECTED]> wrote:
> On Friday 25 May 2001 13:46,
> [EMAIL PROTECTED] wrote:
> > I have no experience with this, but I think the
> package  DBSTATS allows you
> > to export stats to a table and then import those
> stats back into the data
> > dictionary. I think outline perserves a query plan
> but ignores the dd
> > stats.
> >
> 
> You're referring to the DBMS_STATS package.  After
> spending a few minutes
> perusing the docs, it's unclear whether this can be
> used for recreating 
> statistics on another database.  The docs refer to
> using CREATE OUTLINE 
> for this.
> 
> 
> Jared
> 
> > Chaim
> >
> >
> >
> >
> > Jared Still <[EMAIL PROTECTED]> on 05/25/2001
> 03:32:54 PM
> >
> > Please respond to [EMAIL PROTECTED]
> >
> > To:   Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> > cc:(bcc: Chaim Katz/Completions/Bombardier)
> >
> > On Friday 25 May 2001 01:05, Saurabh Sharma wrote:
> > > i feel this is at the full database export
> level.
> > > once u export ur database, u can import it as it
> is into another database
> > > and it'll create allthe required definitions for
> u.
> > > the statistics are exported with the tablespace
> and table definitions.
> > >
> > > hope i'm sure. if not pls correct.
> >
> > OK, not correct.  Statistics are not exported,
> check the manual.
> >
> > EXP will recalculate statistics, but doesn't
> export them.  At least
> > I can find no indication of it.
> >
> > You can use Oracle's plan stability feature
> however via CREATE OUTLINE.
> >
> > Jared
> >
> > > saurabh
> > > - Original Message -
> > > To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> > > Sent: Friday, May 25, 2001 3:48 AM
> > >
> > > > Hi all,
> > > > According to the 8i utilities manual I should
> be able to export a
> > > > tables' statistics
> > > > from one database, then import those
> statistics into another database.
> > > > I have tried various combinations of export
> and import scripts but
> > > > nothing seems to
> > > > work. My table has none of the restrictions
> described in the utilities
> > > > manual that
> > > > would prevent the statistics from being
> exported and then imported.
> > > > Can this export/import of statistics be done
> at a single table level or
> > > > does it have
> > > > to be a full database export? If not at the
> table level can it be done
> > > > at the schema
> > > > level?
> > > >
> > > > Thanks everyone,
> > > > Gary Bonner
> > > > [EMAIL PROTECTED]
> > > >
> > > > --
> > > > 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: Jared Still
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing Lists
> >
>

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

Re: Creating a sorted table

[Regina Harter]

Well, it won't work in all cases, but I have on occasion used as a shortcut:

INSERT INTO ... SELECT DISTINCT transaction_date, ...

since the distinct will order it for you, beginning with the first item in 
the select.
A more reliable way would be to use pl/sql, select the ordered data into a 
cursor, then insert one by one.

At 02:45 PM 5/25/01 -0800, you wrote:
>We have un-ordered data in a table that needs to be inserted into a
>transaction table in
>order of the date that the transaction took place.
>
>Oracle does not allow "INSERT . AS SELECT . ORDER BY."
>or "CREATE TMP_TABLE  . AS SELECT . ORDER BY.."
>
>Is there a method by which I can accomplish this.
>
>Thank you in advance
>
>Darren Browett
>Sys Admin
>City of Coquitlam
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Browett, Darren
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Regina Harter
  INET: [EMAIL PROTECTED]

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

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

RE: OT: RE: Steve Adam's Removal

[Rachel Carmichael]

I quote "Apparently you again know what everybody else should do and think - 
which topic to discuss and which not."

I find that comment insulting


>From: "Hillman, Alex" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT: RE: Steve Adam's Removal
>Date: Fri, 25 May 2001 14:01:55 -0800
>
>I do not see anything insulting in my post. If disagreement with you is an
>insult - it is your problem. I did not begin this thread but I was qurious
>why Steve was excluded from the list. I did not know about a thread on
>lazydba when I posted, but it does not matter.
>
>Alex Hillman
>
>-Original Message-
>Sent: Friday, May 25, 2001 5:07 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Alex,
>
>Are you deliberately trying to be insulting or is just an innate part of
>your personality?
>
>You are one of the people who complain about "off-topic" postings and tell
>people to stop posting on certain topics. Is this a right you reserve only
>for yourself? How is a discussion of what happens on a different list
>on-topic for this list?
>
>Henry is not excluding anyone from lazydba for discussing what happened, in
>fact, he opened a special discussion forum just for that purpose -- and 
>both
>
>Steve Adams and Christopher Spence have the ability (and have used it) to
>post to that discussion forum to represent their point of view.
>
>Rachel
>
> >From: "Hillman, Alex" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: OT: RE: Steve Adam's Removal
> >Date: Fri, 25 May 2001 12:12:23 -0800
> >
> >Why not - looks like to discuss this on that other list is a good way to 
>be
> >excluded from that list (not that it will  be a big loss). Apparently you
> >again know what everybody else should do and think - which topic to 
>discuss
> >and which not.
> >
> >Alex Hillman
> >
> >-Original Message-
> >Sent: Friday, May 25, 2001 3:26 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Jacques,
> >
> >thank you for saying that so elegantly. Members of this list who are also
> >on
> >
> >lazydba should confine their discussion to that list.
> >
> >And if you don't know the players, it's not fair to beat up on someone.
> >
> >I happen to know both of them. My only comment is: I hope that they can
> >work
> >
> >this out satisfactorily between them. Any other input is not helpful.
> >
> >Rachel
> >
> >
> > >From: Jacques Kilchoer <[EMAIL PROTECTED]>
> > >Reply-To: [EMAIL PROTECTED]
> > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > >Subject: OT: RE: Steve Adam's Removal
> > >Date: Fri, 25 May 2001 09:32:56 -0800
> > >
> > >Disclaimer: I have no affiliation with LazyDba or the owner of the
> >LazyDba
> > >mailing list, and have not subscribed to that list.
> > >
> > >My personal opinion, for what it's worth:
> > >I don't think that this list is an appropriate place to impugn the
> >motives
> > >of the owner(s), or discuss the inadequacies, of other mailing
> > >lists/personal websites, unless the question is posed to the list, e.g.
> > >"Should I join lazydba?"
> > >In addition, I would think it would be more professional to restrict
> >one's
> > >comments to the technical value of said website or list.
> > >
> > >--
> > >Jacques R. Kilchoer
> > >(949) 754-8816
> > >Quest Software, Inc.
> > >8001 Irvine Center Drive
> > >Irvine, California 92618
> > >U.S.A.
> > >http://www.quest.com
> >
> >_
> >Get your FREE download of MSN Explorer at http://explorer.msn.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: Hillman, Alex
> >   INET: [EMAIL PROTECTED]
> >
> >Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> >San Diego, California-- Public Internet access / Mailing Lists
> >
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from).  You may
> >also send the HELP

RE: Creating a sorted table

[Hillman, Alex]

Try insert ... select* from (select * from  order by
)

Alex Hillman

-Original Message-
Sent: Friday, May 25, 2001 6:45 PM
To: Multiple recipients of list ORACLE-L


We have un-ordered data in a table that needs to be inserted into a
transaction table in
order of the date that the transaction took place.

Oracle does not allow "INSERT . AS SELECT . ORDER BY."
or "CREATE TMP_TABLE  . AS SELECT . ORDER BY.."

Is there a method by which I can accomplish this.

Thank you in advance

Darren Browett
Sys Admin
City of Coquitlam
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Browett, Darren
  INET: [EMAIL PROTECTED]

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Creating a sorted table

[Diana_Duncan]

Whyever would you want data inserted in order?  There is no guarantee that
Oracle will actually store the records "in order", there is no performance
gain, and you can always retrieve the records in order by using an order by
statement -- if you really need ordered data, you could use a
index-organized table with all of your columns, with the date as the first
column.  But methinks this would be dangerous for a heavy transaction
table.  (Gurus, please correct me if I'm wrong here)

However, if you are still keen, you could do this through a PL/SQL block,
something like the following:

declare
 cursor get_data is
  select col1, col2, col3, ...
  from unordered_table
  order by whatever;
begin
 for dataRec in get_data loop
  insert into ordered_table (col1, col2, col3, ...)
  values (dataRec.col1, dataRec.col2, dataRec.col3, ...)
 end loop;
end;
/

Cheers!

Diana



   

"Browett, Darren"  

<[EMAIL PROTECTED]To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>   
lam.bc.ca>   cc:   

Sent by: Fax to:   

[EMAIL PROTECTED] Subject: Creating a sorted table  

   

   

05/25/2001 06:45 PM

Please respond to  

ORACLE-L   

   

   





We have un-ordered data in a table that needs to be inserted into a
transaction table in
order of the date that the transaction took place.

Oracle does not allow "INSERT . AS SELECT . ORDER BY."
or "CREATE TMP_TABLE  . AS SELECT . ORDER BY.."

Is there a method by which I can accomplish this.

Thank you in advance

Darren Browett
Sys Admin
City of Coquitlam
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Browett, Darren
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: OT: RE: Steve Adam's Removal

[Jared Still]

OK folks, let's take it offline, it's getting personal.

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

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

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

thank you! -- RE: how to find out internal's password???

[Janet Linsy]

Yeah, that's the one !!!

Thank all those who spent time on this.

--- [EMAIL PROTECTED] wrote:
> try this(on your dev box first):
> 1.select instance_name from v$instance;
> @command line,
> 2.oradim80 -delete -sid 
> 3.oradim80 -new -sid (instance name> -intpwd
> 
> 
> now you have a new password for internal.
> 
> Sunil Nookala
> Dell Corporation,
> Austin, TX
> 
> -Original Message-
> Sent: Friday, May 25, 2001 1:07 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> This is in additional to my previous question about
> how to turn off passowrd for internal:
> 
> To try to turn off pwd for internal, I commented out
> remote_login_passwordfile = exclusive in the init
> file, now I need to shutdown and restart the
> database.
>  I tried to login as internal to shutdown the db,
> when
> it askes for password, I tried a bunch things
> including sys, manager, and they all failed.  So I
> used sqlplus system/pwd to login and do shutdown,
> the
> database is down, but now I cannot login to svrmgrl
> to
> startup the database, since I don't know internal's
> password.  So my question is how to find out
> internal's password?  Thanks a lot.
> 
> Janet
> 
> 
> __
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great
> prices
> http://auctions.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Janet Linsy
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (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).


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janet Linsy
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Exporting and Importing table statistics

[Jared Still]

On Friday 25 May 2001 13:46, [EMAIL PROTECTED] wrote:
> I have no experience with this, but I think the package  DBSTATS allows you
> to export stats to a table and then import those stats back into the data
> dictionary. I think outline perserves a query plan but ignores the dd
> stats.
>

You're referring to the DBMS_STATS package.  After spending a few minutes
perusing the docs, it's unclear whether this can be used for recreating 
statistics on another database.  The docs refer to using CREATE OUTLINE 
for this.


Jared

> Chaim
>
>
>
>
> Jared Still <[EMAIL PROTECTED]> on 05/25/2001 03:32:54 PM
>
> Please respond to [EMAIL PROTECTED]
>
> To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:(bcc: Chaim Katz/Completions/Bombardier)
>
> On Friday 25 May 2001 01:05, Saurabh Sharma wrote:
> > i feel this is at the full database export level.
> > once u export ur database, u can import it as it is into another database
> > and it'll create allthe required definitions for u.
> > the statistics are exported with the tablespace and table definitions.
> >
> > hope i'm sure. if not pls correct.
>
> OK, not correct.  Statistics are not exported, check the manual.
>
> EXP will recalculate statistics, but doesn't export them.  At least
> I can find no indication of it.
>
> You can use Oracle's plan stability feature however via CREATE OUTLINE.
>
> Jared
>
> > saurabh
> > - Original Message -
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Sent: Friday, May 25, 2001 3:48 AM
> >
> > > Hi all,
> > > According to the 8i utilities manual I should be able to export a
> > > tables' statistics
> > > from one database, then import those statistics into another database.
> > > I have tried various combinations of export and import scripts but
> > > nothing seems to
> > > work. My table has none of the restrictions described in the utilities
> > > manual that
> > > would prevent the statistics from being exported and then imported.
> > > Can this export/import of statistics be done at a single table level or
> > > does it have
> > > to be a full database export? If not at the table level can it be done
> > > at the schema
> > > level?
> > >
> > > Thanks everyone,
> > > Gary Bonner
> > > [EMAIL PROTECTED]
> > >
> > > --
> > > 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: Jared Still
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

Re: backspace in Oracle.

[Jared Still]

On Friday 25 May 2001 13:05, Deshpande, Kirti wrote:
> Jared,
>  Is that something specific to Linux?
>  The other way (without the -V) works fine on HP-UX and AIX.
> - Kirti


Apparently so.  I've two different brands/versions of linux,  and I
have to do this in both.

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

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

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

Creating a sorted table

[Browett, Darren]

We have un-ordered data in a table that needs to be inserted into a
transaction table in
order of the date that the transaction took place.

Oracle does not allow "INSERT . AS SELECT . ORDER BY."
or "CREATE TMP_TABLE  . AS SELECT . ORDER BY.."

Is there a method by which I can accomplish this.

Thank you in advance

Darren Browett
Sys Admin
City of Coquitlam
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Browett, Darren
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Steve Adam's Removal

[Christopher Spence]

 Long Live King Jared...

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/25/01 4:12 PM


I would suggest that we discontinue this thread.  It's pretty tame
so far, but has a lot of potential for turning into an opportunity
to bash others, and we don't need it.

FYI Steve Adams has not been removed from this list.  To get
removed from this list requires quite a bit of effort on your part,
or not responding to the list owners (me) emails when asking
about your account sending a  virus to all posters on the list.

The following is a public service announcement for all of you
cross posters:

This is the Oracle-L list at FatCity.com,  dedicated to all things
Oracle, and anything else that Oracleites find interesting.

I am the owner of this list, Henry O'Keeffe is the owner of LazyDba.com
and the OracleDBA list there.

Jared Still


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

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

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

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

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

RE: OT: RE: Steve Adam's Removal

[Hillman, Alex]

I do not see anything insulting in my post. If disagreement with you is an
insult - it is your problem. I did not begin this thread but I was qurious
why Steve was excluded from the list. I did not know about a thread on
lazydba when I posted, but it does not matter. 

Alex Hillman

-Original Message-
Sent: Friday, May 25, 2001 5:07 PM
To: Multiple recipients of list ORACLE-L


Alex,

Are you deliberately trying to be insulting or is just an innate part of 
your personality?

You are one of the people who complain about "off-topic" postings and tell 
people to stop posting on certain topics. Is this a right you reserve only 
for yourself? How is a discussion of what happens on a different list 
on-topic for this list?

Henry is not excluding anyone from lazydba for discussing what happened, in 
fact, he opened a special discussion forum just for that purpose -- and both

Steve Adams and Christopher Spence have the ability (and have used it) to 
post to that discussion forum to represent their point of view.

Rachel

>From: "Hillman, Alex" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT: RE: Steve Adam's Removal
>Date: Fri, 25 May 2001 12:12:23 -0800
>
>Why not - looks like to discuss this on that other list is a good way to be
>excluded from that list (not that it will  be a big loss). Apparently you
>again know what everybody else should do and think - which topic to discuss
>and which not.
>
>Alex Hillman
>
>-Original Message-
>Sent: Friday, May 25, 2001 3:26 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Jacques,
>
>thank you for saying that so elegantly. Members of this list who are also 
>on
>
>lazydba should confine their discussion to that list.
>
>And if you don't know the players, it's not fair to beat up on someone.
>
>I happen to know both of them. My only comment is: I hope that they can 
>work
>
>this out satisfactorily between them. Any other input is not helpful.
>
>Rachel
>
>
> >From: Jacques Kilchoer <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: OT: RE: Steve Adam's Removal
> >Date: Fri, 25 May 2001 09:32:56 -0800
> >
> >Disclaimer: I have no affiliation with LazyDba or the owner of the 
>LazyDba
> >mailing list, and have not subscribed to that list.
> >
> >My personal opinion, for what it's worth:
> >I don't think that this list is an appropriate place to impugn the 
>motives
> >of the owner(s), or discuss the inadequacies, of other mailing
> >lists/personal websites, unless the question is posed to the list, e.g.
> >"Should I join lazydba?"
> >In addition, I would think it would be more professional to restrict 
>one's
> >comments to the technical value of said website or list.
> >
> >--
> >Jacques R. Kilchoer
> >(949) 754-8816
> >Quest Software, Inc.
> >8001 Irvine Center Drive
> >Irvine, California 92618
> >U.S.A.
> >http://www.quest.com
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.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: Hillman, Alex
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

_
Get your FREE download of MSN Explorer at http://explorer.msn.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

What is going on this list? Take it easy and enjoy the weekend!

[Khedr, Waleed]

Regards,

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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[2]: OT: RE: Steve Adam's Removal

[dgoulet]

Jared & Jaques,

This is one of 6 different mailing lists that I'm subscribed to (makes for a
lot of spam in the mail box too).  I do agree that this is the most informative,
but also most raucous of all the lists which is why I'm still here, there be
life here!

Jared has my thanks for his time & effort, the likes of which I'm just beginning
to appreciate as my company is creating an internal data mining site.

Bruce also deserves thanks as I'm certain we can become more than a pain in the
posterior every once in a while. (I work right next to the network guys & see
the fun they have.)

As for LazyDBA, I left there many months ago for my own reasons.  Yes there were
those (who forever shall remain nameless) who came off of the wall pretty hard
every once in a while.  That's life, just use the delete key.  Therefore I bear
no grudges against Steve or Henry, or anyone else thereon or here.  Have
yourselves a good weekend (long one for those of us in the States).  And in a
week I'm going to sign off for a bit as I'm on my way to the UK for a three week
holiday.  I'll jump back into the fray when I return.

Dick Goulet
Certified Oracle 8/8I DBA
Certifiable NUTCASE!


Reply Separator
Author: Jared Still <[EMAIL PROTECTED]>
Date:   5/25/2001 11:52 AM


Thank you Jacques, for your posts on this topic.

Jared

On Friday 25 May 2001 11:12, Jacques Kilchoer wrote:
> Something else I forgot to mention in my previous e-mail on this topic.
>
> Maintaining a website, or a mailing list, is an arduous task that provides
> great benefits to many people at little or no cost to them. I have been a
> member of the ORACLE-L list (with gaps in membership) for many months and
> have never regretted it.
>
> It is also important to remember that Jared Still puts in a great deal of
> (unrenumerated) hours to maintain this list and make sure it stays on
> focus. So remember this when you have the chance to to Jared Still a
> favour. To use a popular expression, we all owe him big-time.
>
> Bruce Bergman also deserves our thanks for making archives of this list
> available at the fatcity website.
>
> And finally, thank you to all the posters who take their valuable time to
> answer the questions here. You know who you are, so I'm not going to try to
> list names, because I'm sure I would forget someone and I would hate to
> receive a cream pie in the face at an Oracle conference some day.
>
> --
> Jacques R. Kilchoer
> (949) 754-8816
> Quest Software, Inc.
> 8001 Irvine Center Drive
> Irvine, California 92618
> U.S.A.
> http://www.quest.com


Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 

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

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

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

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

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

RE: OT: RE: Fire your DBA's you don't need them anymore...

[Hillman, Alex]

Oracle charges for such guys 250-350 an hour and pay them 50-90K/year
(15-20% bonus and 4 weeks of training per year). I would say that Oracle DBA
knowing what he or she is doing can make more money  in consulting. 

Alex Hillman

PS. It would be very useful  if US participants of this list post their
rates or salaries on www.realrates.com - it is fully anonimous. Also there
is very interesting contractors BBS

-Original Message-
Sent: Friday, May 25, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L


Yosi,

I interviewed for one of those jobs here in Boston, MA.  Although there
was
one VERY good individual in the bunch I was a little perplexed by the
others. 
Most were very junior and had not been in an outside shop before, one was
straight out of school and bootcamp and only one had done a real recovery.
It
also hit me as strange that other than the smart guy, none of them had ever
created a database from scratch.  Thankfully I did not take the job.

Dick Goulet

Reply Separator
Author: "Gene Sais" <[EMAIL PROTECTED]>
Date:   5/25/2001 11:52 AM

>From experience, I have used consultants from Oracle.  The 1st one sent was
right out of DBA school.  We sent him back after 1 week.  At that time,
Oracle
didn't allow you to interview their DBA's.  According to Oracle, they were
all
good.  The 2nd DBA Oracle sent had only NT experience, never been on a Unix
machine.  Ok, sent him back too.  By this time, we were about to give up,
then
Oracle sent DBA #3 and she was sharp.  The moral of the story, Oracle will
send
the juniors 1st b/c they save the good ones for the 3rd strike :)


>>> [EMAIL PROTECTED] 05/25/01 03:01PM >>>
I was once one of those superior i-dba consultants. I was pretty good,
and as with this list, some of my colleagues were amazingly talented,
knowledgable and great to work with. Others were, well, others.

It's lots of fun to ridicule, disparage, deride, belittle, and mock
Oracle Consulting, and don't even get me started about Oracle Support,
and I do this all the time too, I just want to put in a good word
for SOME of my old friends.

Have a great weekend.

Yosi


> -Original Message-
> From: PD Miller [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, May 25, 2001 1:58 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Fire your DBA's you don't need them anymore...
> 
> 
> I've just spent most of today repairing damage left at a site by some 
> of Oracle's 'superior' consultants!
> 
> At 8:27 -0800 25/5/01, Gary Weber wrote:
> >Far as their "superior" i-dba team, I sure hope those are different 
> >people from the ones you get on first line of Support...
> 
> Cheers
> 
> Paul Miller
> -- 
> -
> Banned and proud of it!
> 
> Carib Data Limited
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: PD Miller
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Gene Sais
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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, C

New Subscriber / Test Message - Please Ignore

[George Hofilena]

This is a test message.  Please ignore.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: George Hofilena
  INET: [EMAIL PROTECTED]

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

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

OT: RE: Steve Adam's Removal

[Ron Rogers]

Banana or Vanilla cream???

>>> [EMAIL PROTECTED] 05/25/01 02:12PM >>>
Something else I forgot to mention in my previous e-mail on this topic.

Maintaining a website, or a mailing list, is an arduous task that provides
great benefits to many people at little or no cost to them. I have been a
member of the ORACLE-L list (with gaps in membership) for many months and
have never regretted it.

It is also important to remember that Jared Still puts in a great deal of
(unrenumerated) hours to maintain this list and make sure it stays on focus.
So remember this when you have the chance to to Jared Still a favour. To use
a popular expression, we all owe him big-time.

Bruce Bergman also deserves our thanks for making archives of this list
available at the fatcity website.

And finally, thank you to all the posters who take their valuable time to
answer the questions here. You know who you are, so I'm not going to try to
list names, because I'm sure I would forget someone and I would hate to
receive a cream pie in the face at an Oracle conference some day.

--
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.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).

Re:RE: New member

[Ron Rogers]

When Chuck Speaks people listen!  I couldn't resist the play on words.
ROR mô¿ôm

>>> [EMAIL PROTECTED] 05/25/01 01:52PM >>>
We like the troublemakers here!!

Reply Separator
Author: "Speaks; Chuck W." <[EMAIL PROTECTED]>
Date:   5/25/2001 8:21 AM


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

OT: my site is available

[Danisment Gazi Unal (Unal Bilisim)]

Hello list,

I don't know this is the correct way.

my site http://www.unal-bilisim.com is ready to launch. you can use my
web based database products, post questions and answers about my
products and Oracle products.

regards...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (Unal Bilisim)
  INET: [EMAIL PROTECTED]

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

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

Re: OT: My bad

[Brian_McQuillan]

excellent





"Speaks, Chuck W." <[EMAIL PROTECTED]>@fatcity.com on 05/25/2001
12:57:47 PM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:



I didn't mean to reply-all.  That's my bad.

Chuck Speaks, MCSE
Database Administrator
Lithonia Lighting
770-922-9000  x3450
http://www.lithonia.com


-Original Message-
Sent: Friday, May 25, 2001 12:56 PM
To: '[EMAIL PROTECTED]'


Sounds pretty standard.

Chuck Speaks, MCSE
Database Administrator
Lithonia Lighting
770-922-9000  x3450
http://www.lithonia.com


-Original Message-
Sent: Friday, May 25, 2001 1:08 PM
To: Multiple recipients of list ORACLE-L


We have one little rule that most folks follow
pretty well.

If it's not about Oracle or oracle proper, we usually
place an "OFFTOPIC" or "OT" in the first position of
the subject line.

|| -Original Message-
|| From: Speaks, Chuck W. [mailto:[EMAIL PROTECTED]]
|| Sent: Friday, May 25, 2001 12:21 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: New member
||
||
|| Sounds great.  I am a Lazy DBA refugee and I must say that I
|| like the tone
|| and banter on this list a lot better.  I'll be talking to
|| you guys soon.
|| It's good to see familiar names like Chris Spence and Steve
|| Adams, for they
|| are outlaws on other sites.  REAL TROUBLEMAKERS!
||
|| Chuck Speaks, MCSE
|| Database Administrator
|| Lithonia Lighting
|| 770-922-9000  x3450
|| http://www.lithonia.com
||
||
|| -Original Message-
|| Sent: Friday, May 25, 2001 11:43 AM
|| To: Multiple recipients of list ORACLE-L
||
||
|| Welcome, Chuck.
||
|| Welcome to a Land of Microsoft Zealots, Bigots, And Agnostics.
||
|| Welcome to a List where politics and recipes are posted with
|| equal fervor as SQL Tuning tips.
||
|| The water's fine!
||
|| || -Original Message-
|| || From: Speaks, Chuck W. [mailto:[EMAIL PROTECTED]]
|| || Sent: Friday, May 25, 2001 11:07 AM
|| || To: Multiple recipients of list ORACLE-L
|| || Subject: New member
|| ||
|| ||
|| || Hello,
|| ||
|| || Just wanted to introduce myself before posting to the list.
|| || I look forward
|| || to interacting with you guys/ladies on the list.  Have a
|| || great Friday!
|| ||
|| || Chuck Speaks, MCSE
|| || Database Administrator
|| || Lithonia Lighting
|| || 770-922-9000  x3450
|| || http://www.lithonia.com
|| ||
|| || --
|| || Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| || --
|| || Author: Speaks, Chuck W.
|| ||   INET: [EMAIL PROTECTED]
|| ||
|| || Fat City Network Services-- (858) 538-5051  FAX:
|| (858) 538-5051
|| || San Diego, California-- Public Internet access /
|| || Mailing Lists
|| ||
|| 
|| || To REMOVE yourself from this mailing list, send an E-Mail message
|| || to: [EMAIL PROTECTED] (note EXACT spelling of
|| 'ListGuru') and in
|| || the message BODY, include a line containing: UNSUB ORACLE-L
|| || (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: Mohan, Ross
||   INET: [EMAIL PROTECTED]
||
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access /
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Speaks, Chuck W.
||   INET: [EMAIL PROTECTED]
||
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access /
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'Lis

Re: list stats?

[Jared Still]

Dunno, never really cared.

Bruce may know, email me privately if interested.

Jared


On Friday 25 May 2001 10:28, Thater, William wrote:
> OK, oh great list god, do we have the stats for who posts and what the top
> subjects are?
>
> --
> Bill Thater Certifiable ORACLE DBA
> Telergy, Inc.[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.
> ~~
> From C:\*.* to shining C:\*.*
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

Re: Exporting and Importing table statistics

[Chaim . Katz]

I have no experience with this, but I think the package  DBSTATS allows you to
export stats to a table and then import those stats back into the data
dictionary. I think outline perserves a query plan but ignores the dd stats.

Chaim




Jared Still <[EMAIL PROTECTED]> on 05/25/2001 03:32:54 PM

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Chaim Katz/Completions/Bombardier)




On Friday 25 May 2001 01:05, Saurabh Sharma wrote:
> i feel this is at the full database export level.
> once u export ur database, u can import it as it is into another database
> and it'll create allthe required definitions for u.
> the statistics are exported with the tablespace and table definitions.
>
> hope i'm sure. if not pls correct.

OK, not correct.  Statistics are not exported, check the manual.

EXP will recalculate statistics, but doesn't export them.  At least
I can find no indication of it.

You can use Oracle's plan stability feature however via CREATE OUTLINE.

Jared


>
> saurabh
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Friday, May 25, 2001 3:48 AM
>
> > Hi all,
> > According to the 8i utilities manual I should be able to export a tables'
> > statistics
> > from one database, then import those statistics into another database.
> > I have tried various combinations of export and import scripts but
> > nothing seems to
> > work. My table has none of the restrictions described in the utilities
> > manual that
> > would prevent the statistics from being exported and then imported.
> > Can this export/import of statistics be done at a single table level or
> > does it have
> > to be a full database export? If not at the table level can it be done at
> > the schema
> > level?
> >
> > Thanks everyone,
> > Gary Bonner
> > [EMAIL PROTECTED]
> >
> > --
> > 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: Jared Still
  INET: [EMAIL PROTECTED]

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

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






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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Fire your DBA's you don't need them anymore...

[Henry Poras]

Title: Fire your DBA's you don't need them anymore...



I 
think they run Metalink. Anyway i-dba sounds like something from an old Tarzan 
movie. i-dba u-pooh.

  -Original Message-From: Gary Weber 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, May 25, 2001 12:27 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Fire your DBA's you don't need them anymore...
  Very 
  stupid thing to do by Oracle, considering the fact that many Oracle purchasing 
  decisions are made by Oracle DBAs. To shut us out like that will most 
  certainly have an effect on Oracle Sales. Hell, you don't need me anymore? 
  I'll switch political sides and jump the ship to IBM, or  
  Microsoft...
   
  Far 
  as their "superior" i-dba team, I sure hope those are different people from 
  the ones you get on first line of Support...
   
  Gary 
  Weber
   
  PS. 
  Or maybe we should all become Oracle salesmen 
  (saleswomen)
   
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Bowes, ChrisSent: 
  Friday, May 25, 2001 12:02 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Fire your DBA's you don't need them 
  anymore...
  My boss just received a cold call from Oracle that 
  he let me listen in on.  They have a new push on for their i-dba support 
  package.  For just a little more money (they did not define little), "we 
  will replace your dba's with our superior support team that will monitor your 
  database 24x7 and proactively eliminate problems.  This will allow you to 
  redesign you office to offload these cumbersome DBA tasks and allow your 
  workers to do other things.  You will never have another database 
  problem."   I felt good when my boss indicated that we had no base 
  problems but based on this, I guess we will have to become sqlserver DBAs or 
    developers...    :)
  Ahh, Friday, wonderful Friday,  it seems like 
  you've been away all week... 
  --Chris [EMAIL PROTECTED] 

Re: How many times has an index been used?

[Jared Still]

There is commercial software for determining this.

www.teleran.com
www.pinecone.com

Both rather spendy.

Jared


On Thursday 24 May 2001 06:10, Wilkes, Steve wrote:
> Hi,
>
> Does anyone know how to determine how many times an index has been used or
> if it has been used at all? I have seen previous attempts by taking
> snapshots of v$sqlarea and then automating an explain plan and extracting
> the information that way. I would have thought that there must be an x$
> table that records this information somewhere?
>
> Any ideas?
>
> Thanks in advance.
>
> Steve Wilkes
> ___
> Oracle DBA
> npower
> email:[EMAIL PROTECTED]
>
> =
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> gpupower.co.uk or [EMAIL PROTECTED]
>
> This outgoing e-mail (and any attachments) has been checked
> (using Sophos Sweep 3.45 + patches) before leaving us (UK 08457 353637),
> and has been found to be clean from any virus infection.
>
> =
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

RE: Odd core dump - possibly listener related

[Henry Poras]

We have also seen trace and alert logs occasionally written to
$ORACLE_HOME/rdbms/logs instead of bdump. It is almost always a shutdown
abort/crash. Of course this isn't true for all aborts. Maybe when Oracle is
in a hurry it uses its default instead of the non-default init.ora
parameters.

Henry

-Original Message-
Sent: Friday, May 25, 2001 3:10 AM
To: Multiple recipients of list ORACLE-L


--core dump ended up in $ORACLE_HOME/dbs

i think there is no space in the destination where u r storing the dumps...
just
one point to have a look atmay or may not be correct

RB

"Deshpande, Kirti" wrote:

> Hi Lisa,
> Yes, we have seen this occasional core dump in the ?/dbs dir. Tried to
chase
> it down, gave up on OWS and TAR got closed. The last time it happened was
a
> month or so ago on HP-UX 11.0 and 8.1.6.2.  As you said, there are many
> other things to worry about.
>  If your 'mini-me' chases this down, I would like to know. BTW... How does
> he like Oracle's new music selection?
>
>  Congratulations for getting another job !!
>  Going further South or back to North?
>
>  Regards,
>
> - Kirti Deshpande
>   Verizon Information Services
>http://www.superpages.com
>
> > -Original Message-
> > From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
> > Sent: Thursday, May 24, 2001 10:57 AM
> > To:   Multiple recipients of list ORACLE-L
> > Subject:  Odd core dump - possibly listener related
> >
> > Hello all,
> >
> > My mini-me (aka Junior DBA) noticed a core dump this morning.  Good,
> > attention to detail.  However, there's no unusual errors in the alert
log
> > for either databases on this host and there's no errors in the listener
> > log at all.  The core dump says something about pseudo cursor and
> > references a port that isn't dedicated to the listener.
> >
> > Here's my take on it:  The database is fine.  The listener is fine.  The
> > app is fine.  With nothing in the logs I have no idea where to look.  I
> > don't even know how this core dump ended up in $ORACLE_HOME/dbs (the
> > default), my core_dump_dest is set to a different directory.  Searching
on
> > metalink returns nothing.
> >
> > Mini-me (mini?  6'4") wants to chase this down.  I think it works, don't
> > fix it.  The occasional core dump is normal and there are a ton of other
> > things to attend to.  Does anyone disagree?
> >
> > So my question is, has anyone seen this before?  we are hp/ux 11.0,
> > 8.1.6.2
> >
> > Thanks everyone, and au revoir.  I start a new job on Tuesday.
> >
> > Lisa Rutland Koivu
> > Oracle Database Administrator > "urn:schemas-microsoft-com:office:office" />
> >
> > Certified Self-Important Database Deity
> >
> > Slayer of Unix Administrators
> >
> > Wanton Kickboxing Goddess
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deshpande, Kirti
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Henry Poras
  INET: [EMAIL PROTECTED]

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

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

RE: OT: RE: Steve Adam's Removal

[Rachel Carmichael]

Alex,

Are you deliberately trying to be insulting or is just an innate part of 
your personality?

You are one of the people who complain about "off-topic" postings and tell 
people to stop posting on certain topics. Is this a right you reserve only 
for yourself? How is a discussion of what happens on a different list 
on-topic for this list?

Henry is not excluding anyone from lazydba for discussing what happened, in 
fact, he opened a special discussion forum just for that purpose -- and both 
Steve Adams and Christopher Spence have the ability (and have used it) to 
post to that discussion forum to represent their point of view.

Rachel

>From: "Hillman, Alex" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT: RE: Steve Adam's Removal
>Date: Fri, 25 May 2001 12:12:23 -0800
>
>Why not - looks like to discuss this on that other list is a good way to be
>excluded from that list (not that it will  be a big loss). Apparently you
>again know what everybody else should do and think - which topic to discuss
>and which not.
>
>Alex Hillman
>
>-Original Message-
>Sent: Friday, May 25, 2001 3:26 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Jacques,
>
>thank you for saying that so elegantly. Members of this list who are also 
>on
>
>lazydba should confine their discussion to that list.
>
>And if you don't know the players, it's not fair to beat up on someone.
>
>I happen to know both of them. My only comment is: I hope that they can 
>work
>
>this out satisfactorily between them. Any other input is not helpful.
>
>Rachel
>
>
> >From: Jacques Kilchoer <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: OT: RE: Steve Adam's Removal
> >Date: Fri, 25 May 2001 09:32:56 -0800
> >
> >Disclaimer: I have no affiliation with LazyDba or the owner of the 
>LazyDba
> >mailing list, and have not subscribed to that list.
> >
> >My personal opinion, for what it's worth:
> >I don't think that this list is an appropriate place to impugn the 
>motives
> >of the owner(s), or discuss the inadequacies, of other mailing
> >lists/personal websites, unless the question is posed to the list, e.g.
> >"Should I join lazydba?"
> >In addition, I would think it would be more professional to restrict 
>one's
> >comments to the technical value of said website or list.
> >
> >--
> >Jacques R. Kilchoer
> >(949) 754-8816
> >Quest Software, Inc.
> >8001 Irvine Center Drive
> >Irvine, California 92618
> >U.S.A.
> >http://www.quest.com
>
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.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: Hillman, Alex
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

_
Get your FREE download of MSN Explorer at http://explorer.msn.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: OT: Winnie quote

[Jared Still]

LOL!!

Needed a good laugh, thanks.

Jared

On Friday 25 May 2001 09:15, Thater, William wrote:
> On Fri, 25 May 2001,Dennis Taylor scribbled on the wall in glitter crayon:
>
> ->At 04:55 PM 5/24/01 -0800, you wrote:
> ->>
> ->>That 'quote' isn't from Pooh at all, it's probably from Walt @#$$^^@!
> ->>Disney.  The REAL Pooh is much wiser than that cheap greetings-card
> stuff! ->>
> ->
> ->Oh, bother.
> said Pooh,"Eyore lock phasers on the Heffalump.  Piglet meet me in
> transporter room three."
>
> --
> Bill Thater Certifiable ORACLE DBA
> Telergy, Inc.[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.
> ~~
> From C:\*.* to shining C:\*.*
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

RE: Steve Adam's Removal

[Bill Conner]

>
>As such, my site will be unavailable due to it's helpful nature.

Please leave your site up.  i liked it.


>"Walking on water and developing software from a specification are easy if
>both are frozen."
>
>Christopher R. Spence
>Oracle DBA
>Fuelspot
>
>
>
>-Original Message-
>Sent: Friday, May 25, 2001 10:17 AM
>To: Multiple recipients of list ORACLE-L
>
>
>I guess the lazy DBAs got tired of reading Oracle Internals.  They just want
>simple answers. :)
>
>Richard Ji
>
> >>> [EMAIL PROTECTED] 05/25/01 07:15AM >>>
>you're right -- Henry isn't the list owner here in any case.
>
>For those of you who want to discuss this, Henry set up a discussion forum
>on the lazydba site.
>
>AFAIK, Steve is still a member of Oracle-L :)
>
>
> >From: Robertson Lee - lerobe <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE: Steve Adam's Removal
> >Date: Fri, 25 May 2001 02:16:06 -0800
> >
> >Erm... am I missing something but wasn't the original mail removing Steve
> >Adams from the lazydba discussion list and not this one ??
> >
> >Cheers
> >
> >Lee
> >
> >
> >-Original Message-
> >Sent: 25 May 2001 10:56
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Dear Henry,
> >
> >   Please reconsider this issue !
> >I am sure there are many-many more who want to request not
> >to remove Steve and would support my mail, but are afraid
> >that other's mail-box would fill up by these request only..
> >   To be frank & honest, he is the only list member who
> >has a folder in my outlook( I am not offending any-body
> >else)
> >   Seriously ... please dont' do this
> >
> >Best Regards,
> >Rajesh
> >
> >-Original Message-
> >Sent: Friday, May 25, 2001 9:26 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >i hope this thread is still alive and my reply makes it to the
> >list...
> >
> >by removing Steve from the list , we all will miss the insight into
> >oracle
> >internals,
> >which he provided , thru his answers and the links (plugs ? ) to his
> >website..
> >
> >many threads would end when Steve provides his explanation/answer, this
> >show
> >
> >the respect posters have for his knowledge or Oracle.
> >
> >please reconsider
> >
> >Regards
> >Rahul
> >
> >
> > > --
> > > From:   Suhen Pather[SMTP:[EMAIL PROTECTED]]
> > > Sent:   Friday, May 25, 2001 6:36 AM
> > > To: LazyDBA.com Discussion
> > > Subject:RE: Steve Adam's Removal
> > >
> > > Henry,  List
> > >
> > > I second you on this one.
> > > I respect Henry being the list owner, having authority to do as he
> > > pleases.
> > >
> > > ORACLE -L is possibly the best Oracle list out there,and has brought
> >so
> > > many
> > >
> > > Oracle professionals together, but lets not lose our experts.
> > >
> > > Please reconsider the removal of Steve Adams from the list.
> > >
> > > He takes up lots of his time to answer performance related questions
> > > posted by list members with precise actions to be taken and great
> > > explanations.
> > >
> > > He is an invaluable member to the Oracle world and his expertise,
> > > generosity
> > > will
> > > surely be missed if he removed.
> > >
> > > Kind Regards and pls reconsider
> > > Suhen
> > >
> > >
> > >
> > >
> > > List,
> > >
> > > While I respect Henry's authority as list owner to remove people from
> >the
> > > list, and the need to do so when people are breaking the rules, I
> >would
> > > like
> > > to protest the removal of Steve Adams.  He is one of the top experts
> >in
> > > Oracle internals in the world, and he was gracious enough to take time
> >to
> > > answer people's questions on the list.
> > >
> > > I am not sure what he ever did that was thought to be spamming, except
> > > answer people's questions.  He has a link to his website in his
> >signature,
> > > and often his answers were links to a place on his site where he had
> > > already
> > > answered that question.  I don't see what's wrong with that, none of
> >it
> > > seems to violate the rules of the list.
> > >
> > > If it was a matter of one or two people complaining about Steve's
> >posts,
> > > perhaps the list should have been asked.  I can only hope that the
> > > overwhelming majority understood Steve's method of answering questions
> >and
> > > were not annoyed with it.
> > >
> > > The show now knows a lot less about Oracle Internal Services.
> > >
> > > Reed Sutton
> > >
> > >
> > >
> > > -Original Message-
> > > From: Henry O'Keeffe [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, May 24, 2001 8:58 AM
> > > To: LazyDBA.com Discussion
> > > Subject: Re: Spamming the list
> > >
> > >
> > > I'm afraid, you'll actually have to leave the list Steve. Picking
> >lines
> > > from
> > > private emails sent between us, and presenting them out of context
> >isn't
> > > something that most people would have expected from you. I'm sorry
> >that
> > > it's
> > > had to come

Re: Odd core dump - possibly listener related

[Jared Still]

At a previous employer, if we chased down every core dump
we would never have time for anything else.

ORA-7445 almost always dumps core, and it's one of those
errors that can never be successfully eradicated, at least in
a large environment with many servers, many users and
many different versions of Oracle.

Jared


On Thursday 24 May 2001 08:56, Koivu, Lisa wrote:
> Hello all,
>
> My mini-me (aka Junior DBA) noticed a core dump this morning.  Good,
> attention to detail.  However, there's no unusual errors in the alert log
> for either databases on this host and there's no errors in the listener log
> at all.  The core dump says something about pseudo cursor and references a
> port that isn't dedicated to the listener.
>
> Here's my take on it:  The database is fine.  The listener is fine.  The
> app is fine.  With nothing in the logs I have no idea where to look.  I
> don't even know how this core dump ended up in $ORACLE_HOME/dbs (the
> default), my core_dump_dest is set to a different directory.  Searching on
> metalink returns nothing.
>
> Mini-me (mini?  6'4") wants to chase this down.  I think it works, don't
> fix it.  The occasional core dump is normal and there are a ton of other
> things to attend to.  Does anyone disagree?
>
> So my question is, has anyone seen this before?  we are hp/ux 11.0, 8.1.6.2
>
> Thanks everyone, and au revoir.  I start a new job on Tuesday.
>
>
> Lisa Rutland Koivu
> Oracle Database Administrator "urn:schemas-microsoft-com:office:office" />
>
> Certified Self-Important Database Deity
>
> Slayer of Unix Administrators
>
> Wanton Kickboxing Goddess
>
>
> [EMAIL PROTECTED]
>   
>  NeoMedia 
> 4850 N.State Road 7, G104
>
> Ft. Lauderdale, FL  33319
> Phone: 954-484-3191 x 174
> Fax: 954-484-2933
> www.neom.com 
> www.paperclick.com 
> www.qode.com 
>
>
>   
>
>
>   P a p e r C l i c k . c o m
>
>
>
>
>
>
>
>
>  Enter Your PaperClick Code Here!


Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: 7bit
Content-Description: 

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

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

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

RE: how to find out internal's password???

[Sunil_Nookala]

try this(on your dev box first):
1.select instance_name from v$instance;
@command line,
2.oradim80 -delete -sid 
3.oradim80 -new -sid (instance name> -intpwd 

now you have a new password for internal.

Sunil Nookala
Dell Corporation,
Austin, TX

-Original Message-
Sent: Friday, May 25, 2001 1:07 PM
To: Multiple recipients of list ORACLE-L


This is in additional to my previous question about
how to turn off passowrd for internal:

To try to turn off pwd for internal, I commented out
remote_login_passwordfile = exclusive in the init
file, now I need to shutdown and restart the database.
 I tried to login as internal to shutdown the db, when
it askes for password, I tried a bunch things
including sys, manager, and they all failed.  So I
used sqlplus system/pwd to login and do shutdown, the
database is down, but now I cannot login to svrmgrl to
startup the database, since I don't know internal's
password.  So my question is how to find out
internal's password?  Thanks a lot.

Janet


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janet Linsy
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Resolved!! Another Downed Database

[Deshpande, Kirti]

Laura, 
Wow !!  You are on a roll here..
Congratulations! 
Pl Keep all those steps documented. Before you know it, you will be proudly
helping out someone else. 

Well Done..

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

> -Original Message-
> From: Burton, Laura L. [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, May 25, 2001 2:06 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Resolved!!  Another Downed Database
> 
> I wanted to let everyone know that my (un)archived, no cold backup
> database is now up!!  I took Oracle's advice and started with the full
> physical backup and did not apply the differential backup.  I then entered
> Recover Database and when the messsage came back 'database recovered' I
> just stood there and stared at the screen.  When I finally started
> breathing because I was turning blue, I opened the database, and it
> opened!  I couldn't believe it after all the things I've read.  Although I
> did lose one week's worth of data, in this case it is something we can
> live with.  Needless to say I am going to put it in archivelog mode ASAP.
> Oh, and I did curve the urge to let everyone know until I shut the
> database back down and got a good backup (as one of the respondees had
> suggested).
> 
> Many thanks to all who replied.  Whether the suggestions helped or not it
> is always nice to know that someone knows what you're going through and
> are trying to help.
> 
> I know you learn more 'by fire', but I think I am going to go home now and
> sit under the spinkler 
> 
> Thanks again, 
> Laura 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

Re: OT: My bad

[Rachel Carmichael]

Chuck,

no, actually it's not your bad.

This list is set up such that a "reply" in most mail programs will reply 
only to the list. It was done deliberately I believe, to see if the 
duplication of messages could be eliminated when people WANT to reply to the 
list.

Takes some learning curve time, but eventually you learn to LOOK at the To 
field before hitting the send

Welcome!

Rachel


>From: "Speaks, Chuck W." <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: OT:  My bad
>Date: Fri, 25 May 2001 09:57:47 -0800
>
>I didn't mean to reply-all.  That's my bad.
>
>Chuck Speaks, MCSE
>Database Administrator
>Lithonia Lighting
>770-922-9000  x3450
>http://www.lithonia.com
>
>
>-Original Message-
>Sent: Friday, May 25, 2001 12:56 PM
>To: '[EMAIL PROTECTED]'
>
>
>Sounds pretty standard.
>
>Chuck Speaks, MCSE
>Database Administrator
>Lithonia Lighting
>770-922-9000  x3450
>http://www.lithonia.com
>
>
>-Original Message-
>Sent: Friday, May 25, 2001 1:08 PM
>To: Multiple recipients of list ORACLE-L
>
>
>We have one little rule that most folks follow
>pretty well.
>
>If it's not about Oracle or oracle proper, we usually
>place an "OFFTOPIC" or "OT" in the first position of
>the subject line.
>
>|| -Original Message-
>|| From: Speaks, Chuck W. [mailto:[EMAIL PROTECTED]]
>|| Sent: Friday, May 25, 2001 12:21 PM
>|| To: Multiple recipients of list ORACLE-L
>|| Subject: RE: New member
>||
>||
>|| Sounds great.  I am a Lazy DBA refugee and I must say that I
>|| like the tone
>|| and banter on this list a lot better.  I'll be talking to
>|| you guys soon.
>|| It's good to see familiar names like Chris Spence and Steve
>|| Adams, for they
>|| are outlaws on other sites.  REAL TROUBLEMAKERS!
>||
>|| Chuck Speaks, MCSE
>|| Database Administrator
>|| Lithonia Lighting
>|| 770-922-9000  x3450
>|| http://www.lithonia.com
>||
>||
>|| -Original Message-
>|| Sent: Friday, May 25, 2001 11:43 AM
>|| To: Multiple recipients of list ORACLE-L
>||
>||
>|| Welcome, Chuck.
>||
>|| Welcome to a Land of Microsoft Zealots, Bigots, And Agnostics.
>||
>|| Welcome to a List where politics and recipes are posted with
>|| equal fervor as SQL Tuning tips.
>||
>|| The water's fine!
>||
>|| || -Original Message-
>|| || From: Speaks, Chuck W. [mailto:[EMAIL PROTECTED]]
>|| || Sent: Friday, May 25, 2001 11:07 AM
>|| || To: Multiple recipients of list ORACLE-L
>|| || Subject: New member
>|| ||
>|| ||
>|| || Hello,
>|| ||
>|| || Just wanted to introduce myself before posting to the list.
>|| || I look forward
>|| || to interacting with you guys/ladies on the list.  Have a
>|| || great Friday!
>|| ||
>|| || Chuck Speaks, MCSE
>|| || Database Administrator
>|| || Lithonia Lighting
>|| || 770-922-9000  x3450
>|| || http://www.lithonia.com
>|| ||
>|| || --
>|| || Please see the official ORACLE-L FAQ: http://www.orafaq.com
>|| || --
>|| || Author: Speaks, Chuck W.
>|| ||   INET: [EMAIL PROTECTED]
>|| ||
>|| || Fat City Network Services-- (858) 538-5051  FAX:
>|| (858) 538-5051
>|| || San Diego, California-- Public Internet access /
>|| || Mailing Lists
>|| ||
>|| 
>|| || To REMOVE yourself from this mailing list, send an E-Mail message
>|| || to: [EMAIL PROTECTED] (note EXACT spelling of
>|| 'ListGuru') and in
>|| || the message BODY, include a line containing: UNSUB ORACLE-L
>|| || (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: Mohan, Ross
>||   INET: [EMAIL PROTECTED]
>||
>|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>|| San Diego, California-- Public Internet access /
>|| Mailing Lists
>|| 
>|| To REMOVE yourself from this mailing list, send an E-Mail message
>|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>|| the message BODY, include a line containing: UNSUB ORACLE-L
>|| (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: Speaks, Chuck W.
>||   INET: [EMAIL PROTECTED]
>||
>|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>|| San Diego, California-- Public Internet access /
>|| Mailing Lists
>|| 
>|| To REMOVE yourself from this mailing list, send an E-Mail message
>|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>|| the message BODY, include a line containing: UNSUB ORACLE-L
>|| (or the name of mailing list you want to be removed from).  You may
>|| als

Re: OT: RE: Steve Adam's Removal

[Rachel Carmichael]

Jacques,

thank you for saying that so elegantly. Members of this list who are also on 
lazydba should confine their discussion to that list.

And if you don't know the players, it's not fair to beat up on someone.

I happen to know both of them. My only comment is: I hope that they can work 
this out satisfactorily between them. Any other input is not helpful.

Rachel


>From: Jacques Kilchoer <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: OT: RE: Steve Adam's Removal
>Date: Fri, 25 May 2001 09:32:56 -0800
>
>Disclaimer: I have no affiliation with LazyDba or the owner of the LazyDba
>mailing list, and have not subscribed to that list.
>
>My personal opinion, for what it's worth:
>I don't think that this list is an appropriate place to impugn the motives
>of the owner(s), or discuss the inadequacies, of other mailing
>lists/personal websites, unless the question is posed to the list, e.g.
>"Should I join lazydba?"
>In addition, I would think it would be more professional to restrict one's
>comments to the technical value of said website or list.
>
>--
>Jacques R. Kilchoer
>(949) 754-8816
>Quest Software, Inc.
>8001 Irvine Center Drive
>Irvine, California 92618
>U.S.A.
>http://www.quest.com

_
Get your FREE download of MSN Explorer at http://explorer.msn.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: Exporting and Importing table statistics

[Jared Still]

On Friday 25 May 2001 01:05, Saurabh Sharma wrote:
> i feel this is at the full database export level.
> once u export ur database, u can import it as it is into another database
> and it'll create allthe required definitions for u.
> the statistics are exported with the tablespace and table definitions.
>
> hope i'm sure. if not pls correct.

OK, not correct.  Statistics are not exported, check the manual.

EXP will recalculate statistics, but doesn't export them.  At least
I can find no indication of it.

You can use Oracle's plan stability feature however via CREATE OUTLINE.

Jared


>
> saurabh
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Friday, May 25, 2001 3:48 AM
>
> > Hi all,
> > According to the 8i utilities manual I should be able to export a tables'
> > statistics
> > from one database, then import those statistics into another database.
> > I have tried various combinations of export and import scripts but
> > nothing seems to
> > work. My table has none of the restrictions described in the utilities
> > manual that
> > would prevent the statistics from being exported and then imported.
> > Can this export/import of statistics be done at a single table level or
> > does it have
> > to be a full database export? If not at the table level can it be done at
> > the schema
> > level?
> >
> > Thanks everyone,
> > Gary Bonner
> > [EMAIL PROTECTED]
> >
> > --
> > 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: Jared Still
  INET: [EMAIL PROTECTED]

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

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

RE: Bad SQL.....

[Rajaram]

Remember - Drink responsibly - Kidding.

Raj.


-Original Message-
From:   Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, May 25, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Bad SQL.

Thank you very much.  I was thinking that I needed to do a nested select.
It worked great.  I'll have a beer for you after I leave work!  :)

Dave

-Original Message-
Sent: Friday, May 25, 2001 1:46 PM
To: Multiple recipients of list ORACLE-L


I think it's just Friday.  You need to rewrite your statement to read 
something like this:

UPDATE AVAILABLE_POWER SET available_power_driver_terminated = 'Y'
where available_power.driver_id in (select manpowerprofile.mpp_id
from manpowerprofile where manpowerprofile.mpp_terminationdt <> 
to_date('31-DEC-2049','DD-MON-') )

At 09:01 AM 5/25/01 -0800, you wrote:
>I am trying to write an update statement but seem to be having problems.
>Below is my statement and the error in SQL*Plus.
>
>
>   1  UPDATE AVAILABLE_POWER SET available_power.driver_terminated = 'Y'
>   2WHERE available_power.driver_id = manpowerprofile.mpp_id
>   3*and manpowerprofile.mpp_terminationdt <>
>TO_DATE('31-DEC-2049','DD-MON-')
>SQL> /
>and manpowerprofile.mpp_terminationdt <>
>TO_DATE('31-DEC-2049','DD-MON-')
>*
>ERROR at line 3:
>ORA-00904: invalid column name
>
>
>I know that manpowerprofile.mpp_terminationdt is a valid table column.  Do
I
>need to do some type of join on these two tables?  Or is it just Friday and
>I should give up and go have a cold beer!!:o)  Any advice would be
>appreciated.
>
>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).

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

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

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

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

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

NetZero Platinum
No Banner Ads and Unlimited Access
Sign Up Today - Only $9.95 per month!
http://www.netzero.net
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rajaram
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Database Trigger Confusion

[Jared Still]

On Thursday 24 May 2001 10:51, Yexley Robert D SSgt AFIT/SCA wrote:
> CREATE OR REPLACE TRIGGER endb.budget_total_amt_hist_trg
>   BEFORE UPDATE of total_amt_auth, expiration on endb.budget
   ^
Time to Read the Fine Manual.

You can't use columns on the BEFORE UPDATE clause unless they
are part of a nested table.

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

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

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

RE: Fire your DBA's you don't need them anymore...

[Henry Poras]

Title: Fire your DBA's you don't need them anymore...



I was 
just reading 'Oracle 9i New Features: Summary' which I downloaded from OTN. One 
great line was "New features, tools and techniques are also provided to make 
what little an administrator has left to do a delight."
 
Henry

  -Original Message-From: Vergara, Michael (TEM) 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, May 25, 2001 1:29 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Fire your DBA's you don't need them anymore...
  I can remember as far back as version 7.3 where 
  Oracle was touting that
  "you won't need a DBA for our new database".  It 
  hasn't happened yet, 
  has it?  Oh yes, it's easier, but we're still 
  here!
   
  And besides, what were they offering in the cold 
  call?  Replacing your
  DBAs with their DBAs.  At (probably) twice the 
  price.  Outsourcing Lives!
   
  Just my $0.02 worth.
   
  Mike
   
  ---
  ===
  Michael P. 
  Vergara  
  | I’ve got a PBS mind in an MTV world
  Oracle 
  DBA  
  |
  Guidant 
  Corporation 
  |
  
-Original Message-From: Gary Weber 
[mailto:[EMAIL PROTECTED]]Sent: Friday, May 25, 2001 9:27 
AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Fire your DBA's you don't need them anymore...
Very stupid thing to do by Oracle, considering the fact that many 
Oracle purchasing decisions are made by Oracle DBAs. To shut us out like 
that will most certainly have an effect on Oracle Sales. Hell, you don't 
need me anymore? I'll switch political sides and jump the ship to IBM, or 
 Microsoft...
 
Far as their "superior" i-dba team, I sure hope those are different 
people from the ones you get on first line of Support...
 
Gary Weber
 
PS. Or maybe we should all become Oracle salesmen 
(saleswomen)
 
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Bowes, ChrisSent: 
Friday, May 25, 2001 12:02 PMTo: Multiple recipients of list 
ORACLE-LSubject: Fire your DBA's you don't need them 
anymore...
My boss just received a cold call from Oracle 
that he let me listen in on.  They have a new push on for their i-dba 
support package.  For just a little more money (they did not define 
little), "we will replace your dba's with our superior support team that 
will monitor your database 24x7 and proactively eliminate problems.  
This will allow you to redesign you office to offload these cumbersome DBA 
tasks and allow your workers to do other things.  You will never have 
another database problem."   I felt good when my boss indicated 
that we had no base problems but based on this, I guess we will have to 
become sqlserver DBAs or   developers...    
:)
Ahh, Friday, wonderful Friday,  it seems 
like you've been away all week... 
--Chris [EMAIL PROTECTED] 

RE: Fire your DBA's you don't need them anymore...

[DBarbour]

And perhaps apply for a job as Corporate Philosopher?

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


   
   
"Thater,   
   
William" To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>  
 Subject: RE: Fire your DBA's you don't 
need them anymore...  
Sent by:   
   
root@fatcity.  
   
com
   
   
   
   
   
05/25/2001 
   
12:18 PM   
   
Please 
   
respond to 
   
ORACLE-L   
   
   
   
   
   




On Fri, 25 May 2001,Gary Weber scribbled on the wall in glitter crayon:

->Very stupid thing to do by Oracle, considering the fact that many Oracle
->purchasing decisions are made by Oracle DBAs. To shut us out like that
->will most certainly have an effect on Oracle Sales. Hell, you don't need
->me anymore? I'll switch political sides and jump the ship to IBM, or
-> Microsoft...

however it's just the thing my damagement would like to hear.  guess i
better get working on my resume.

--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc.[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.
~~
>From C:\*.* to shining C:\*.*

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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:OT: RE: Fire your DBA's you don't need them anymore...

[dgoulet]

Yosi,

I interviewed for one of those jobs here in Boston, MA.  Although there was
one VERY good individual in the bunch I was a little perplexed by the others. 
Most were very junior and had not been in an outside shop before, one was
straight out of school and bootcamp and only one had done a real recovery.  It
also hit me as strange that other than the smart guy, none of them had ever
created a database from scratch.  Thankfully I did not take the job.

Dick Goulet

Reply Separator
Author: "Gene Sais" <[EMAIL PROTECTED]>
Date:   5/25/2001 11:52 AM

>From experience, I have used consultants from Oracle.  The 1st one sent was
right out of DBA school.  We sent him back after 1 week.  At that time, Oracle
didn't allow you to interview their DBA's.  According to Oracle, they were all
good.  The 2nd DBA Oracle sent had only NT experience, never been on a Unix
machine.  Ok, sent him back too.  By this time, we were about to give up, then
Oracle sent DBA #3 and she was sharp.  The moral of the story, Oracle will send
the juniors 1st b/c they save the good ones for the 3rd strike :)


>>> [EMAIL PROTECTED] 05/25/01 03:01PM >>>
I was once one of those superior i-dba consultants. I was pretty good,
and as with this list, some of my colleagues were amazingly talented,
knowledgable and great to work with. Others were, well, others.

It's lots of fun to ridicule, disparage, deride, belittle, and mock
Oracle Consulting, and don't even get me started about Oracle Support,
and I do this all the time too, I just want to put in a good word
for SOME of my old friends.

Have a great weekend.

Yosi


> -Original Message-
> From: PD Miller [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, May 25, 2001 1:58 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Fire your DBA's you don't need them anymore...
> 
> 
> I've just spent most of today repairing damage left at a site by some 
> of Oracle's 'superior' consultants!
> 
> At 8:27 -0800 25/5/01, Gary Weber wrote:
> >Far as their "superior" i-dba team, I sure hope those are different 
> >people from the ones you get on first line of Support...
> 
> Cheers
> 
> Paul Miller
> -- 
> -
> Banned and proud of it!
> 
> Carib Data Limited
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: PD Miller
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Gene Sais
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: how to find out internal's password???

[Chaim . Katz]

I think you said this was on NT?  Use (administrative tools, user manager) and
add yourself to the ORA_DBA group. Then you can
CONNECT / as SYSDBA  without specifying a password. CONNECT INTERNAL. will
probably also work without a password, although its syntax is depreciated, I
know it works at least to 8.1.6

By adding yourself to the ORA_DBA group you avoid the password file completely.
Its only when using a password file that you need to provide a password for
INTERNAL or SYS; and the password is not the SYS database password - but the
password that was supplied when the  ORAPWD utility was used.

Hth a little,
Chaim





anyone who is a member of this group can connect internally without giving a
password  either




Janet Linsy <[EMAIL PROTECTED]> on 05/25/2001 02:06:46 PM

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Chaim Katz/Completions/Bombardier)




This is in additional to my previous question about
how to turn off passowrd for internal:

To try to turn off pwd for internal, I commented out
remote_login_passwordfile = exclusive in the init
file, now I need to shutdown and restart the database.
 I tried to login as internal to shutdown the db, when
it askes for password, I tried a bunch things
including sys, manager, and they all failed.  So I
used sqlplus system/pwd to login and do shutdown, the
database is down, but now I cannot login to svrmgrl to
startup the database, since I don't know internal's
password.  So my question is how to find out
internal's password?  Thanks a lot.

Janet


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janet Linsy
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Fire your DBA's you don't need them anymore...

[Ron Rogers]

If the i-DBA team  walks the walk and talks the talk and convinces your damagement to 
"let them house your database needs" then they can provide full attention to it and 
have it running as "smooth and reliable as Metal-slink"
Read all of the fine and super-fine print and don't forget to threat, grovel, and 
bith and moan when the damagement says they are looking onto getting you some help.
I think that it was great your boss let you listen to the conversation!!!
ROR mª¿ªm

>>> [EMAIL PROTECTED] 05/25/01 01:37PM >>>
They conveniently forget that most of the tasks
of many DBAs consist in responding to requests
from developers that need to be actioned immediately,
not via telephone or e-mails.  But then again, their
"superior" support staff should be able to "proactively"
predict these?   ;-)

Sounds like another attempt at the old model of the
"one size fits all".

Of course some DBAs have been doing remote admin for
years, and at a cost that beats theirs by a country mile.
But that's another story.

BTW, it's not only ORACLE that is doing this.  IBM/GSA is
into it as well in a BIG way in Australia.

Cheers
Nuno Souto
[EMAIL PROTECTED] 
http://www.users.bigpond.net.au/the_Den 
- Original Message -


> My boss just received a cold call from Oracle that he let me listen
in on.
> They have a new push on for their i-dba support package.  For just a
little
> more money (they did not define little), "we will replace your dba's
with
> our superior support team that will monitor your database 24x7 and
> proactively eliminate problems.  This will allow you to redesign you
office
> to offload these cumbersome DBA tasks and allow your workers to do
other
> things.  You will never have another database problem."   I felt
good when
> my boss indicated that we had no base problems but based on this, I
guess we
> will have to become sqlserver DBAs or   developers...:)
>


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

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

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

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

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

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

RE: Bad SQL.....

[Regina Harter]

At 11:25 AM 5/25/01 -0800, you wrote:
>Thank you very much.  I was thinking that I needed to do a nested select.
>It worked great.  I'll have a beer for you after I leave work!  :)
>
>Dave

Thanks Dave!  Can you have some chocolate for me too?

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

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

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

Sql Performance

[Valiveru, Siva]

Gurus,

Will there be any performance gain by going for query1 instead of query2.

Query1:
select col1,col2, col3,..col2n from tab;

Query2:

select * from tab;

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: backspace in Oracle.

[Jared Still]

Ron,

I see that you have received a number of emails suggesting that
you use 'stty erase '.

Unfortunately, that is not quite correct.

I have experienced the same problem on both of my Linux boxes,
and have found that even though the backspace is set correctly
at the unix command line, it does not work corrrectly in SQL*Plus.

I've found this to be true with other software as well.

Here's the workaround:  Get the shell to take your backspace
key literally, and then it will work.

This is done by pressing -V , then pressing backspace.

e.g.  stty erase -V .

All should be fine now, both at the command line and in SQL*Plus.

Not sure why this is, and haven't taken the time to figure it out.

Jared
 
On Friday 25 May 2001 10:01, Ron Rogers wrote:
> List,
>  I have created a test server using Linux 7.1 and Oracle 8.1.7.3 and it
> works great. The major problem I am having is "I am NOT a typist" and make
> errors at the SQL prompt. What do I set or define in the glogin to allow
> backspace to work as a backspace in Oracle? It has been a while since I had
> the privilege of UNIX ( in any flavor) Any info would be appreciated.
> Thanks,
> ROR mª¿ªm
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

Re: BUNYAMIN POSTS HAVE A VIRUS

[Jared Still]

I didn't see the apology until the next day.

Since he hadn't replied to my personal email on the matter,
he was unsubscribed.

He's since been re-subscribed.

Jared


On Friday 25 May 2001 06:51, Burton, Laura L. wrote:
> Didn't he send an email to the list yesterday apologizing for this and
> stated that he had no idea it was happening?
>
> Laura
>
> -Original Message-
> Sent: Thursday, May 24, 2001 9:10 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Well, I sent him an email about this last night, and no
> reply yet.
>
> Or was it this morning?  Anyway, it was dark.  :)
>
> I guess he gets unsubscribed now.  :(
>
> Jared


Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: 7bit
Content-Description: 

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

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

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

Re: Script to compare two schemas

[Jared Still]

On Thursday 24 May 2001 17:20, Helmut Daiminger wrote:
> Does anybody out there have a script to compare to database schemas and
> list the differences?


I'm forwarding a post I made on this topic a few days ago.

Jared

--  Forwarded Message  --
Date: Sun, 13 May 2001 21:44:53 -0700
To: "Oracle-L List, [EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED], "Mohan, Ross [EMAIL PROTECTED]" 
<[EMAIL PROTECTED]>


The database compare script didn't come out to well the first
time, so I've just embedded them in this post.

The scripts are:

clears.sql
columns.sql
title.sql
schema_diff.sql

Jared

--- title.sql - copied from title80.sql
-- specify line width when calling
-- eg @title 'report heading' 90

rem TITLE.SQL   - This SQL*Plus script builds a standard report
rem   heading for database reports that are XX columns
rem
column  TODAY   NEW_VALUE   CURRENT_DATENOPRINT
column  TIMENEW_VALUE   CURRENT_TIMENOPRINT
column  DATABASENEW_VALUE   DATA_BASE   NOPRINT
set term off feed off
rem
define COMPANY = "BCBSO"
define HEADING = "&1"
col cPageNumLoc new_value PageNumLoc noprint
select ('&&2' - 10 ) cPageNumLoc from dual;
rem
TTITLE LEFT "Date: " current_date CENTER company col &&PageNumLoc "Page:"
format 999 -
   SQL.PNO SKIP 1 LEFT "Time: " current_time CENTER heading RIGHT -
   format a15 SQL.USER SKIP 1 CENTER format a20 data_base SKIP 2
rem
rem
set heading off
set pagesize 0
rem
column passout new_value dbname noprint
SELECT TO_CHAR(SYSDATE,'MM/DD/YY') TODAY,
   TO_CHAR(SYSDATE,'HH:MI AM') TIME,
   --DATABASE||' Database' DATABASE,
   --rtrim(database) passout
   name||' Database' DATABASE,
   lower(rtrim(name)) passout
FROM   v$database;
set term on feed on
rem
set heading on
set pagesize 58
set line &&2
set newpage 0
define db = '_&dbname'
undef 1 2
---

-- columns.sql

col blocks format 99,999,999 head 'BLOCKS'
col db_link format a30 head 'DB LINK'
col db_link_instance format a30 head 'DB LINK|INSTANCE'
col db_link_username format a10 head 'DB LINK|USERNAME'
col empty_blocks format 99,999,999 head 'EMPTY BLOCKS'
col host format a10 head 'HOST'
col index_name format a30 head 'INDEX NAME'
col initial_extent format 9,999,999,999 head 'INITIAL|EXTENT'
col instance format a4 head 'INST'
col max_blocks format 9,999,999 head 'MAX BLOCKS'
col max_bytes format 99,999,999,999 head 'MAX BYTES'
col max_extents format 999,999 head 'MAX|EXTENTS'
col min_extents format 999 head 'MIN|EXT'
col next_extent format 9,999,999,999 head 'NEXT|EXTENT'
col object_name format a30 head 'OBJECT NAME'
col owner format a10 head 'OWNER'
col pct_free format 999 head 'PCT|FREE'
col pct_increase format 999 head 'PCT|INC'
col pct_used format 999 head 'PCT|USED'
col synonym_name format a30 head 'SYNONYM NAME'
col table_name format a30 head 'TABLE NAME'
col table_owner format a10 head 'TABLE|OWNER'
col tablespace_name format a15 head 'TABLESPACE|NAME'
col timestamp format a19 head 'TIME STAMP'
col username format a10 head 'USERNAME'
col last_ddl_time head 'LAST DDL|TIME'
col created head 'CREATED'
col procedure_name format a30 head 'PROCEDURE NAME'
col function_name format a30 head 'FUNCTION NAME'
col package_name format a30 head 'PACKAGE NAME'
col package_body_name format a30 head 'PACKAGE BODY NAME'
col segment_name format a30 head 'SEGMENT NAME'

--

-- clears.sql
set pause off
set echo off
set trimspool on
set feed on term on echo off verify off
set line 80
set pages 24 head on

clear col
clear break
clear computes

btitle ''
ttitle ''

btitle off
ttitle off

---

-- schema_diff.sql
-- Jared Still
-- [EMAIL PROTECTED]
-- [EMAIL PROTECTED]
--
--
-- 07/14/1999 jkstill - removed table_owner from the index_diff
--  section as this made all indexes appear
--  in the difference report if the schemas
--  had different names
--  -
-- this script will create reports of the
-- differences between 2 schemas
-- the reports created are:

-- table_diff.txt
-- index_diff.txt
-- arg_diff.txt
-- sequence_diff.txt

-- all differences are checked both
-- ways - schema1 is compared to schema2
-- and then schema2 is compared to schema1
-- it does not matter which database the
-- reports are initiated from

-- requirements:
--
-- either global links or database links to
-- the schemas to be compared
--
-- dba privileges
--

-- this report creates temporary tables for it's reports
-- they are left intact for your perusal
-- tables:
--   arg_diff
--   index_diff
--   table_diff
--

-- REPORT SUMMARY

-- table_diff.txt
-- this report compares tables from 2 schemas
-- included are
--tables/columns that appear in a table in
--one schema, and not the other
--
--any differences between columns; includes
--order of column, type and size.


-- index_diff.txt
-- this report co

Re: Steve Adam's Removal

[Jared Still]

I would suggest that we discontinue this thread.  It's pretty tame
so far, but has a lot of potential for turning into an opportunity
to bash others, and we don't need it.

FYI Steve Adams has not been removed from this list.  To get
removed from this list requires quite a bit of effort on your part,
or not responding to the list owners (me) emails when asking
about your account sending a  virus to all posters on the list.

The following is a public service announcement for all of you
cross posters:

This is the Oracle-L list at FatCity.com,  dedicated to all things
Oracle, and anything else that Oracleites find interesting.

I am the owner of this list, Henry O'Keeffe is the owner of LazyDba.com
and the OracleDBA list there.

Jared Still


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

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

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

Re: Standby vs. Adv. Replication (Multi-master)

[Jared Still]

On Friday 25 May 2001 10:52, Jeremiah Wilton wrote:

> Things that can weight the decision on the side of standby:
> - Frequent DDL changes - requires outage for MM rep.
...

This email is a keeper!

>
> Anyone in Seattle want to get together for beers?  I'll drag the other
> Amazon DBAs along, if you can stand the sight of a passel of geeks.  Reply
> to me, not the list.

Well, if I find myself going to Seattle, I'll call first. ( I'm in Portland )

I saw that Amazon was looking for a DBA.  Any chance of a telecommuting DBA?

Not interested in relocating. ( again :)

Jared


>
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
>
> On Fri, 25 May 2001, Jack C. Applewhite wrote:
> > We have a Standby database and I love it - especially compared to the
> > complexities of  replication!
> >
> > Once you set up the standby database, automate the mechanism for
> > transferring archived redo logs from your production db to the standby,
> > applying them, and deleting them once applied, it requires almost no
> > intervention.  About the only time I have to fiddle with the standby is
> > after I add a datafile to a tablespace on the production db.
> >
> > We're on 8.1.6 under Win2k and our production db has almost 8 million
> > CLOB documents, with about 50,000 added each night.  The standby keeps up
> > nicely.
> >
> > -Original Message-
> >
> > I'm looking for feedback on setting up a
> > high-availability architecture for our production
> > database. In a nutshell, we are a 24-hour shop and I
> > need to be able to keep a secondary database
> > (failover) in sync with the primary in case the
> > primary fails. I have supported advanced replication
> > (asynchronous) in the past but it was a single master
> > relationship not multi-master.
> >
> > I'm leaning towards a standby database setup because
> > my experience with advanced replication is less than
> > favorable if/when transactions get out of sync. Also,
> > one of the tables contains a LONG RAW. This column may
> > go away or may be converted to a CLOB in the very near
> > future but still needs to be kept in consideration
> > when selecting a solution.
> >
> > The platform is Sun (SunOS 5.7) with 8.1.6. The
> > secondary machine and database will most likely be
> > located in another state. The database is small right
> > now (~10Gb) and will continue to grow, but not too
> > fast.
> >
> > What are your opinions?
> > Is there an obvious choice between the two
> > alternatives?
> > Is there another alternative that I should be
> > considering?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

Resolved!! Another Downed Database

[Burton, Laura L.]

Title: Resolved!!  Another Downed Database





I wanted to let everyone know that my (un)archived, no cold backup database is now up!!  I took Oracle's advice and started with the full physical backup and did not apply the differential backup.  I then entered Recover Database and when the messsage came back 'database recovered' I just stood there and stared at the screen.  When I finally started breathing because I was turning blue, I opened the database, and it opened!  I couldn't believe it after all the things I've read.  Although I did lose one week's worth of data, in this case it is something we can live with.  Needless to say I am going to put it in archivelog mode ASAP.  Oh, and I did curve the urge to let everyone know until I shut the database back down and got a good backup (as one of the respondees had suggested).

Many thanks to all who replied.  Whether the suggestions helped or not it is always nice to know that someone knows what you're going through and are trying to help.

I know you learn more 'by fire', but I think I am going to go home now and sit under the spinkler


Thanks again,
Laura

RE: OT: RE: Steve Adam's Removal

[Hillman, Alex]

Why not - looks like to discuss this on that other list is a good way to be
excluded from that list (not that it will  be a big loss). Apparently you
again know what everybody else should do and think - which topic to discuss
and which not.

Alex Hillman

-Original Message-
Sent: Friday, May 25, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L


Jacques,

thank you for saying that so elegantly. Members of this list who are also on

lazydba should confine their discussion to that list.

And if you don't know the players, it's not fair to beat up on someone.

I happen to know both of them. My only comment is: I hope that they can work

this out satisfactorily between them. Any other input is not helpful.

Rachel


>From: Jacques Kilchoer <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: OT: RE: Steve Adam's Removal
>Date: Fri, 25 May 2001 09:32:56 -0800
>
>Disclaimer: I have no affiliation with LazyDba or the owner of the LazyDba
>mailing list, and have not subscribed to that list.
>
>My personal opinion, for what it's worth:
>I don't think that this list is an appropriate place to impugn the motives
>of the owner(s), or discuss the inadequacies, of other mailing
>lists/personal websites, unless the question is posed to the list, e.g.
>"Should I join lazydba?"
>In addition, I would think it would be more professional to restrict one's
>comments to the technical value of said website or list.
>
>--
>Jacques R. Kilchoer
>(949) 754-8816
>Quest Software, Inc.
>8001 Irvine Center Drive
>Irvine, California 92618
>U.S.A.
>http://www.quest.com

_
Get your FREE download of MSN Explorer at http://explorer.msn.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: Hillman, Alex
  INET: [EMAIL PROTECTED]

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

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

Re: Standby vs. Adv. Replication (Multi-master)

[Jared Still]

On Friday 25 May 2001 10:52, Jeremiah Wilton wrote:
> Things that can weight the decision on the side of standby:
> - Frequent DDL changes - requires outage for MM rep.


Argh!!!  I sent my previous reply to *everyone*.

I *hate* when that happens.  I was a long time Pine user and
am still not used to this new mail software.

Sorry,

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

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

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

OT: Learning by Fire

[Vergara, Michael (TEM)]

Title: Resolved!! Another Downed Database




> I know you 
learn more 'by fire', but I think I am going to go home now and sit under the 
spinkler 
I was in a job interview a few years ago, and the 
interviewer asked me to
tell him about one of my big successes.  
Stumped.  I told him I could not
think of a big success, but I remember every one of the 
failures.  He
laughed and said "Yep.  It's the one's that leave 
you limping that you
remember".
 
I didn't get the job, but I remember the 
interview!
 
Mike
 
---
===
Michael P. 
Vergara  
| I’ve got a PBS mind in an MTV world
Oracle 
DBA  
|
Guidant 
Corporation 
|

  -Original Message-From: Burton, Laura L. 
  [mailto:[EMAIL PROTECTED]]Sent: Friday, May 25, 2001 12:06 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Resolved!! Another Downed Database
  I wanted to let everyone know that my (un)archived, 
  no cold backup database is now up!!  I took Oracle's advice and started 
  with the full physical backup and did not apply the differential backup.  
  I then entered Recover Database and when the messsage came back 'database 
  recovered' I just stood there and stared at the screen.  When I finally 
  started breathing because I was turning blue, I opened the database, and it 
  opened!  I couldn't believe it after all the things I've read.  
  Although I did lose one week's worth of data, in this case it is something we 
  can live with.  Needless to say I am going to put it in archivelog mode 
  ASAP.  Oh, and I did curve the urge to let everyone know until I shut the 
  database back down and got a good backup (as one of the respondees had 
  suggested).
  Many thanks to all who replied.  Whether the 
  suggestions helped or not it is always nice to know that someone knows what 
  you're going through and are trying to help.
  I know you learn more 'by fire', but I think I am 
  going to go home now and sit under the spinkler 
  Thanks again, Laura 

RE: Bad SQL.....

[Farnsworth, Dave]

Thank you very much.  I was thinking that I needed to do a nested select.
It worked great.  I'll have a beer for you after I leave work!  :)

Dave

-Original Message-
Sent: Friday, May 25, 2001 1:46 PM
To: Multiple recipients of list ORACLE-L


I think it's just Friday.  You need to rewrite your statement to read 
something like this:

UPDATE AVAILABLE_POWER SET available_power_driver_terminated = 'Y'
where available_power.driver_id in (select manpowerprofile.mpp_id
from manpowerprofile where manpowerprofile.mpp_terminationdt <> 
to_date('31-DEC-2049','DD-MON-') )

At 09:01 AM 5/25/01 -0800, you wrote:
>I am trying to write an update statement but seem to be having problems.
>Below is my statement and the error in SQL*Plus.
>
>
>   1  UPDATE AVAILABLE_POWER SET available_power.driver_terminated = 'Y'
>   2WHERE available_power.driver_id = manpowerprofile.mpp_id
>   3*and manpowerprofile.mpp_terminationdt <>
>TO_DATE('31-DEC-2049','DD-MON-')
>SQL> /
>and manpowerprofile.mpp_terminationdt <>
>TO_DATE('31-DEC-2049','DD-MON-')
>*
>ERROR at line 3:
>ORA-00904: invalid column name
>
>
>I know that manpowerprofile.mpp_terminationdt is a valid table column.  Do
I
>need to do some type of join on these two tables?  Or is it just Friday and
>I should give up and go have a cold beer!!:o)  Any advice would be
>appreciated.
>
>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).

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

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

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

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

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

Re: OT: RE: Steve Adam's Removal

[Jared Still]

Thank you Jacques, for your posts on this topic.

Jared

On Friday 25 May 2001 11:12, Jacques Kilchoer wrote:
> Something else I forgot to mention in my previous e-mail on this topic.
>
> Maintaining a website, or a mailing list, is an arduous task that provides
> great benefits to many people at little or no cost to them. I have been a
> member of the ORACLE-L list (with gaps in membership) for many months and
> have never regretted it.
>
> It is also important to remember that Jared Still puts in a great deal of
> (unrenumerated) hours to maintain this list and make sure it stays on
> focus. So remember this when you have the chance to to Jared Still a
> favour. To use a popular expression, we all owe him big-time.
>
> Bruce Bergman also deserves our thanks for making archives of this list
> available at the fatcity website.
>
> And finally, thank you to all the posters who take their valuable time to
> answer the questions here. You know who you are, so I'm not going to try to
> list names, because I'm sure I would forget someone and I would hate to
> receive a cream pie in the face at an Oracle conference some day.
>
> --
> Jacques R. Kilchoer
> (949) 754-8816
> Quest Software, Inc.
> 8001 Irvine Center Drive
> Irvine, California 92618
> U.S.A.
> http://www.quest.com


Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 

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

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

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

RE: backspace in Oracle.

[Deshpande, Kirti]

Jared,
 Is that something specific to Linux? 
 The other way (without the -V) works fine on HP-UX and AIX. 
- Kirti 

> -Original Message-
> From: Jared Still [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, May 25, 2001 2:26 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: backspace in Oracle.
> 
> 
> 
> Ron,
> 
> I see that you have received a number of emails suggesting that
> you use 'stty erase '.
> 
> Unfortunately, that is not quite correct.
> 
> I have experienced the same problem on both of my Linux boxes,
> and have found that even though the backspace is set correctly
> at the unix command line, it does not work corrrectly in SQL*Plus.
> 
> I've found this to be true with other software as well.
> 
> Here's the workaround:  Get the shell to take your backspace
> key literally, and then it will work.
> 
> This is done by pressing , then pressing backspace.
> 
> e.g.  stty erase -V .
> 
> All should be fine now, both at the command line and in SQL*Plus.
> 
> Not sure why this is, and haven't taken the time to figure it out.
> 
> Jared
>  
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

RE: OT: My bad

[Speaks, Chuck W.]

SWEET!  I always wanted to be the weakest link! GOODBYE

Chuck Speaks, MCSE
Database Administrator
Lithonia Lighting
770-922-9000  x3450
http://www.lithonia.com


-Original Message-
Sent: Friday, May 25, 2001 3:16 PM
To: Multiple recipients of list ORACLE-L


I call for your immediate removal from this list.  We do not tolerate 
mistakes.  Goodbye - you are the weakest link!

Just kidding...welcome.

Jim

> I didn't mean to reply-all.  That's my bad.  
> 
> Chuck Speaks, MCSE
> Database Administrator
> Lithonia Lighting
> 770-922-9000  x3450
> http://www.lithonia.com
> 
> 
> -Original Message-
> Sent: Friday, May 25, 2001 12:56 PM
> To: '[EMAIL PROTECTED]'
> 
> 
> Sounds pretty standard.
> 
> Chuck Speaks, MCSE
> Database Administrator
> Lithonia Lighting
> 770-922-9000  x3450
> http://www.lithonia.com
> 
> 
> -Original Message-
> Sent: Friday, May 25, 2001 1:08 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> We have one little rule that most folks follow
> pretty well. 
> 
> If it's not about Oracle or oracle proper, we usually
> place an "OFFTOPIC" or "OT" in the first position of
> the subject line. 
> 
> || -Original Message-
> || From: Speaks, Chuck W. [mailto:[EMAIL PROTECTED]]
> || Sent: Friday, May 25, 2001 12:21 PM
> || To: Multiple recipients of list ORACLE-L
> || Subject: RE: New member
> || 
> || 
> || Sounds great.  I am a Lazy DBA refugee and I must say that I 
> || like the tone
> || and banter on this list a lot better.  I'll be talking to 
> || you guys soon.
> || It's good to see familiar names like Chris Spence and Steve 
> || Adams, for they
> || are outlaws on other sites.  REAL TROUBLEMAKERS!
> || 
> || Chuck Speaks, MCSE
> || Database Administrator
> || Lithonia Lighting
> || 770-922-9000  x3450
> || http://www.lithonia.com
> || 
> || 
> || -Original Message-
> || Sent: Friday, May 25, 2001 11:43 AM
> || To: Multiple recipients of list ORACLE-L
> || 
> || 
> || Welcome, Chuck. 
> || 
> || Welcome to a Land of Microsoft Zealots, Bigots, And Agnostics. 
> || 
> || Welcome to a List where politics and recipes are posted with
> || equal fervor as SQL Tuning tips. 
> || 
> || The water's fine!
> || 
> || || -Original Message-
> || || From: Speaks, Chuck W. [mailto:[EMAIL PROTECTED]]
> || || Sent: Friday, May 25, 2001 11:07 AM
> || || To: Multiple recipients of list ORACLE-L
> || || Subject: New member
> || || 
> || || 
> || || Hello,
> || || 
> || || Just wanted to introduce myself before posting to the list.  
> || || I look forward
> || || to interacting with you guys/ladies on the list.  Have a 
> || || great Friday!
> || || 
> || || Chuck Speaks, MCSE
> || || Database Administrator
> || || Lithonia Lighting
> || || 770-922-9000  x3450
> || || http://www.lithonia.com
> || || 
> || || -- 
> || || Please see the official ORACLE-L FAQ: http://www.orafaq.com
> || || -- 
> || || Author: Speaks, Chuck W.
> || ||   INET: [EMAIL PROTECTED]
> || || 
> || || Fat City Network Services-- (858) 538-5051  FAX: 
> || (858) 538-5051
> || || San Diego, California-- Public Internet access / 
> || || Mailing Lists
> || || 
> || 
> || || To REMOVE yourself from this mailing list, send an E-Mail message
> || || to: [EMAIL PROTECTED] (note EXACT spelling of 
> || 'ListGuru') and in
> || || the message BODY, include a line containing: UNSUB ORACLE-L
> || || (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: Mohan, Ross
> ||   INET: [EMAIL PROTECTED]
> || 
> || Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> || San Diego, California-- Public Internet access / 
> || Mailing Lists
> || 
> || To REMOVE yourself from this mailing list, send an E-Mail message
> || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> || the message BODY, include a line containing: UNSUB ORACLE-L
> || (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: Speaks, Chuck W.
> ||   INET: [EMAIL PROTECTED]
> || 
> || Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> || San Diego, California-- Public Internet access / 
> || Mailing Lists
> || 
> || To REMOVE yourself from this mailing list, send an E-Mail message
> || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> || the message BODY, include a line containing: UNSUB ORACLE-L
> || (or the name of mailing list you want to be removed from).  You m

OT: RE: Fire your DBA's you don't need them anymore...

[Gene Sais]

>From experience, I have used consultants from Oracle.  The 1st one sent was right out 
>of DBA school.  We sent him back after 1 week.  At that time, Oracle didn't allow you 
>to interview their DBA's.  According to Oracle, they were all good.  The 2nd DBA 
>Oracle sent had only NT experience, never been on a Unix machine.  Ok, sent him back 
>too.  By this time, we were about to give up, then Oracle sent DBA #3 and she was 
>sharp.  The moral of the story, Oracle will send the juniors 1st b/c they save the 
>good ones for the 3rd strike :)


>>> [EMAIL PROTECTED] 05/25/01 03:01PM >>>
I was once one of those superior i-dba consultants. I was pretty good,
and as with this list, some of my colleagues were amazingly talented,
knowledgable and great to work with. Others were, well, others.

It's lots of fun to ridicule, disparage, deride, belittle, and mock
Oracle Consulting, and don't even get me started about Oracle Support,
and I do this all the time too, I just want to put in a good word
for SOME of my old friends.

Have a great weekend.

Yosi


> -Original Message-
> From: PD Miller [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, May 25, 2001 1:58 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Fire your DBA's you don't need them anymore...
> 
> 
> I've just spent most of today repairing damage left at a site by some 
> of Oracle's 'superior' consultants!
> 
> At 8:27 -0800 25/5/01, Gary Weber wrote:
> >Far as their "superior" i-dba team, I sure hope those are different 
> >people from the ones you get on first line of Support...
> 
> Cheers
> 
> Paul Miller
> -- 
> -
> Banned and proud of it!
> 
> Carib Data Limited
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com 
> -- 
> Author: PD Miller
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Gene Sais
  INET: [EMAIL PROTECTED]

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

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

Re: OT: My bad

[Jim Hawkins]

I call for your immediate removal from this list.  We do not tolerate 
mistakes.  Goodbye - you are the weakest link!

Just kidding...welcome.

Jim

> I didn't mean to reply-all.  That's my bad.  
> 
> Chuck Speaks, MCSE
> Database Administrator
> Lithonia Lighting
> 770-922-9000  x3450
> http://www.lithonia.com
> 
> 
> -Original Message-
> Sent: Friday, May 25, 2001 12:56 PM
> To: '[EMAIL PROTECTED]'
> 
> 
> Sounds pretty standard.
> 
> Chuck Speaks, MCSE
> Database Administrator
> Lithonia Lighting
> 770-922-9000  x3450
> http://www.lithonia.com
> 
> 
> -Original Message-
> Sent: Friday, May 25, 2001 1:08 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> We have one little rule that most folks follow
> pretty well. 
> 
> If it's not about Oracle or oracle proper, we usually
> place an "OFFTOPIC" or "OT" in the first position of
> the subject line. 
> 
> || -Original Message-
> || From: Speaks, Chuck W. [mailto:[EMAIL PROTECTED]]
> || Sent: Friday, May 25, 2001 12:21 PM
> || To: Multiple recipients of list ORACLE-L
> || Subject: RE: New member
> || 
> || 
> || Sounds great.  I am a Lazy DBA refugee and I must say that I 
> || like the tone
> || and banter on this list a lot better.  I'll be talking to 
> || you guys soon.
> || It's good to see familiar names like Chris Spence and Steve 
> || Adams, for they
> || are outlaws on other sites.  REAL TROUBLEMAKERS!
> || 
> || Chuck Speaks, MCSE
> || Database Administrator
> || Lithonia Lighting
> || 770-922-9000  x3450
> || http://www.lithonia.com
> || 
> || 
> || -Original Message-
> || Sent: Friday, May 25, 2001 11:43 AM
> || To: Multiple recipients of list ORACLE-L
> || 
> || 
> || Welcome, Chuck. 
> || 
> || Welcome to a Land of Microsoft Zealots, Bigots, And Agnostics. 
> || 
> || Welcome to a List where politics and recipes are posted with
> || equal fervor as SQL Tuning tips. 
> || 
> || The water's fine!
> || 
> || || -Original Message-
> || || From: Speaks, Chuck W. [mailto:[EMAIL PROTECTED]]
> || || Sent: Friday, May 25, 2001 11:07 AM
> || || To: Multiple recipients of list ORACLE-L
> || || Subject: New member
> || || 
> || || 
> || || Hello,
> || || 
> || || Just wanted to introduce myself before posting to the list.  
> || || I look forward
> || || to interacting with you guys/ladies on the list.  Have a 
> || || great Friday!
> || || 
> || || Chuck Speaks, MCSE
> || || Database Administrator
> || || Lithonia Lighting
> || || 770-922-9000  x3450
> || || http://www.lithonia.com
> || || 
> || || -- 
> || || Please see the official ORACLE-L FAQ: http://www.orafaq.com
> || || -- 
> || || Author: Speaks, Chuck W.
> || ||   INET: [EMAIL PROTECTED]
> || || 
> || || Fat City Network Services-- (858) 538-5051  FAX: 
> || (858) 538-5051
> || || San Diego, California-- Public Internet access / 
> || || Mailing Lists
> || || 
> || 
> || || To REMOVE yourself from this mailing list, send an E-Mail message
> || || to: [EMAIL PROTECTED] (note EXACT spelling of 
> || 'ListGuru') and in
> || || the message BODY, include a line containing: UNSUB ORACLE-L
> || || (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: Mohan, Ross
> ||   INET: [EMAIL PROTECTED]
> || 
> || Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> || San Diego, California-- Public Internet access / 
> || Mailing Lists
> || 
> || To REMOVE yourself from this mailing list, send an E-Mail message
> || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> || the message BODY, include a line containing: UNSUB ORACLE-L
> || (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: Speaks, Chuck W.
> ||   INET: [EMAIL PROTECTED]
> || 
> || Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> || San Diego, California-- Public Internet access / 
> || Mailing Lists
> || 
> || To REMOVE yourself from this mailing list, send an E-Mail message
> || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> || the message BODY, include a line containing: UNSUB ORACLE-L
> || (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: Mohan, Ross
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (85

RE:OT: Fire your DBA's you don't need them anymore...

[DBarbour]

Mike,

"It's easier"??  Okay, some things are less complicated, but there are
so many more things, I end up studying this stuff nearly every night.

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


   
   
"Vergara,  
   
Michael  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>  
(TEM)"   cc:   
   
  
   
Sent by:   
   
root@fatcity.  
   
com
   
   
   
   
   
05/25/2001 
   
12:28 PM   
   
Please 
   
respond to 
   
ORACLE-L   
   
   
   
   
   




I can remember as far back as version 7.3 where Oracle was touting that
"you won't need a DBA for our new database".  It hasn't happened yet,
has it?  Oh yes, it's easier, but we're still here!

And besides, what were they offering in the cold call?  Replacing your
DBAs with their DBAs.  At (probably) twice the price.  Outsourcing Lives!

Just my $0.02 worth.

Mike

---
===
Michael P. Vergara  | I've got a PBS mind in an MTV world
Oracle DBA  |
Guidant Corporation |
 -Original Message-
 From: Gary Weber [mailto:[EMAIL PROTECTED]]
 Sent: Friday, May 25, 2001 9:27 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Fire your DBA's you don't need them anymore...

 Very stupid thing to do by Oracle, considering the fact that many
 Oracle purchasing decisions are made by Oracle DBAs. To shut us out
 like that will most certainly have an effect on Oracle Sales. Hell,
 you don't need me anymore? I'll switch political sides and jump the
 ship to IBM, or  Microsoft...

 Far as their "superior" i-dba team, I sure hope those are different
 people from the ones you get on first line of Support...

 Gary Weber

 PS. Or maybe we should all become Oracle salesmen (saleswomen)

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bowes,
 Chris
 Sent: Friday, May 25, 2001 12:02 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Fire your DBA's you don't need them anymore...



 My boss just received a cold call from Oracle that he let me listen in
 on.  They have a new push on for their i-dba support package.  For
 just a little more money (they did not define little), "we will
 replace your dba's with our superior support team that will monitor
 your database 24x7 and proactively eliminate problems.  This will
 allow you to redesign you office to offload these cumbersome DBA tasks
 and allow your workers to do other things.  You will never have
 another database problem."   I felt good when my boss indicated that
 we had no base problems but based on this, I guess we will have to
 become sqlserver DBAs or   developers...:)


 Ahh, Friday, wonderful Friday,  it seems like you've been away all
 week...


 --Chris
 [EMAIL PROTECTED]







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

Re: Ok two databases..two machines..one database name

[Jared Still]

Steve,

I see that you were successful in getting this to work, but thought I 
might add to it just a bit.

I've moved that system from one box to another before, with the
addition of changing the SID and DB name.  You may not want to 
do that for some reason, but it just involves 3 other steps:

1. rebuild the control file with the new db name
2. change the SID in the oratab file
3. change the db_name in init.ora
4. change the GLOBAL_NAME with ALTER DATABASE

OK, that's 4.  I thought of another while writing it.

Jared


On Thursday 24 May 2001 17:40, Steve McClure wrote:
> I have been tasked with moving a production database to a 'backup' machine.
> I ran my plan past you a week or so ago.  Essentially I will put the DB in
> backup mode, copy the datafiles, shutdown, copy redo and control files,
> then recover on the second machine.  So far plain vanilla.  I understand
> the above procedure enough to have actually thought of it.
>
> My problem now is this.  I need to test this instance on the 'backup'
> machine before we actually do the move.  This is Just to make sure the
> application is completely in order.  One of the developers is telling me
> that having the two databases up and running with the same SID, even on
> separate machines MAY cause trouble for the production instance.  I believe
> that if I make sure the tnsnames.ora file for both servers points to their
> own local instances, that I will not have a problem.  The clients will only
> access the database pointed to in their tnsnames files, so I am confident
> we are ok there.  My question is can I have databases with the same name
> running simultaneously on two different machines if I make sure the
> tnsnames for each database points to it's own server?  The database is
> 7.3.4.  As soon as I send this off I am going to create a small DB just to
> test this out, but your input, as usual, is appreciated.
>
> Thanks,
> Steve McClure
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

recovery

[Raghu Kota]

Hi Friends

I want to test my recovery on full backup on sunday, so My backup will be 
completed on sunday 9am, Iam recovering at 10.30, Then If I restore my full 
backup including operating system, So between 9-10.30am as Iam restoring 
from 9am backup, its going to overwrite the online redo's is it not?? am I 
able to restore full recovery or any problems???

Is any other scenario's to test backup??

Please respond..

TIA
Raghu.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Steve Adam's Removal

[Boivin, Patrice J]

Yes, I'm confused as well about this.

I hope Steve that you will use Jared's list as your sanctuary...

: )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

-Original Message-
From:   Eric D. Pierce [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, May 25, 2001 3:17 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Steve Adam's Removal

removing Steve Adams from any Oracle list would be completely
stupid. what happened on lazydba?
regards,
ep


On 25 May 2001, at 2:16, Robertson Lee - lerobe wrote:

Date sent:  Fri, 25 May 2001 02:16:05 -0800
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>

> Erm... am I missing something but wasn't the original mail
removing Steve
> Adams from the lazydba discussion list and not this one ??


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Standby vs. Adv. Replication (Multi-master)

[Nancy McCormick]

I too have had the wonderful experience of supporting multi-master
replication.  We had 3 sites and there was a lot of work maintaining it.  I
have not had the opportunity to implement a standby-database yet but from
talking with those who have setting up and maintaining a standy-by database
would be less painful that setting up advanced replication.

Either way you need to evaluate your network.  One of the killers for our
initial advanced replication environment was network speed.  There just
wasn't enough 'umph' to replicate the data real-time (every 60 seconds)
between 3 sites.

We used our environment to split workload as well as provide availability
when one of the servers was down (either voluntarily or involuntarily).  The
failover was fairly straight forward, change the DNS information to point
the clients to another server and break the push jobs related to the down
server.  Getting the database back in sync afterwards was a different
matter.  We were pushing approximately 10,000 database calls an hour.  The
transaction queue would get so full that many times we simply had to do a
complete refresh of the database.

I could keep going on but I guess what I am trying to say is that if you are
going to be using the secondary database strictly for failover then it seems
to me that the standby-database solution would be easier to implement and
maintain.

Nancy

-Original Message-
Sent: Friday, May 25, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L


Hi,

I'm looking for feedback on setting up a
high-availability architecture for our production
database. In a nutshell, we are a 24-hour shop and I
need to be able to keep a secondary database
(failover) in sync with the primary in case the
primary fails. I have supported advanced replication
(asynchronous) in the past but it was a single master
relationship not multi-master.

I'm leaning towards a standby database setup because
my experience with advanced replication is less than
favorable if/when transactions get out of sync. Also,
one of the tables contains a LONG RAW. This column may
go away or may be converted to a CLOB in the very near
future but still needs to be kept in consideration
when selecting a solution.

The platform is Sun (SunOS 5.7) with 8.1.6. The
secondary machine and database will most likely be
located in another state. The database is small right
now (~10Gb) and will continue to grow, but not too
fast.

What are your opinions?
Is there an obvious choice between the two
alternatives?
Is there another alternative that I should be
considering?

Thanks VERY much in advance.
-w

__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Walter K
  INET: [EMAIL PROTECTED]

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

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

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

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

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

OT: RE: Steve Adam's Removal

[Jacques Kilchoer]

Title: OT: RE: Steve Adam's Removal





Something else I forgot to mention in my previous e-mail on this topic.


Maintaining a website, or a mailing list, is an arduous task that provides great benefits to many people at little or no cost to them. I have been a member of the ORACLE-L list (with gaps in membership) for many months and have never regretted it.

It is also important to remember that Jared Still puts in a great deal of (unrenumerated) hours to maintain this list and make sure it stays on focus. So remember this when you have the chance to to Jared Still a favour. To use a popular expression, we all owe him big-time.

Bruce Bergman also deserves our thanks for making archives of this list available at the fatcity website.


And finally, thank you to all the posters who take their valuable time to answer the questions here. You know who you are, so I'm not going to try to list names, because I'm sure I would forget someone and I would hate to receive a cream pie in the face at an Oracle conference some day.

--
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

RE: Ok two databases..two machines..one database name

[Steve McClure]

Thanks All.  My test was also successful.  I had planned on two different
aliases in tnsnames.ora.  Otherwise I would be doomed to failure.  I will
implement the differing passwords idea though.

Thanks again.
Hey that is two in a row, where I was pretty much right, but needed a little
confirmation.  I had better be careful or I am going to confidently screw up
my database one of these days.

Steve McClure

-Original Message-
From:   [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rao, Maheswara
Sent:   Friday, May 25, 2001 6:11 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: Ok two databases..two machines..one database name

We have two 804 db's with same sid running on two different machines.  One
is production and another is development.  Our TNSNAMES contain machine_name
+ sid.  This way we identify which db we are connecting.

Initially I had lot of problems getting OEM recognize these two db's.  When
I called up Oracle support, they said that I cannot have two db's with same
sid and global name and OEM agent would not recognize.  Essentially, they
washed off their hands clean.

Then, I played around with the intelligent agent file and finally OEM
started recognizing the two db's.

ONE CAUTION:

Keep your archived redo's stored separately and come up with a plan on
identifying which tape belongs to what machine.  Passwords, yes, be careful.

Rao

-Original Message-
Sent: Thursday, May 24, 2001 8:41 PM
To: Multiple recipients of list ORACLE-L


I have been tasked with moving a production database to a 'backup' machine.
I ran my plan past you a week or so ago.  Essentially I will put the DB in
backup mode, copy the datafiles, shutdown, copy redo and control files, then
recover on the second machine.  So far plain vanilla.  I understand the
above procedure enough to have actually thought of it.

My problem now is this.  I need to test this instance on the 'backup'
machine before we actually do the move.  This is Just to make sure the
application is completely in order.  One of the developers is telling me
that having the two databases up and running with the same SID, even on
separate machines MAY cause trouble for the production instance.  I believe
that if I make sure the tnsnames.ora file for both servers points to their
own local instances, that I will not have a problem.  The clients will only
access the database pointed to in their tnsnames files, so I am confident we
are ok there.  My question is can I have databases with the same name
running simultaneously on two different machines if I make sure the tnsnames
for each database points to it's own server?  The database is 7.3.4.  As
soon as I send this off I am going to create a small DB just to test this
out, but your input, as usual, is appreciated.

Thanks,
Steve McClure

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Rao, Maheswara
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Steve McClure
  INET: [EMAIL PROTECTED]

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

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

RE: how to find out internal's password???

[Morton, Ronald D]

Janet,

The default password for SYS is CHANGE_ON_INSTALL.  Maybe you will be lucky
and find that nobody changed it.  If you are running 8.1.x, then try logging
in through sqlplus as follows:

sqlplus internal

If you get in, then change the SYS password to something you want:

ALTER USER SYS IDENTIFIED BY new_password;

Hope this helps.

Ron

> -Original Message-
> From: Janet Linsy [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, May 25, 2001 2:07 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  how to find out internal's password???
> 
> This is in additional to my previous question about
> how to turn off passowrd for internal:
> 
> To try to turn off pwd for internal, I commented out
> remote_login_passwordfile = exclusive in the init
> file, now I need to shutdown and restart the database.
>  I tried to login as internal to shutdown the db, when
> it askes for password, I tried a bunch things
> including sys, manager, and they all failed.  So I
> used sqlplus system/pwd to login and do shutdown, the
> database is down, but now I cannot login to svrmgrl to
> startup the database, since I don't know internal's
> password.  So my question is how to find out
> internal's password?  Thanks a lot.
> 
> Janet
> 
> 
> __
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
> http://auctions.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Janet Linsy
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Morton, Ronald D
  INET: [EMAIL PROTECTED]

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

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

how to find out internal's password???

[Janet Linsy]

This is in additional to my previous question about
how to turn off passowrd for internal:

To try to turn off pwd for internal, I commented out
remote_login_passwordfile = exclusive in the init
file, now I need to shutdown and restart the database.
 I tried to login as internal to shutdown the db, when
it askes for password, I tried a bunch things
including sys, manager, and they all failed.  So I
used sqlplus system/pwd to login and do shutdown, the
database is down, but now I cannot login to svrmgrl to
startup the database, since I don't know internal's
password.  So my question is how to find out
internal's password?  Thanks a lot.

Janet


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janet Linsy
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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 turn off password prompt in NT???

[Boivin, Patrice J]

I don't know if it works, but with Oracle7 it was possible to bypass the
internal password when logged in at the console.

You have go to into the registry, though:

Start | Run | regedit

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

Create a new value of string type:
DBA_SID_AUTHORIZATION

[don't enter "SID", enter the SID of your local instance.]

And enter the value:  BYPASS

Reboot.

This should let you in.

Please let me know if it still works with 8i, I haven't tried it.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  


-Original Message-
From:   Janet Linsy [SMTP:[EMAIL PROTECTED]]
Sent:   Friday, May 25, 2001 2:48 PM
To: Multiple recipients of list ORACLE-L
Subject:how to turn off password prompt in NT???

Hi all,

In Windows NT, how to disable the password prompt when
login as internal through svrmgrl.

I read an article in Metalink.  The solution is for
Unix which I don't see useful to my case.  

I checked all the sqlnet.ora files and all of them
comment out SQLNET.AUTHENTICATION_SERVICES.

Suggestion?

Thanks, Janet


__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Janet Linsy
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: New member

[Speaks, Chuck W.]

Sounds pretty standard.

Chuck Speaks, MCSE
Database Administrator
Lithonia Lighting
770-922-9000  x3450
http://www.lithonia.com


-Original Message-
Sent: Friday, May 25, 2001 1:08 PM
To: Multiple recipients of list ORACLE-L


We have one little rule that most folks follow
pretty well. 

If it's not about Oracle or oracle proper, we usually
place an "OFFTOPIC" or "OT" in the first position of
the subject line. 

|| -Original Message-
|| From: Speaks, Chuck W. [mailto:[EMAIL PROTECTED]]
|| Sent: Friday, May 25, 2001 12:21 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: New member
|| 
|| 
|| Sounds great.  I am a Lazy DBA refugee and I must say that I 
|| like the tone
|| and banter on this list a lot better.  I'll be talking to 
|| you guys soon.
|| It's good to see familiar names like Chris Spence and Steve 
|| Adams, for they
|| are outlaws on other sites.  REAL TROUBLEMAKERS!
|| 
|| Chuck Speaks, MCSE
|| Database Administrator
|| Lithonia Lighting
|| 770-922-9000  x3450
|| http://www.lithonia.com
|| 
|| 
|| -Original Message-
|| Sent: Friday, May 25, 2001 11:43 AM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Welcome, Chuck. 
|| 
|| Welcome to a Land of Microsoft Zealots, Bigots, And Agnostics. 
|| 
|| Welcome to a List where politics and recipes are posted with
|| equal fervor as SQL Tuning tips. 
|| 
|| The water's fine!
|| 
|| || -Original Message-
|| || From: Speaks, Chuck W. [mailto:[EMAIL PROTECTED]]
|| || Sent: Friday, May 25, 2001 11:07 AM
|| || To: Multiple recipients of list ORACLE-L
|| || Subject: New member
|| || 
|| || 
|| || Hello,
|| || 
|| || Just wanted to introduce myself before posting to the list.  
|| || I look forward
|| || to interacting with you guys/ladies on the list.  Have a 
|| || great Friday!
|| || 
|| || Chuck Speaks, MCSE
|| || Database Administrator
|| || Lithonia Lighting
|| || 770-922-9000  x3450
|| || http://www.lithonia.com
|| || 
|| || -- 
|| || Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| || -- 
|| || Author: Speaks, Chuck W.
|| ||   INET: [EMAIL PROTECTED]
|| || 
|| || Fat City Network Services-- (858) 538-5051  FAX: 
|| (858) 538-5051
|| || San Diego, California-- Public Internet access / 
|| || Mailing Lists
|| || 
|| 
|| || To REMOVE yourself from this mailing list, send an E-Mail message
|| || to: [EMAIL PROTECTED] (note EXACT spelling of 
|| 'ListGuru') and in
|| || the message BODY, include a line containing: UNSUB ORACLE-L
|| || (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: Mohan, Ross
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Speaks, Chuck W.
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Speaks, Chuck W.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California  

RE: Fire your DBA's you don't need them anymore...

[Yosi]

I was once one of those superior i-dba consultants. I was pretty good,
and as with this list, some of my colleagues were amazingly talented,
knowledgable and great to work with. Others were, well, others.

It's lots of fun to ridicule, disparage, deride, belittle, and mock
Oracle Consulting, and don't even get me started about Oracle Support,
and I do this all the time too, I just want to put in a good word
for SOME of my old friends.

Have a great weekend.

Yosi


> -Original Message-
> From: PD Miller [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 25, 2001 1:58 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Fire your DBA's you don't need them anymore...
> 
> 
> I've just spent most of today repairing damage left at a site by some 
> of Oracle's 'superior' consultants!
> 
> At 8:27 -0800 25/5/01, Gary Weber wrote:
> >Far as their "superior" i-dba team, I sure hope those are different 
> >people from the ones you get on first line of Support...
> 
> Cheers
> 
> Paul Miller
> -- 
> -
> Banned and proud of it!
> 
> Carib Data Limited
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: PD Miller
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Fire your DBA's you don't need them anymore...

[PD Miller]

I've just spent most of today repairing damage left at a site by some 
of Oracle's 'superior' consultants!

At 8:27 -0800 25/5/01, Gary Weber wrote:
>Far as their "superior" i-dba team, I sure hope those are different 
>people from the ones you get on first line of Support...

Cheers

Paul Miller
-- 
-
Banned and proud of it!

Carib Data Limited



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

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

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

RE: OT: Winnie quote

[Thater, William]

On Fri, 25 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon:

->
->Tigger is indeed a child. Maybe I should aspire to Tigger instead of Pooh?
->
->Pooh is a bear of very little brain, but enormous practicality

He is the uncarved block of Tao.
--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc.[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.
~~
The wise person writes bomb-proof code.

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Bad SQL.....

[Jack C. Applewhite]

Dave,

You need to use a subquery in your Where clause:

..
WHERE available_power.driver_id =
 (Select manpowerprofile.mpp_id
  From   manpowerprofile
  Where  manpowerprofile.mpp_terminationdt <>
  TO_DATE('31-DEC-2049','DD-MON-')
 )

Jack


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


-Original Message-
Dave
Sent: Friday, May 25, 2001 12:01 PM
To: Multiple recipients of list ORACLE-L


I am trying to write an update statement but seem to be having problems.
Below is my statement and the error in SQL*Plus.


  1  UPDATE AVAILABLE_POWER SET available_power.driver_terminated = 'Y'
  2WHERE available_power.driver_id = manpowerprofile.mpp_id
  3*and manpowerprofile.mpp_terminationdt <>
TO_DATE('31-DEC-2049','DD-MON-')
SQL> /
   and manpowerprofile.mpp_terminationdt <>
TO_DATE('31-DEC-2049','DD-MON-')
   *
ERROR at line 3:
ORA-00904: invalid column name


I know that manpowerprofile.mpp_terminationdt is a valid table column.  Do I
need to do some type of join on these two tables?  Or is it just Friday and
I should give up and go have a cold beer!!:o)  Any advice would be
appreciated.

Thanks,

Dave

-- 
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: Fire your DBA's you don't need them anymore...

[Terry Ball]

I passed Gary's e-mail around the office and we all had a good laugh.
Our consensus was;  the support Oracle already provides, our DB's would
be down for ages every time there was a problem and the solution would
be to recreate the DB.

Terry

Gary Weber wrote:

>  Very stupid thing to do by Oracle, considering the fact that many
> Oracle purchasing decisions are made by Oracle DBAs. To shut us out
> like that will most certainly have an effect on Oracle Sales. Hell,
> you don't need me anymore? I'll switch political sides and jump the
> ship to IBM, or  Microsoft...Far as their "superior" i-dba team,
> I sure hope those are different people from the ones you get on first
> line of Support...Gary WeberPS. Or maybe we should all become Oracle
> salesmen (saleswomen)
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bowes,
> Chris
> Sent: Friday, May 25, 2001 12:02 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Fire your DBA's you don't need them anymore...
>
> My boss just received a cold call from Oracle that he let me listen in
> on.  They have a new push on for their i-dba support package.  For
> just a little more money (they did not define little), "we will
> replace your dba's with our superior support team that will monitor
> your database 24x7 and proactively eliminate problems.  This will
> allow you to redesign you office to offload these cumbersome DBA tasks
> and allow your workers to do other things.  You will never have
> another database problem."   I felt good when my boss indicated that
> we had no base problems but based on this, I guess we will have to
> become sqlserver DBAs or   developers...:)
>
> Ahh, Friday, wonderful Friday,  it seems like you've been away all
> week...
>
> --Chris
> [EMAIL PROTECTED]

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Fire your DBA's you don't need them anymore...

[Rodd Holman]

One thing their service doesn't cover.  Meetings!!  As a DBA I am always 
called into various project meetings to discuss things like design, 
optimization, hardware (we are SA/DBA's here), and other things realted 
to this.  What does oracle propse for that?  Oh I know hire their 
consulting services - onsite all the time.  Sure that would be cheaper 
than having a DBA on staff ... ;-)
Rodd Holman

Original Message dated 5/25/01, 12:28:53 PM
Author: "Vergara," Michael "(TEM)" <[EMAIL PROTECTED]>
Re: RE: Fire your DBA's you don't need them anymore...:


I can remember as far back as version 7.3 where Oracle was touting that
"you won't need a DBA for our new database".  It hasn't happened yet, 
has it?  Oh yes, it's easier, but we're still here!
 
And besides, what were they offering in the cold call?  Replacing your
DBAs with their DBAs.  At (probably) twice the price.  Outsourcing Lives!
 
Just my $0.02 worth.
 
Mike
 
---

===
Michael P. Vergara  | Ive got a PBS mind in an MTV world
Oracle DBA  |
Guidant Corporation |
-Original Message-
Sent: Friday, May 25, 2001 9:27 AM
To: Multiple recipients of list ORACLE-L
Very stupid thing to do by Oracle, considering the fact that many Oracle 
purchasing decisions are made by Oracle DBAs. To shut us out like that will 
most certainly have an effect on Oracle Sales. Hell, you don't need me 
anymore? I'll switch political sides and jump the ship to IBM, or  
Microsoft...
 
Far as their "superior" i-dba team, I sure hope those are different 
people from the ones you get on first line of Support...
 
Gary Weber
 
PS. Or maybe we should all become Oracle salesmen (saleswomen)
 
-Original Message-
s
Sent: Friday, May 25, 2001 12:02 PM
To: Multiple recipients of list ORACLE-L
My boss just received a cold call from Oracle that he let me listen in on.  
They have a new push on for their i-dba support package.  For just a little 
more money (they did not define little), "we will replace your dba's with 
our superior support team that will monitor your database 24x7 and 
proactively eliminate problems.  This will allow you to redesign you office 
to offload these cumbersome DBA tasks and allow your workers to do other 
things.  You will never have another database problem."   I felt good when 
my boss indicated that we had no base problems but based on this, I guess 
we will have to become sqlserver DBAs or   developers...:)
Ahh, Friday, wonderful Friday,  it seems like you've been away all 
week... 
--Chris 
[EMAIL PROTECTED] 
--=_4D4800BBE07C0987E3B8
Content-Description: filename="text1.html"
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable





RE: Fire your DBA's you don't need them anymore...






One thing their service doesn't cover.  Meetings!!  As a DBA I am
always called into various project meetings to discuss things like
design, optimization, hardware (we are SA/DBA's here), and other things
realted to this.  What does oracle propse for that?  Oh I know hire
their consulting services - onsite all the time.  Sure that would be
cheaper than having a DBA on staff ... ;-)
Rodd Holman

Original Message dated 5/25/01, 12:28:53
PM
Author: "Vergara," Michael
"(TEM)" <[EMAIL PROTECTED]>
Re: RE: Fire your DBA's you don't need
them anymore...:



I
can remember as far back as version 7.3 where Oracle was touting 
that
"you
won't need a DBA for our new database".  It hasn't happened
yet, 

has
it?  Oh yes, it's easier, but we're still here!
 
And
besides, what were they offering in the cold call?  Replacing 
your
DBAs
with their DBAs.  At (probably) twice the price.  Outsourcing
Lives!
 
Just
my $0.02 worth.
 
Mike
 
---
===
Michael
P. 
Vergara 
| Ive got a PBS mind in an MTV world
Oracle
DBA 
|
Guidant
Corporation
|

-Original Message-From:
Gary Weber [mailto:[EMAIL PROTECTED]]Sent: Friday, May 25, 2001
9:27 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: Fire your DBA's you don't need them anymore...
Very
stupid thing to do by Oracle, considering the fact that many Oracle
purchasing decisions are made by Oracle DBAs. To shut us out like that
will most certainly have an effect on Oracle Sales. Hell, you don't
need me anymore? I'll switch political sides and jump the ship to IBM,
or  Microsoft...
 
Far
as their "superior" i-dba team, I sure hope those are
different people from the ones you get on first line of 
Support...
 
Gary
Weber
 
PS.
Or maybe we should all become Oracle salesmen 
(saleswomen)
 
-Original
Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Bowes, ChrisSent:
Friday, May 25, 2001 12:02 PMTo: Multiple recipients of list
ORACLE-LSubject: Fire your DBA's you don't need them

Re: Another Database Down

[Jared Still]

Interesting stuff about 'fuzzy' SCN's and files.

A couple of notes on MetaLink with pertinent information:
22956.1
1015544.102

The second one has the added benefit of making clear why
your database should be shut down cleanly before taking a
cold backup.

Jared



On Friday 25 May 2001 07:46, Jim Hawkins wrote:
> Laura,
>
> I fight this nearly every damn day.  We constantly refresh several SAP
> systems from production copies via EMC BCV's and TimeFinder.  About half of
> the time, I get the same error, where recovery was successful, but open
> resetlogs would fail.  It turns out, in my case, that no amount of recovery
> will every get this database open (even with resetlogs) with this backup
> set.  Apparently there is an issue with a piece of the EMC software that
> causes problems when mirrors are split during a hot backup.  To make a long
> story short, there is an event you can set in via a server manager session
> that will dump all datafile headers.  What you look for is what Oracle
> calls a "fuzzy SCN".  That is, an SCN hex value that evaluates to a non-
> sensical number.  In English, the SCN for the header should have some hex
> value that corresponds to a number.  If it is set to something like
> FFx, then you have a "fuzzy SCN" which means your backup is bad and
> will never work.  I don't know if this is your exact problem or not, but
> since you're getting the same symptoms I was, I thought I would throw it
> out there.  You can read more on MetaLink by searching for "fuzzy SCN".  By
> the way, as soon as our RS/6000 SA upgraded our version of PowerPath, the
> bug went away, we have consistent mirror splits, and all is well on the SAP
> backup/restore front...
>
> Sorry if I threw you way off on a tangent on this one.
>
> Jim
>
> Jim Hawkins
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

Re:RE: New member

[dgoulet]

We like the troublemakers here!!

Reply Separator
Author: "Speaks; Chuck W." <[EMAIL PROTECTED]>
Date:   5/25/2001 8:21 AM

Sounds great.  I am a Lazy DBA refugee and I must say that I like the tone
and banter on this list a lot better.  I'll be talking to you guys soon.
It's good to see familiar names like Chris Spence and Steve Adams, for they
are outlaws on other sites.  REAL TROUBLEMAKERS!

Chuck Speaks, MCSE
Database Administrator
Lithonia Lighting
770-922-9000  x3450
http://www.lithonia.com


-Original Message-
Sent: Friday, May 25, 2001 11:43 AM
To: Multiple recipients of list ORACLE-L


Welcome, Chuck. 

Welcome to a Land of Microsoft Zealots, Bigots, And Agnostics. 

Welcome to a List where politics and recipes are posted with
equal fervor as SQL Tuning tips. 

The water's fine!

|| -Original Message-
|| From: Speaks, Chuck W. [mailto:[EMAIL PROTECTED]]
|| Sent: Friday, May 25, 2001 11:07 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: New member
|| 
|| 
|| Hello,
|| 
|| Just wanted to introduce myself before posting to the list.  
|| I look forward
|| to interacting with you guys/ladies on the list.  Have a 
|| great Friday!
|| 
|| Chuck Speaks, MCSE
|| Database Administrator
|| Lithonia Lighting
|| 770-922-9000  x3450
|| http://www.lithonia.com
|| 
|| -- 
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| -- 
|| Author: Speaks, Chuck W.
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Speaks, Chuck W.
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Steve Adam's Removal

[Christopher Spence]

If you know why it was done, it makes sense.  
It isn't brilliant or moral, but makes sense given the mentality.


"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, May 25, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L


Isn't that (removing Steve from Lazydba) akin to removing your brain to
spite the space between your ears?

Scott Shafer
San Antonio, TX
210-581-6217

"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup de Grâce via your Ninja
Death Touch, you step on a beer bottle and fall backwards into the juke box
and get your head stove in by a drunk with a pool cue."  --Jay Trigg

> -Original Message-
> From: Robertson Lee - lerobe [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, May 25, 2001 5:16 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Steve Adam's Removal
> 
> Erm... am I missing something but wasn't the original mail removing Steve
> Adams from the lazydba discussion list and not this one ??
> 
> Cheers
> 
> Lee
> 
-- 
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: Christopher Spence
  INET: [EMAIL PROTECTED]

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

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

Re: Fire your DBA's you don't need them anymore...

[Nuno Souto]

They conveniently forget that most of the tasks
of many DBAs consist in responding to requests
from developers that need to be actioned immediately,
not via telephone or e-mails.  But then again, their
"superior" support staff should be able to "proactively"
predict these?   ;-)

Sounds like another attempt at the old model of the
"one size fits all".

Of course some DBAs have been doing remote admin for
years, and at a cost that beats theirs by a country mile.
But that's another story.

BTW, it's not only ORACLE that is doing this.  IBM/GSA is
into it as well in a BIG way in Australia.

Cheers
Nuno Souto
[EMAIL PROTECTED]
http://www.users.bigpond.net.au/the_Den
- Original Message -


> My boss just received a cold call from Oracle that he let me listen
in on.
> They have a new push on for their i-dba support package.  For just a
little
> more money (they did not define little), "we will replace your dba's
with
> our superior support team that will monitor your database 24x7 and
> proactively eliminate problems.  This will allow you to redesign you
office
> to offload these cumbersome DBA tasks and allow your workers to do
other
> things.  You will never have another database problem."   I felt
good when
> my boss indicated that we had no base problems but based on this, I
guess we
> will have to become sqlserver DBAs or   developers...:)
>


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Standby vs. Adv. Replication (Multi-master)

[Walter K]

Thank you for your excellent feedback. And, thank you
for reminding me that replication requires quiescing
the databases for DDL changes! :-( Ughh, as soon as I
read that I quickly remembered spending late nights
doing application upgrades from 2 years ago and the
hassle I had to go through because it was in a
replicated environment.

I found a variety of white papers on this topic today
that I'm going to read over the weekend. Fun wow.

-w

--- Jeremiah Wilton <[EMAIL PROTECTED]> wrote:
> Things that can weight the decision on the side of
> standby:
> - Frequent DDL changes - requires outage for MM rep.
> - Very high rate of DML - MM rep may fall behind.
> - High latency network - MM rep may fall behind
> - Allowable failover time is over 10 minutes.
> - Losing the last few minutes of transactions is OK.
> - It is economically acceptable to have a whole
> system sitting idle.
> 
> Things that can weight the decision on the side of
> MM replication:
> - Both systems must be usable.
> - low rate of DDL changes
> - low rate of DML
> - good network between systems
> - No committed data loss is acceptable
> - Failover must be instant
> 
> There are other solutions that you might find worth
> investigation:
> 
> - Standby + geomirring of logs & controlfiles - (0
> data loss standby)
> - Shared disk cluster - OPS or HA configuration (DB
> is not redundant, but host is)
> - Quest SharePlex (log-based replication a la
> Sybase)
> - Redundancy within a single host (hardware
> components, RAID mirroring,
>   listener, logfile, application redundancy)
> - Just a good fast enterprise backup & restore
> 
> You get to do the calculation - based on your
> businsess's needs, which gets the
> correct amount of availability with the fewest
> dollars in the most *likely*
> disaster scenarios?
> 
> So, I've ditched LazyDBA as well.  I guess I just
> never know everyone was over
> here.  There are a lot less questions here where the
> answer is RTFM.  All those
> people over there wanting to cheat on their OCP
> class homework were starting to
> get on my nerves.  This last little hullabaloo was
> just the last straw.  They
> really were a bunch of lazy DBAs.  Too lazy to crack
> a manual.
> 
> Anyone in Seattle want to get together for beers? 
> I'll drag the other Amazon
> DBAs along, if you can stand the sight of a passel
> of geeks.  Reply to me, not
> the list.
> 
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
> 
> On Fri, 25 May 2001, Jack C. Applewhite wrote:
> 
> > We have a Standby database and I love it -
> especially compared to the
> > complexities of  replication!
> >
> > Once you set up the standby database, automate the
> mechanism for
> > transferring archived redo logs from your
> production db to the standby,
> > applying them, and deleting them once applied, it
> requires almost no
> > intervention.  About the only time I have to
> fiddle with the standby is
> > after I add a datafile to a tablespace on the
> production db.
> >
> > We're on 8.1.6 under Win2k and our production db
> has almost 8 million CLOB
> > documents, with about 50,000 added each night. 
> The standby keeps up nicely.
> >
> > -Original Message-
> >
> > I'm looking for feedback on setting up a
> > high-availability architecture for our production
> > database. In a nutshell, we are a 24-hour shop and
> I
> > need to be able to keep a secondary database
> > (failover) in sync with the primary in case the
> > primary fails. I have supported advanced
> replication
> > (asynchronous) in the past but it was a single
> master
> > relationship not multi-master.
> >
> > I'm leaning towards a standby database setup
> because
> > my experience with advanced replication is less
> than
> > favorable if/when transactions get out of sync.
> Also,
> > one of the tables contains a LONG RAW. This column
> may
> > go away or may be converted to a CLOB in the very
> near
> > future but still needs to be kept in consideration
> > when selecting a solution.
> >
> > The platform is Sun (SunOS 5.7) with 8.1.6. The
> > secondary machine and database will most likely be
> > located in another state. The database is small
> right
> > now (~10Gb) and will continue to grow, but not too
> > fast.
> >
> > What are your opinions?
> > Is there an obvious choice between the two
> > alternatives?
> > Is there another alternative that I should be
> > considering?
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Jeremiah Wilton
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

list stats?

[Thater, William]

OK, oh great list god, do we have the stats for who posts and what the top subjects 
are?

--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc.[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.
~~
>From C:\*.* to shining C:\*.*

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Bad SQL.....

[Regina Harter]

I think it's just Friday.  You need to rewrite your statement to read 
something like this:

UPDATE AVAILABLE_POWER SET available_power_driver_terminated = 'Y'
where available_power.driver_id in (select manpowerprofile.mpp_id
from manpowerprofile where manpowerprofile.mpp_terminationdt <> 
to_date('31-DEC-2049','DD-MON-') )

At 09:01 AM 5/25/01 -0800, you wrote:
>I am trying to write an update statement but seem to be having problems.
>Below is my statement and the error in SQL*Plus.
>
>
>   1  UPDATE AVAILABLE_POWER SET available_power.driver_terminated = 'Y'
>   2WHERE available_power.driver_id = manpowerprofile.mpp_id
>   3*and manpowerprofile.mpp_terminationdt <>
>TO_DATE('31-DEC-2049','DD-MON-')
>SQL> /
>and manpowerprofile.mpp_terminationdt <>
>TO_DATE('31-DEC-2049','DD-MON-')
>*
>ERROR at line 3:
>ORA-00904: invalid column name
>
>
>I know that manpowerprofile.mpp_terminationdt is a valid table column.  Do I
>need to do some type of join on these two tables?  Or is it just Friday and
>I should give up and go have a cold beer!!:o)  Any advice would be
>appreciated.
>
>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).

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

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

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

RE: OT: Winnie quote

[Thater, William]

On Fri, 25 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon:

->
->but he's ORANGE!!!  At least Eeyore is a decent shade of blue :)

Sorry.
--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc.[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.
~~
The wise person writes bomb-proof code.

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

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

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

Memories but not forgotten.

[Garner, John (NESL-IT)]

Leaving the lazy DBA list is a shame after a couple of years lurking...

The pastures are look greener on the fatcity side of the fence...  

I think I'll stretch my legs :o)


E mail Disclaimer

You agree that you have read and understood this disclaimer and you agree to be bound 
by its terms.

The information contained in this e-mail and any files transmitted with
it (if any) are confidential and intended for the addressee only.  If you have
received this e-mail in error please notify the originator or telephone
0191 210 2060 or e-mail [EMAIL PROTECTED]  

This e-mail and any attachments have been scanned for certain 
viruses prior to sending but neither Northern Electric plc nor any of the companies in 
the Northern Electric group of companies from whom this e-mail originates shall be 
liable for any losses as a result of any viruses being passed on.

No warranty of any kind is given in respect of any information contained in this 
e-mail and you should be aware that that it might be incomplete, out of date or 
incorrect. It is therefore essential that you verify all such information with us 
before placing any reliance upon it.

Northern Electric plc
Carliol House
Market Street
Newcastle-upon-Tyne
NE1 6NE
Registered in England and Wales: Number 2366942



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Garner, John (NESL-IT)
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: backspace in Oracle.

[Deshpande, Kirti]

Try the command
stty erase  
to set 'erase' to the appropriate key sequence for your term type before
starting sqlplus session (or use SQL>!stty erase  from within
SQL).

HTH,

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

> -Original Message-
> From: Ron Rogers [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, May 25, 2001 12:01 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  backspace in Oracle.
> 
> List,
>  I have created a test server using Linux 7.1 and Oracle 8.1.7.3 and it
> works great. The major problem I am having is "I am NOT a typist" and make
> errors at the SQL prompt. What do I set or define in the glogin to allow
> backspace to work as a backspace in Oracle? It has been a while since I
> had the privilege of UNIX ( in any flavor)
>  Any info would be appreciated.
> Thanks,
> ROR mª¿ªm
> 
> -- 
> 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: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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

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

RE: Standby vs. Adv. Replication (Multi-master)

[Jeremiah Wilton]

Things that can weight the decision on the side of standby:
- Frequent DDL changes - requires outage for MM rep.
- Very high rate of DML - MM rep may fall behind.
- High latency network - MM rep may fall behind
- Allowable failover time is over 10 minutes.
- Losing the last few minutes of transactions is OK.
- It is economically acceptable to have a whole system sitting idle.

Things that can weight the decision on the side of MM replication:
- Both systems must be usable.
- low rate of DDL changes
- low rate of DML
- good network between systems
- No committed data loss is acceptable
- Failover must be instant

There are other solutions that you might find worth investigation:

- Standby + geomirring of logs & controlfiles - (0 data loss standby)
- Shared disk cluster - OPS or HA configuration (DB is not redundant, but host is)
- Quest SharePlex (log-based replication a la Sybase)
- Redundancy within a single host (hardware components, RAID mirroring,
  listener, logfile, application redundancy)
- Just a good fast enterprise backup & restore

You get to do the calculation - based on your businsess's needs, which gets the
correct amount of availability with the fewest dollars in the most *likely*
disaster scenarios?

So, I've ditched LazyDBA as well.  I guess I just never know everyone was over
here.  There are a lot less questions here where the answer is RTFM.  All those
people over there wanting to cheat on their OCP class homework were starting to
get on my nerves.  This last little hullabaloo was just the last straw.  They
really were a bunch of lazy DBAs.  Too lazy to crack a manual.

Anyone in Seattle want to get together for beers?  I'll drag the other Amazon
DBAs along, if you can stand the sight of a passel of geeks.  Reply to me, not
the list.

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

On Fri, 25 May 2001, Jack C. Applewhite wrote:

> We have a Standby database and I love it - especially compared to the
> complexities of  replication!
>
> Once you set up the standby database, automate the mechanism for
> transferring archived redo logs from your production db to the standby,
> applying them, and deleting them once applied, it requires almost no
> intervention.  About the only time I have to fiddle with the standby is
> after I add a datafile to a tablespace on the production db.
>
> We're on 8.1.6 under Win2k and our production db has almost 8 million CLOB
> documents, with about 50,000 added each night.  The standby keeps up nicely.
>
> -Original Message-
>
> I'm looking for feedback on setting up a
> high-availability architecture for our production
> database. In a nutshell, we are a 24-hour shop and I
> need to be able to keep a secondary database
> (failover) in sync with the primary in case the
> primary fails. I have supported advanced replication
> (asynchronous) in the past but it was a single master
> relationship not multi-master.
>
> I'm leaning towards a standby database setup because
> my experience with advanced replication is less than
> favorable if/when transactions get out of sync. Also,
> one of the tables contains a LONG RAW. This column may
> go away or may be converted to a CLOB in the very near
> future but still needs to be kept in consideration
> when selecting a solution.
>
> The platform is Sun (SunOS 5.7) with 8.1.6. The
> secondary machine and database will most likely be
> located in another state. The database is small right
> now (~10Gb) and will continue to grow, but not too
> fast.
>
> What are your opinions?
> Is there an obvious choice between the two
> alternatives?
> Is there another alternative that I should be
> considering?

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

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

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

OT: My bad

[Speaks, Chuck W.]

I didn't mean to reply-all.  That's my bad.  

Chuck Speaks, MCSE
Database Administrator
Lithonia Lighting
770-922-9000  x3450
http://www.lithonia.com


-Original Message-
Sent: Friday, May 25, 2001 12:56 PM
To: '[EMAIL PROTECTED]'


Sounds pretty standard.

Chuck Speaks, MCSE
Database Administrator
Lithonia Lighting
770-922-9000  x3450
http://www.lithonia.com


-Original Message-
Sent: Friday, May 25, 2001 1:08 PM
To: Multiple recipients of list ORACLE-L


We have one little rule that most folks follow
pretty well. 

If it's not about Oracle or oracle proper, we usually
place an "OFFTOPIC" or "OT" in the first position of
the subject line. 

|| -Original Message-
|| From: Speaks, Chuck W. [mailto:[EMAIL PROTECTED]]
|| Sent: Friday, May 25, 2001 12:21 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: New member
|| 
|| 
|| Sounds great.  I am a Lazy DBA refugee and I must say that I 
|| like the tone
|| and banter on this list a lot better.  I'll be talking to 
|| you guys soon.
|| It's good to see familiar names like Chris Spence and Steve 
|| Adams, for they
|| are outlaws on other sites.  REAL TROUBLEMAKERS!
|| 
|| Chuck Speaks, MCSE
|| Database Administrator
|| Lithonia Lighting
|| 770-922-9000  x3450
|| http://www.lithonia.com
|| 
|| 
|| -Original Message-
|| Sent: Friday, May 25, 2001 11:43 AM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Welcome, Chuck. 
|| 
|| Welcome to a Land of Microsoft Zealots, Bigots, And Agnostics. 
|| 
|| Welcome to a List where politics and recipes are posted with
|| equal fervor as SQL Tuning tips. 
|| 
|| The water's fine!
|| 
|| || -Original Message-
|| || From: Speaks, Chuck W. [mailto:[EMAIL PROTECTED]]
|| || Sent: Friday, May 25, 2001 11:07 AM
|| || To: Multiple recipients of list ORACLE-L
|| || Subject: New member
|| || 
|| || 
|| || Hello,
|| || 
|| || Just wanted to introduce myself before posting to the list.  
|| || I look forward
|| || to interacting with you guys/ladies on the list.  Have a 
|| || great Friday!
|| || 
|| || Chuck Speaks, MCSE
|| || Database Administrator
|| || Lithonia Lighting
|| || 770-922-9000  x3450
|| || http://www.lithonia.com
|| || 
|| || -- 
|| || Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| || -- 
|| || Author: Speaks, Chuck W.
|| ||   INET: [EMAIL PROTECTED]
|| || 
|| || Fat City Network Services-- (858) 538-5051  FAX: 
|| (858) 538-5051
|| || San Diego, California-- Public Internet access / 
|| || Mailing Lists
|| || 
|| 
|| || To REMOVE yourself from this mailing list, send an E-Mail message
|| || to: [EMAIL PROTECTED] (note EXACT spelling of 
|| 'ListGuru') and in
|| || the message BODY, include a line containing: UNSUB ORACLE-L
|| || (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: Mohan, Ross
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Speaks, Chuck W.
||   INET: [EMAIL PROTECTED]
|| 
|| Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
|| San Diego, California-- Public Internet access / 
|| Mailing Lists
|| 
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (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: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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

RE: Impugning LazyDBA

[Mohan, Ross]

Well put, and "Amen". 
 
Let's leave others alone. Especially if they are not 
able to properly defend themselves. It would be like 
throwing Christians to the lions.
 
And that's not sporting. 
 
 

-Original Message-
Sent: Friday, May 25, 2001 1:33 PM
To: Multiple recipients of list ORACLE-L



Disclaimer: I have no affiliation with LazyDba or the owner of the LazyDba
mailing list, and have not subscribed to that list.

My personal opinion, for what it's worth: 
I don't think that this list is an appropriate place to impugn the motives
of the owner(s), or discuss the inadequacies, of other mailing
lists/personal websites, unless the question is posed to the list, e.g.
"Should I join lazydba?"

In addition, I would think it would be more professional to restrict one's
comments to the technical value of said website or list.

-- 
Jacques R. Kilchoer 
(949) 754-8816 
Quest Software, Inc. 
8001 Irvine Center Drive 
Irvine, California 92618 
U.S.A. 
http://www.quest.com   

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Steve Adam's Removal

[Eric D. Pierce]

removing Steve Adams from any Oracle list would be completely
stupid. what happened on lazydba?
regards,
ep


On 25 May 2001, at 2:16, Robertson Lee - lerobe wrote:

Date sent:  Fri, 25 May 2001 02:16:05 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

> Erm... am I missing something but wasn't the original mail removing Steve
> Adams from the lazydba discussion list and not this one ??


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

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

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