RE: Async I/O on Sun Solaris

You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Californ

RE: Griping about auditing (not the Oracle Kind)

ical). So, any similar horror stories? Jay Miller Sr. Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public I

RE: Griping about auditing (not the Oracle Kind)

ORACLE-L > > > > Hi, > > Been there recently > > We had change management here breathing down our necks at one point. They > wanted everything documented and approved. I flooded them with change > request forms (even for changing a users password

RE: Griping about auditing (not the Oracle Kind)

that not only did I do such things > whenever I thought them necessary but that we didn't have a non-DBA review > everything I did after an Oracle upgrade to ensure I didn't install any > other software. > Fortunately I managed to convince them that yes, I reall

RE: Good Beginner Oracle book recommendations:

'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 -- Autho

RE: Griping about auditing (not the Oracle Kind)

sage- Sent: Thursday, June 28, 2001 7:52 PM To: Multiple recipients of list ORACLE-L On June 28, 2001 11:51 am, Miller, Jay wrote: > Yep, I've dealt with incredibly incompetent consultants (Because of > our new division of responsibilties, all programming must come from > the developm

RE: Gaping holes found in Oracle 8i (patch 1654631 info)

_ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Netwo

RE: Client Connection-SQLNET ?/? ODBC.

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

A danger in cloning databases

me about the problem, I first heard about it from a developer). Sigh, learn something new every day. Hope someone out there benefits from my mistake. Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Serv

RE: $ORACLE_HOME/bin/sqlload or $ORACLE_HOME/bin/sqlldr

ling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

RE: OT - interviewing your superior(fun question)

spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

RE: A danger in cloning databases

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

RE: can i place online redologs with oracle engine ?

containing: UNSUB ORACLE-L (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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services

RE: DB Backup Question

ou may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Pu

RE: Listener Security !!

tp://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this

RE: how to run explain plan on SP???

he message BODY, include a line containing: UNSUB ORACLE-L (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: Miller, Jay INET: [EMAIL PROTE

RE: ERROR IN INSTALING PATCH 8.1.6.3.0

e 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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

Tuning question - Why did this index help so much?

itional 50% efficiency come from? What am I missing? I'm glad it worked so well, but would like to understand why... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: both dbms_stats & dbms_utility are gathering stats on sys obj

ote EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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

RE: Tuning question - Why did this index help so much?

t the index was small enough to stay cached in the SGA? >From: "Miller, Jay" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Tuning question - Why did this index help so much? >Date: Wed

RE: re-archiving a redo log file

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

RE: Tuning question - Why did this index help so much?

recipients of list ORACLE-L it's possible that the index was small enough to stay cached in the SGA? >From: "Miller, Jay" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Tuning quest

RE: deletion of data from a large table

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

RE: deletion of data from a large table

ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 offi

RE: completely off-topic question...

d Mars", "Green Mars", "Blue Mars" - an excellent description of what problems a new society might run into on Mars) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (8

RE: Missing Table

amage sustained as a result of software viruses and advise you carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (8

RE: completely off-topic question...

hey'll make you talk to me :) Besides, I agree with you about Asimov -- that should count for something Rachel >From: "Miller, Jay" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: co

RE: Optimizer Mode......how to choose the right one?

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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Di

RE: database disaster recovery

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

Lock Manager in Enterprise Manager 2.1?

t now part of a different app? TIA, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: Copy Oracle's binary.

Thank you very much. Thanh-truc Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet ac

RE: Better Way Of DeFragmentation

.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat 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: Better Way Of DeFragmentation

other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Cal

RE: 2nd DBA or ?

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

RE: Better Way Of DeFragmentation

, and move the datafiles from the cold backup that contained the appropriate tablespaces. I don't think that that would work. "Miller, Jay" <[EMAIL PROTECTED]> Sent by: cc:

RE: 2nd DBA or ?

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

RE: Design Issue - Quick response appreciated

mber generation but it was failing. Any ideas or suggestions are much appreciated. Thanks, Rao Maheswara Rao, Oracle DBA SunGard Securities -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services

RE: Design Issue - Quick response appreciated

as or suggestions are much appreciated. Thanks, Rao Maheswara Rao, Oracle DBA SunGard Securities -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Cali

RE: 2nd DBA or ?

ECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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://

RE: ORACLE VS. SYBASE

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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-505

RE: When optimizer reevaluate SQL statement

X: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and

RE: Dropping table is not completing

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

getting password request on connect internal

internal Password: I've already gone through every step in the Oracle Note 69642.1 (Checklist for Resolving CONNECT INTERNAL PASSWORD Issues) without any results. Any ideas? Thanks, Jay Miller x48355 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay

RE: getting password request on connect internal - more info

any results. Any ideas? Thanks, Jay Miller x48355 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: getting password request on connect internal

ks, Jay Miller x48355 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Pu

RE: getting password request on connect internal

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

RE: SOLARIS VERSION

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

Concealing SQL Loader password from ps -ef

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

Unable to rebuild database from hot backup

ow I'm really concerned that my hot backup is invalid for some reason. Does anyone have any suggestions for what else I can look at? TIA, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (

RE: Unable to rebuild database from hot backup

rror. Now I'm really concerned that my hot backup is invalid for some reason. Does anyone have any suggestions for what else I can look at? TIA, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Se

RE: good workaround for a ORA-2016?

ormation (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Serv

RE: Backups

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

A really stupid question

How can I access the Oracle-L archives? There's something I remember reading a few months ago that I want to look up. Embarassedly yours, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Ser

RE: help!! smon

ke subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web ho

Advice needed on move to Sun 15K (losing spindles)

ne can either a) tell me I'm worrying for nothing b) recommend a better way to stripe/distribute my files c) provide references or experience to show this is a bad idea I'd really appreciate it. Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.co

RE: Advice needed on move to Sun 15K (losing spindles)

lity to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning to retain this functionality. Jared "Miller, Jay" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/09/2002 11:53 AM Please respond to ORACLE-L

RE: Advice needed on move to Sun 15K (losing spindles)

thing else you will lose is the ability to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning to retain this functionality. Jared "Miller, Jay" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/09/2002 11:53 AM

RE: Advice needed on move to Sun 15K (losing spindles)

ases. You have this ability now, but will lose it if you consolidate without separate ORACLE_HOME's. Something else you will lose is the ability to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning to retain this functionali

RE: Advice needed on move to Sun 15K (losing spindles)

to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning to retain this functionality. Jared "Miller, Jay" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/09/2002 11:53 AM Please respond to ORACLE-L

RE:

icial ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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: Creating new user

ru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Miller

RE:

re specifically multiple tables from a user in 1 go. I need to delete 50+ tables/objects without deleting them 1 by 1. Thanks Clint -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 85

RE: Advice needed on move to Sun 15K (losing spindles)

ems in various databases. You have this ability now, but will lose it if you consolidate without separate ORACLE_HOME's. Something else you will lose is the ability to reboot the server if needed for a single database. Since you may be moving to a 15k, investigate server partitioning t

RE: Advice needed on move to Sun 15K (losing spindles)

ru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Miller, J

RE: admin_restrictions_listener

: UNSUB ORACLE-L (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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: admin_restrictions_listener

vious job. He copied the listener.ora file to another server, then ran 'lsnrctl stop' before modifying the file for the new server. Guess what happened? Jared "Miller, Jay" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/17/2002 11:29 AM Please respond to ORACLE-L

RE: Adhoc queries and limiting the amount of records queried...

erver, so SQL Server ideas would also be appreciated. Many thanks!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: Data guard

nformation (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hostin

Auditing grant and revoke privileges

t restarted the database since changing the init.ora parameter (untrue). Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Help in Training on DBA

d in the message BODY, include a line containing: UNSUB ORACLE-L (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: Miller, Jay INE

RE: Database design, replacing null by a default value

XACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.ora

RE: Defragmentation of tablespace

ved 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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Ca

RE: LOCALLY MANAGED TABLESPACE

experience what gain after changing to locally managed tablespace? Thx -Seema -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Cal

RE: Unkillable Background process "SHUTDOWN ABORT LEAVES UNKILLAB

containing: UNSUB ORACLE-L (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: Miller, Jay INET: [EMAIL

CLOB inserts

0 0.4 db file parallel write170 0 0 0 0.3 control file parallel write 161 0 0 0 0.3 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat

RE: System Tablespace and Autoextend

ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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: Data Purging Strategy

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

RE: Can any one tell me how can i read parameter info from RDF(Re

Can any one tell me how can i read parameter info from RDF(Reports definition file) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Calif

RE: Clone Production Server to Stand by Server on 8.1.7 on Win 2k

e to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 OR

RE: Data Purging Strategy

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

RE: Destination address unreachable

e and stupidity all in the same package. How efficient of you.   -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web ho

RE: System Tablespace and Autoextend

, include a line containing: UNSUB ORACLE-L (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: Miller, Jay INET: [EMAIL PROTECTED] Fat Cit

10046 Level 8 Trace file disappeared

s to what might have happened to my file? Thanks, Jay Miller x48355 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Data specs of columns

'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: M

Do user processes apply against shmmax limit?

minfo_semmns=2000 set semsys:seminfo_semmsl=1000 set semsys:seminfo_semmnu=500 set semsys:seminfo_semume=150 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Do user processes apply against shmmax limit?

ft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** >-Original Message- >From: Miller, Jay [mailto:[EMAIL P

ORA-1653: unable to extend table - Why?

y isn't it making use of the existing blocks on the freelist? Oracle 8.1.7.2 Solaris 2.6 PCTFREE = 10 PCTUSED = 75 Block Size = 4K Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 85

RE: ORA-1653: unable to extend table - Why?

Solaris 2.6 PCTFREE = 10 PCTUSED = 75 Block Size = 4K Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and

RE: ORA-1653: unable to extend table - Why?

? If so the insert inserts after the highwater mark. The highwater mark is not reinitialized after deletes. So maybe that's why the insert failed. --- "Miller, Jay" <[EMAIL PROTECTED]> a écrit : > Okay, I can't figure this one out. Earlier this > week I got

RE: ORA-1653: unable to extend table - Why?

ES: > > > > num_freelist_blocks: 2266966 > > avg_space_freelist_blocks: 3895 > > > > Unless I'm misreading this I should have had over 8Gig available > for > > inserts. > > > > We tried the insert again and got the same error so

RE: ORA-1653: unable to extend table - Why?

following stats in > DBA_TABLES: > > > > num_freelist_blocks: 2266966 > > avg_space_freelist_blocks: 3895 > > > > Unless I'm misreading this I should have had over 8Gig available > for > > inserts. > > > > We tried the insert again and g

RE: ORA-1653: unable to extend table - Why?

pace_freelist_blocks: 3895 > > > > Unless I'm misreading this I should have had over 8Gig available > for > > inserts. > > > > We tried the insert again and got the same error so I added a > > datafile and > > it went through (using about 40Meg of s

RE: ORA-1653: unable to extend table - Why?

ce_freelist_blocks: 3895 > > > > Unless I'm misreading this I should have had over 8Gig available > for > > inserts. > > > > We tried the insert again and got the same error so I added a > > datafile and > > it went through (using about 40Meg of space in

RE: ORA-1653: unable to extend table - Why?

pace_freelist_blocks: 3895 > > > > Unless I'm misreading this I should have had over 8Gig available > for > > inserts. > > > > We tried the insert again and got the same error so I added a > > datafile and > > it went through (using about 40Meg of s

RE: ORA-1653: unable to extend table - Why?

ce_freelist_blocks: 3895 > > > > Unless I'm misreading this I should have had over 8Gig available > for > > inserts. > > > > We tried the insert again and got the same error so I added a > > datafile and > > it went through (using about 40Meg of space in the

RE: ORA-1653: unable to extend table - Why?

all since he just >>>>deleted >>>>2 million rows so there are plenty of space within the segment >>>>itself. >>>>Those free blocks should be used, unless he is doing a direct path >>>>insert >>>>which will only use space abo

RE: ORA-1653: unable to extend table - Why?

> > > > > > > Okay, I can't figure this one out. Earlier this week I got an > > > ORA-1653: > > > unable to extend table on a really big table. However this was > > just >

RE: ORA-1653: unable to extend table - Why?

ng > > 30,000. > > > > After reanalyzing the table I saw the following stats in > DBA_TABLES: > > > > num_freelist_blocks: 2266966 > > avg_space_freelist_blocks: 3895 > > > > Unless I'm misreading this I should have had over 8Gig available > f

RE: ORA-1653: unable to extend table - Why?

3895 > > > > Unless I'm misreading this I should have had over 8Gig available > for > > inserts. > > > > We tried the insert again and got the same error so I added a > > datafile and > > it went through (using about 40Meg of space in the new datafile). >

RE: ORA-1653: unable to extend table - Why?

t; > > > num_freelist_blocks: 2266966 > > avg_space_freelist_blocks: 3895 > > > > Unless I'm misreading this I should have had over 8Gig available > for > > inserts. > > > > We tried the insert again and got the same error so I added a > > datafile

<    1   2   3   >