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?
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
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 IOU
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 r
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 rum
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 l
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
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:5
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 statist
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]
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 wh
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
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
c
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:
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 transac
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-org
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 acc
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
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
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 of
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
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 Ste
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
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
-
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 ti
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 t
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
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
membe
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
--
P
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
--
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
Dat
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
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
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 o
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 pre
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
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 happ
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 @#$$^^@
>
>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: Fri
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 versio
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, 20
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: Burto
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 tim
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
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 defin
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
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.
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
-Orig
And perhaps apply for a job as Corporate Philosopher?
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
"Thater,
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
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
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,
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.
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
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
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
> s
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 -0
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 p
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
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
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, M
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 use
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
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 rewrit
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
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: back
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 remo
>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, ne
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://w
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
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:
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
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
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
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 g
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
confirmatio
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 IDEN
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
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 "S
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.
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 d
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
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 Certifiab
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. App
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 Oracl
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 serv
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, J
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
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 P
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 anoth
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 becaus
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
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
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]
~~~
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
Yo
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
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 transact
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 Adm
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 ORAC
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 PROTECT
1 - 100 of 204 matches
Mail list logo