RE: Migration to 9.2.0.3.0 (64 Bit) on Solaris 8 issues

2003-06-20 Thread Stephen Lee
ed memory > (\"%s\",\"%s\",\"%s\",\"%s\")" > // *Cause: More shared memory is needed than was allocated > in the shared pool. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTEC

RE: TEXT FILE

2003-06-19 Thread Stephen Lee
ell script. And we all want to be as cool as possible. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Cali

RE: copy a datafile to a raw device

2003-06-19 Thread Stephen Lee
t; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: copy a datafile to a raw device

2003-06-19 Thread Stephen Lee
that laying next to me? Oh my God is that a marriage license?!'; Just in case you developers out there have any creative urges. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: OEM question

2003-06-19 Thread Stephen Lee
worked perfectly adequately. bearing in mind that DBMS_JOB is - I'm pretty sure - designed by a bunch of sadists who have it in for Admin guys this is not a huge recommendation :( -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROT

RE: copy a datafile to a raw device

2003-06-19 Thread Stephen Lee
his merde?" (Pardon my French.) (You have to wonder if there is an error message *something* like this buried down in the Oracle kernel by some irreverent programmer.) > -Original Message- > From: Stephen Lee > Sent: Thursday, June 19, 2003 3:27 PM > To: Multiple recipien

RE: copy a datafile to a raw device

2003-06-19 Thread Stephen Lee
REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also sen

RE: Re: Passwords and authentication

2003-06-19 Thread Stephen Lee
- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list,

RE: MySQL in the future?

2003-06-19 Thread Stephen Lee
he official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Partitions of table read only

2003-06-19 Thread Stephen Lee
ould happen in an LMT when it was read-only. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web ho

RE: Oracle releases by the different platforms...

2003-06-19 Thread Stephen Lee
ed with Windows Say it aint so!!! I'm thinking we really need to migrate from AIX to Linux! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com S

Replication book

2003-06-18 Thread Stephen Lee
With the talk about replication lately, I thought I would see what might be out there in book land and came across this. It is currently a vapor book. http://www.dba-oracle.com/bp/bp_book4_replication.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee

RE: asking your opinion

2003-06-17 Thread Stephen Lee
As I mentioned earlier, the application > is sun one portal, content based. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.

RE: asking your opinion

2003-06-17 Thread Stephen Lee
class registration, staff pages do other stuff. > > Joan > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: Compare Schema with data

2003-06-17 Thread Stephen Lee
I think DB Artisan Change Manager will do it. > -Original Message- > Is any body know any tools for comparing two schema for only > data comparison > & create script for the result -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Le

RE: asking your opinion

2003-06-17 Thread Stephen Lee
ll? > > I am new to this area, I would appreciate any input informantion. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: recreating a create database file

2003-06-17 Thread Stephen Lee
spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like

RE: World premier performance of the BAARF party logo

2003-06-16 Thread Stephen Lee
You forgot Traci Lords. > -Original Message- > > A movie with Julia Roberts or Meg Ryan is what I had in mind. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-5

RE: World premier performance of the BAARF party logo

2003-06-16 Thread Stephen Lee
f an app, but good BCHR. -Original Message- > Well, the way memory is growing, we'll soon have > in-memory databases -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 htt

RE: Want to BAARF - Recommendations for 10 36G Drive config

2003-06-13 Thread Stephen Lee
ACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMO

RE: Fragmentation ?

2003-06-13 Thread Stephen Lee
n "one of these days" -- never got written. (For non-USA dwellers, Roach Motel is a trap for roaches. It has a sticky floor, and the sales motto is "Roaches check in. They don't check out.") -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Le

RE: Rebuilding MLOG tables

2003-06-13 Thread Stephen Lee
efresh group > on > > the client) must be created, eh? > > > > > -Original Message- > > > > > > The safest and recommended way is to queisce the replication > > > master group by > > > > > > dbms_repcat.suspend_master

RE: Rebuilding MLOG tables

2003-06-13 Thread Stephen Lee
icial ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To R

RE: db file sequential read [WAS:wait event puzzler]

2003-06-13 Thread Stephen Lee
, which is thought of and is the current > Decision. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Ma

RE: Rebuilding MLOG tables

2003-06-13 Thread Stephen Lee
suspend_master_activity('GroupName'); > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- M

RE: Rebuilding MLOG tables

2003-06-12 Thread Stephen Lee
rmless. I see someone > else has given a response with the same ultimate moral, but > I'll still post, to point out the lock behavior. > > > > > -Original Message- > > From: Stephen Lee [mailto:[EMAIL PROTECTED] > > Sent: Thursday, June 12, 2003

RE: Rebuilding MLOG tables

2003-06-12 Thread Stephen Lee
ps. > > Arup Nanda > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Rebuilding MLOG tables

2003-06-12 Thread Stephen Lee
table mlog$_xyz move tablespace back_here; (optional, I suppose) rollback; (release the lock) Does anyone know of any issues, pitfalls, invitation for disaster, etc. with this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat Ci

RE: Oracle Names

2003-06-12 Thread Stephen Lee
e official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -

RE: db file sequential read [WAS:wait event puzzler]

2003-06-12 Thread Stephen Lee
LE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - T

RE: Sun to Linux on Dell

2003-06-09 Thread Stephen Lee
r" Really I have felt > this way for a > long time. Maybe the time will come when I see it as a great > idea, but > right now it just doesn't add up for me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat C

RE: Sun to Linux on Dell

2003-06-09 Thread Stephen Lee
kind of support -- both vendor and third party -- each platform has. -Original Message- They are contemplating moving it to Linux and a very high end Dell system, perhaps 4-8 CPU, etc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTE

RE: book for ocp 8i performance tuning

2003-06-09 Thread Stephen Lee
the guys with full beards (not full bears, as I wrote earlier). - Full beers? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fat

RE: Oracle Service on Win2k

2003-06-06 Thread Stephen Lee
Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --

RE: 9.2.0.3 online index builds resolved (we hope)

2003-06-06 Thread Stephen Lee
(less than million rows or so), would you consider IOTs ?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: 9.2.0.3 online index builds resolved (we hope)

2003-06-06 Thread Stephen Lee
e turnover of data in 15 minutes' ...?? Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- M

RE: 9.2.0.3 online index builds resolved (we hope)

2003-06-06 Thread Stephen Lee
B(feeling the air over my head, but not grabbing anything.) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Shite of the day

2003-06-06 Thread Stephen Lee
; - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a li

RE: 9.2.0.3 online index builds resolved (we hope)

2003-06-06 Thread Stephen Lee
> The work around is (we hope): > > alter session set db_file_multiblock_read_count=1; > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Stephen Lee > INE

RE: Unix host name change - what happens to db?

2003-06-04 Thread Stephen Lee
orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this ma

9.2.0.3 online index builds resolved (we hope)

2003-06-04 Thread Stephen Lee
ession set db_file_multiblock_read_count=1; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and w

RE: Unix host name change - what happens to db?

2003-06-04 Thread Stephen Lee
decided to change the name of the Sun OS 2.8 host > of my Oracle 8i databases. > > Question: how does this name change affect my Oracle software > installation and my databases? > > Has this happened to any of you? > -- Please see the official ORACLE-L FAQ: http://www

RE: Online index creation on 9.2

2003-05-31 Thread Stephen Lee
nsactional > systems, a variety of waits, mostly library cache related, can occur > at the end of the index rebuild. Many more such problems are > addressed (fixed) in 9.2.0.3 than were in 8.1.7. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen L

RE: Online index creation on 9.2

2003-05-30 Thread Stephen Lee
ondence with v$session_longops phases for the > rebuild? > > Really, the answer to 75% of the questions in this group is "look at > v$session_wait." > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City

Online index creation on 9.2

2003-05-30 Thread Stephen Lee
s and/or incorrectly performing our ritual sacrifice ceremonies? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and

RE: Redo generation rate

2003-05-27 Thread Stephen Lee
e for this but > > I need to give them the redo generation rate > > or redo copy rate in bytes per second. Is there any way I > > can find this out without using Statspack ?? > > > > Thanks and Regards, > > -- Please see the official ORACLE-L FAQ: http://www.o

RE: Re: Sizing - RAC, storage subsystem EMC

2003-05-27 Thread Stephen Lee
foul language. If your application will work with TAF, it has proven to be reliable for us. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: FW: 9000x faster than Oracle?

2003-03-26 Thread Stephen Lee
You don't know how to use the three sea shells? (And if you have seen "Demolition Man", THEN GO RENT IT!) > -Original Message- > > A paperless office is like a paperless bathroom. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author:

RE: sort ip addresses

2003-03-25 Thread Stephen Lee
hope that is OK. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing li

RE: audit_trail=db Overhead ?

2003-03-21 Thread Stephen Lee
dit grant directory; audit grant procedure; audit grant sequence; audit grant table; audit grant type; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatc

RE: HP-UX and IBM ESS

2003-03-20 Thread Stephen Lee
. > -Original Message- > > The problem is we get random data corruptions reported in > different Oracle > data files -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 85

RE: Value of OCP

2003-03-20 Thread Stephen Lee
> -Original Message- > Did you learn anything from the previous crash to prevent it from > happening again? > Yes. Duct tape the power cord to the floor. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat

RE: Ab Initio, Unix Scripting, and Datawarehousing

2003-03-19 Thread Stephen Lee
se see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: determining bytes written to tape

2003-03-19 Thread Stephen Lee
se see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hostin

RE: Questions about constraints

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

RE: 9i - Which Patchset

2003-03-18 Thread Stephen Lee
gt; > patch number, Oracle support usually requires that you be > at the latest > > patch level. > > > > > -Original Message- > > > > > > Any opinions on which patchset of 9.2 is most stable: > > > 9.2.0.1, 9.2.0.2, 9.2.0.3? We're

RE: 9i - Which Patchset

2003-03-18 Thread Stephen Lee
0.1, 9.2.0.2, 9.2.0.3? We're running HP Tru64. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: migration

2003-03-18 Thread Stephen Lee
1452: > "CREATE UNIQUE INDEX "TTIITM009001$IDX1" ON "TTIITM009001" > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: Organizational Challenge - Data Management Team

2003-03-14 Thread Stephen Lee
nd Hell (I'll leave it to you to decide which was which) with a chasm between the two over which no being shall cross. At my current job, it's more of a big free-for-all. Fun! Fun! Fun! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee

RE: Corrected SQL Question...

2003-03-13 Thread Stephen Lee
d an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (lik

RE: Corrected SQL Question...

2003-03-13 Thread Stephen Lee
e possible patterns, which half is the correct half? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hostin

RE: Corrected SQL Question...

2003-03-13 Thread Stephen Lee
see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting servi

RE: [Q] need benchmark info. for ORACLE seerver?

2003-03-13 Thread Stephen Lee
er. > > Thanks. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Space or Memory Leak

2003-03-13 Thread Stephen Lee
or Memory... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services ---

RE: TAR and Linux info

2003-03-12 Thread Stephen . Lee
; recreate the datafile and tablespace. > Thanks to all. > Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: TAR and Linux info

2003-03-12 Thread Stephen Lee
; recreate the datafile and tablespace. > Thanks to all. > Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: advanced replication knowledge resources

2003-03-05 Thread Stephen Lee
t I have bought. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web h

RE: DB_BLOCK_SIZE and Solaris block size

2003-03-04 Thread Stephen Lee
k size on Solaris (7,8,9) ? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web host

RE: Big SGA.......

2003-03-03 Thread Stephen Lee
shop where this situation occurs ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web h

RE: Big SGA.......

2003-03-03 Thread Stephen Lee
cial ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - T

RE: Import Problem

2003-03-03 Thread Stephen Lee
> import, once it has been interrupted? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: shared tnsnames.ora

2003-02-27 Thread Stephen Lee
on to update their tnsnames.ora I've seen all of these methods used. The one I thought worked the best was the push method. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://w

RE: Oracle and SUN config question...

2003-02-27 Thread Stephen Lee
, you will have to pick up the corresponding startup / shutdown script(s) too. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Maili

RE: corrupted block

2003-02-27 Thread Stephen Lee
-- Sunspots. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing l

RE: Dealing with 3rd Party Applications

2003-02-26 Thread Stephen Lee
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and we

RE: Oracle and SUN config question...

2003-02-26 Thread Stephen Lee
place the oratab and oraInst.loc files within a directory that would be self-contained within the $ORACLE_BASE directory tree instead of /var/opt/oracle -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services

RE: corrupted block

2003-02-26 Thread Stephen Lee
o do better with finding it in archived log files than in data files. But that observation is based on a tiny sample of empirical data, so it shouldn't be taken as fact. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City

RE: Basic RMAN question

2003-02-26 Thread Stephen Lee
at have i missed? > Maybe need to export ORACLE_SID=YADAYADA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and

RE: MTS config

2003-02-25 Thread Stephen Lee
rafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mai

RE: corrupted block

2003-02-24 Thread Stephen Lee
ve bet no money. > -Original Message- > > Stephen >RMAN ignored your corrupted block? Ya gotta tell us more man! We're > relying on it to catch everything. Did you have the > MAXCORRUPT parameter > set? > -- Please see the official ORACLE-L FAQ: http://www.orafa

RE: corrupted block

2003-02-24 Thread Stephen Lee
afford to forget the data in the corrupted block > you can use > the event 10231 to skip the corrupted block during table scan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: corrupted block

2003-02-24 Thread Stephen Lee
ble into a new table? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list a

RE: How long to hold onto old Oracle CDs?

2003-02-24 Thread Stephen Lee
You should keep them. You never know when you will decide to get a shotgun and be in need of some targets. > -Original Message- > > Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX > CDs? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Aut

RE: Snapshot Too Old Error on Export !!!

2003-02-21 Thread Stephen Lee
ack, > since the changes > occurring > during the export are not being captured in the export dump. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatc

RE: Oh Where Oh Where Is My Redo Coming From

2003-02-21 Thread Stephen Lee
I suspect a lot > of this redo is > being generated because of some poor design issues. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Califor

RE: Snapshot Too Old Error on Export !!!

2003-02-21 Thread Stephen Lee
e day here where I don't have a lot to do. Hence, the verbose reply.) > -Original Message- > Could somebody help me here, this is very critical to be running > production without proper backups .! > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

RE: direct path read waits

2003-02-20 Thread Stephen Lee
] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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

RE: GRRRRR OWS

2003-02-19 Thread Stephen Lee
A good website for appropriate telephone technique can be found at www.roydmercer.com Roy D. Mercer is such an inspiration that we even have test databases named ROY and MERCER. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED

RE: Programming languages that make DBA's lives easier

2003-02-19 Thread Stephen Lee
Klingon. -Original Message- If you had to choose a programming language in which to write a program or application in which you wished to conceal your intellectual property, which would you use? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Stephen Lee
exec DBMS_SHAWM.PLAY('CHARMER') > -Original Message- > Cool! How'd you get Python to run from a DBMS_JOB? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Stephen Lee
aper to create a monster sized book. Instead, you get lots of information in a book that takes up little shelf space. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://ww

RE: Programming languages that make DBA's lives easier

2003-02-18 Thread Stephen Lee
-- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list

RE: Know 1 database, know them all?

2003-02-18 Thread Stephen Lee
LE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

RE: Upgrading Target Database in RMAN

2003-02-15 Thread Stephen Lee
IL PROTECTED] > > > > > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > > > San Diego, California-- Mailing list and web > hosting services > > > >

RE: Unix research source ???

2003-02-14 Thread Stephen Lee
ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To

RE: Unix research source ???

2003-02-13 Thread Stephen Lee
Linux pretty similar to Unix. What's the > major difference? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: Re[2]: copyright

2003-02-11 Thread Stephen Lee
> > my reply would be "Have a ball!!" > "Dirty deeds. Done dirt cheap!" -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,

RE: Bind variables

2003-02-11 Thread Stephen Lee
27;') too. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Maili

RE: Bind variables

2003-02-10 Thread Stephen Lee
start_trace_in_session(SID, SERIAL#, waits=>false, > binds=>true) > > > > dbms_support.stop_trace_in_session(SID, SERIAL#). > > > > > > > > > -Original Message- > > > > > > It worked well from SQLplus but not from procedure. > > > Did I

RE: Bind variables

2003-02-10 Thread Stephen Lee
l Message- > > It worked well from SQLplus but not from procedure. > Did I miss something ? > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.c

<    1   2   3   4   >