Re: Another Oracle DBA gets The Bullet WAS: Help!: Job Descrip

warmer :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: * Oracle DBA Needed in Phoenix..

On July 6, 2001 10:15 pm, Stephane Faroult wrote: Gregory Conron wrote: On July 6, 2001 05:38 pm, [EMAIL PROTECTED] wrote: snip Just as a matter of information, there are many people on this list from South or South East Asia, as well as Eastern and Central Europe, and possibly from

Re: COMPUTER STATISTICS Threshold

. Same if you specify the # of rows. Greater than half the rows in a table will do a full compute. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: Index Behaviour

is not #10 - it would be much quicker to do a scan of the table instead of looking up all the records in the index then grabbing the corresponding rows from the table. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED

Re:RE: * Oracle DBA Needed in Phoenix..

usually running NT). Oh well, got saltwater in my veins, so I'll stick around here for a while :) Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: temp tablespace is permanent tablespace

temporary tablespace, permanent objects cannot be created, easing your admin/maintenance time. HTH, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: Online backup script..........

Oracle 7.3.0 database size 10GB. Can any body give me the script which will automatically take online backup of my database? BFN, Jaimin. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network

Re: Linux profile - a little offtopic

at /etc/profile - this is the default system-wide user profile (be aware that all changes to this file will affect all non-root users on the system). Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network

Re: temp problem when rebuilding Index

TEMP You need to either partition your table or increase the size of temp. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: temp problem when rebuilding Index

to accomodate the sorting. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: OT RE: 24 x 7 on NT?

engine! ;-) simpsons reference of course, he had an onion tied to his belt, because that was the style of the time /simpsons reference Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City

Re: Griping about auditing (not the Oracle Kind)

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: OT RE: 24 x 7 on NT?

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Heads Up: Virus coming from list - Venkata Apparao

-- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing

Re: OT RE: 24 x 7 on NT?

On June 27, 2001 10:45 am, Thater, William wrote: -business world that their entire infrastructure is a complete and udder pipe dream ^^^ What do gui tools have to do with cows? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron

Re: OT RE: 24 x 7 on NT?

! ;-) simpsons reference ... of course, he had an onion tied to his belt, because that was the style of the time /simpsons reference Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: TRUNCATE IN PL/SQL

for being tardy in my reading (had ~300 messages unread :) Maybe I need less sleep.. Merry Saturday, Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: TRUNCATE IN PL/SQL

On June 21, 2001 10:36 am, Rachel Carmichael wrote: anyone who has delete any table can truncate. isn't it 'drop any table'? Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: * I'm Looking for an Oracle Financials DBA for Miami, Florida..

On June 16, 2001 04:35 am, Jared Still wrote: Many of us consider this a service, especially the way that jobs are at the moment. Amazing the difference a year can make, eh? Cheers, GC (obviously a canuck) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory

Re: Analyze table and locking

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Drop 'NOT NULL' Constraint

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: job offer from SAUDI ARABIA

b*tch if you want. I served for this country and love this country. *GO USA* As long as you don't criticize the church of scientology :) http://slashdot.org/article.pl?sid=01/05/17/0238223mode=nested Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory

Re: Sqlloader

-- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list

RE: Dropping partitions with data versus empty

-- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing

Re: Stephen Andert's article

URL: http://oracle.oreilly.com/news/oraclesqlload_0401.html. Very nice review - great representation of efficiency in increasing BIND and ROWS parameters. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City

Re: How does dropping a partition affect the rest of the table?

-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: stupid DBA

other side of the bed :) although, as best noted in ASR, all hardware sucks, all software sucks. It's just different degrees of suckage. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Re: How does dropping a partition affect the rest of the table?

On Fri, 13 Apr 2001, Gregory Conron wrote: unless a user is running a query or transaction against the data in the partition (the query/transaction will fail). d'oh! must correct myself - if a user is running a transaction against the data, the alter table drop will fail as it will not be able

Re: Ora Apps Loggin In Issue

, working version. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Conversion of man (unix) into Txt file

On Sun, 18 Mar 2001, chandan wrote: Hi All, Does anyone know how to convert unix MAN into a text file ? Are you looking for 'man ls ls.txt'? Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat

Re: Oracle DBA evolution path - please share your opinion

off @later Short, simple, and efficient. :) Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: sequence generator

sequence numbers needed. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Interesting bug in rename

is returned, and neither the table nor the user can be dropped. This is rather unfortunate, as rename is a very convenient command. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: Attention List Members

emons possessed by Demons" // *Cause: Improper offering to the gods // *Action: Fire. And plenty of it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Re: SQL Text

against v$session will give you the sql for any current user. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: On-Call - terms, conidtions and perks!

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --

RE: (Win2K vs NT4) / RE: OT RE: Async I/O on Windows

On Tue, 06 Feb 2001, Jeffery Stevenson wrote: Enough monkeys, enough typewriters and enough time can get you Shakespeare. 8 monkeys, 5 minutes - Win98 source code. Cheers, GC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gregory Conron INET: [EMAIL PROTECTED