RE: Anyone use Oracle Reports?

2001-02-23 Thread Miller, Jay
-- 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 list

RE: Script for reversing a string?

2001-03-14 Thread Miller, Jay
aw.reverse(utl_raw.cast_to_raw('LOOK'))) from dual / -Mandar -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 3:17 PM To: Multiple recipients of list ORACLE-L Subject: Script for reversing a string? Before I reinvent th

RE: HINTS , how to add correctly

2001-03-16 Thread Miller, Jay
, 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 City

RE: Data into another table

2001-03-21 Thread Miller, Jay
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-- Public

RE: A Basic PL/SQL Question

2001-03-28 Thread Miller, Jay
). -- 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: Locally Managed Tablespace Uniform Extent

2001-04-03 Thread Miller, Jay
ssage 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: Driving table

2001-04-06 Thread Miller, Jay
t 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 Diego,

RE: Example of pl/sql

2001-04-09 Thread Miller, Jay
') 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, Jay INET: [EMAIL

Optimizer theory: Question on access paths for outer joins

2001-04-10 Thread Miller, Jay
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 REMOVE you

RE: Optimizer theory: Question on access paths for outer joins

2001-04-10 Thread Miller, Jay
or refute this? 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

RE: How to get rid off file permanently?

2001-04-12 Thread Miller, Jay
: 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: crontab script problem

2001-04-16 Thread Miller, Jay
e 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 FAX: (85

More Metalink Venting - Cannot catch error 22

2001-04-19 Thread Miller, Jay
in the drop down list. It is not possible to type anything in. If I try to hit Continue it tells me Platform is a required field. Will someone please shoot me? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services

RE: More Metalink Venting - Cannot catch error 22

2001-04-19 Thread Miller, Jay
"Miller, Jay" [EMAIL PROTECTED] on 04/19/2001 12:11:15 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Chaim Katz/Completions/Bombardier) Well, I just went to open a TAR and discovered yet another Metalink c

DBA_FREE_SPACE - Weird problem

2001-04-23 Thread Miller, Jay
(this agrees with OS) DBA_SEGMENTS DBA_EXTENTS - 10752M total size of extents/segments DBA_FREE_SPACE - no entries Oracle 8.1.5.1.0 Solaris 2.6 Any idea what might cause this? Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL

RE: MTSCost based Optimzer

2001-04-24 Thread Miller, Jay
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-- Public Internet access / Mailing

RE: Listener.log

2001-04-24 Thread Miller, Jay
and compressed, there is no more log for the listener. Could anyone help me please ? Thanks. 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

RE: cdump, bdump, udump

2001-04-25 Thread Miller, Jay
') 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, Jay INET: [EMAIL PROTECTED

RE: DBA_FREE_SPACE - Problem gone

2001-04-25 Thread Miller, Jay
size of extents/segments DBA_FREE_SPACE - no entries Oracle 8.1.5.1.0 Solaris 2.6 Any idea what might cause this? 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

RE: Script for reversing a string? - FYI

2001-04-25 Thread Miller, Jay
To: Multiple recipients of list ORACLE-L SQL select reverse('abc') from dual; REV --- cba --- Miller, Jay [EMAIL PROTECTED] wrote: Before I reinvent the wheel, I was wondering if anyone has written a function that will reverse a string? Our auditors are requiring that Oracle passwords

RE: DBA_FREE_SPACE - Problem gone

2001-04-26 Thread Miller, Jay
the data base and restarted ? or problem gone itself without doing anything. A really weired situation. Azhar Miller, Jay JayMiller@TDWaterTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED

RE: OT: Reading the Oracle Tea Leaves

2001-04-30 Thread Miller, Jay
-- 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 list

RE: Help - temp tablespace growing constantly

2001-05-01 Thread Miller, Jay
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: Analyze schema1.mytable from schema2 in a stored procedure

2001-05-10 Thread Miller, Jay
of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller

XA Transaction Support - How to check for?

2001-05-11 Thread Miller, Jay
? Thanks! Oracle v. 8.0.4.3 (but finally got permission to upgrade later this year :). 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

RE: Backup Strategy - Informal Survey

2002-09-20 Thread Miller, Jay
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, California-- Mailing list and web hosting services

ALTER TABLE DROP COLUMNS CONTINUE - how far has it gotten

2002-09-22 Thread Miller, Jay
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 hosting services

RE: ALTER TABLE DROP COLUMNS CONTINUE - how far has it gotten

2002-09-23 Thread Miller, Jay
it has gotten? There is no entry in V$SESSION_LONGOPS. 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: DBA work load

2002-09-25 Thread Miller, Jay
Obviously, not all of those 168 hours are equally intense, requiring a conscious person to be available on-call (you *do* get compensated for being on-call during off-hours, don't you?). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat

RE: 8.1.6 to 8.1.7 upgrade

2002-10-01 Thread Miller, Jay
-- 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 REMOVE yourself from this mailing list, send

RE: DBA work load

2002-10-01 Thread Miller, Jay
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, California-- Mailing list

RE: Backups

2002-10-04 Thread Miller, Jay
-- 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 REMOVE yourself from this mailing list

A really stupid question

2002-10-04 Thread Miller, Jay
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 Services

RE: help!! smon

2002-10-04 Thread Miller, Jay
). -- 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 hosting services

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

2002-10-09 Thread Miller, Jay
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.com -- Author: Miller, Jay INET: [EMAIL

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

2002-10-11 Thread Miller, Jay
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 To: Multiple recipients of list ORACLE-L

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

2002-10-11 Thread Miller, Jay
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 To: Multiple recipients of list

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

2002-10-11 Thread Miller, Jay
, 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 functionality. Jared Miller, Jay [EMAIL

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

2002-10-11 Thread Miller, Jay
, 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 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Advice needed

RE:

2002-10-22 Thread Miller, Jay
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 REMOVE

RE: Creating new user

2002-10-22 Thread Miller, Jay
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

RE:

2002-10-22 Thread Miller, Jay
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-- 858-538-5051 http

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

2002-10-11 Thread Miller, Jay
, 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 functionality. Jared Miller, Jay [EMAIL PROTECTED

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

2002-10-11 Thread Miller, Jay
, 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 City

RE: admin_restrictions_listener

2002-10-17 Thread Miller, Jay
') 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, Jay INET: [EMAIL PROTECTED

RE: admin_restrictions_listener

2002-10-17 Thread Miller, Jay
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 To: Multiple recipients of list ORACLE-L

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

2002-10-29 Thread Miller, Jay
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 list and web hosting

CLOB inserts

2002-11-07 Thread Miller, Jay
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 City

RE: System Tablespace and Autoextend

2002-11-07 Thread Miller, Jay
: 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 REMOVE yourself from this mailing list, send an E

RE: Data Purging Strategy

2002-11-07 Thread Miller, Jay
') 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, Jay INET

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

2002-11-07 Thread Miller, Jay
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, California

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

2002-11-07 Thread Miller, Jay
') 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, Jay INET

RE: Data Purging Strategy

2002-11-07 Thread Miller, Jay
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 http://www.fatcity.com San

RE: Destination address unreachable

2002-11-12 Thread Miller, Jay
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 hosting

RE: System Tablespace and Autoextend

2002-11-13 Thread Miller, Jay
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, California-- Mailing

10046 Level 8 Trace file disappeared

2002-11-14 Thread Miller, Jay
? 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-- Mailing list and web hosting services

RE: Data specs of columns

2002-11-15 Thread Miller, Jay
of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay

RE: STATSPACK space requirement feature on 8i (FYI)

2002-07-22 Thread Miller, Jay
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: Rant-Rant

2002-07-22 Thread Miller, Jay
://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

Recompiling blocked package - locating blocking session

2002-07-23 Thread Miller, Jay
the random searching next time? 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: Rant-Rant

2002-07-23 Thread Miller, Jay
, July 22, 2002 5:25 PM To: Multiple recipients of list ORACLE-L How about an ENTJ as a DBA and System Admin... I'm loads of fun with a bunch of touchy feely type SP's here at the college I work for ;-) Joe On Mon, 22 Jul 2002, Miller, Jay wrote: FYI: SJs make up about 40% of the population

Had to get this off my chest

2002-07-23 Thread Miller, 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: Rant-Rant

2002-07-23 Thread Miller, Jay
make a good nun (Robert, did you see my test results?) --- Miller, Jay [EMAIL PROTECTED] wrote: FYI: SJs make up about 40% of the population (app. 10% for each sub-division). Jay Miller infp (yeah, I know, what's an infp doing in a technical job... :) -Original Message- Sent

RE: How to notify the password expiration in oracle using email?

2002-07-23 Thread Miller, Jay
') 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, Jay INET: [EMAIL

RE: Had to get this off my chest

2002-07-23 Thread Miller, Jay
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-- Public

RE: How to notify the password expiration in oracle using email?

2002-07-23 Thread Miller, Jay
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 City Network

RE: Bind Variables in VB

2002-07-24 Thread Miller, Jay
of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller

RE: Recompiling blocked package - locating blocking session

2002-07-24 Thread Miller, Jay
(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: OEM changes

2002-07-24 Thread Miller, Jay
') 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, Jay INET: [EMAIL

RE: ONLINE index creation in 8.1.7.2

2002-07-29 Thread Miller, Jay
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 City Network

RE: upgrade 8.1.6.2 to 8.1.7.3 or 8.1.7.4

2002-08-30 Thread Miller, Jay
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-- Public Internet access

PCTUSED - when is block added to freelist?

2002-09-03 Thread Miller, Jay
. Anyway, why would a lower PCTUSED reduce processing costs during a DELETE but a higher PCTUSED wouldn't increase processing costs during a DELETE. That makes no sense. I'm befuddled. TIA, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET

RE: PCTUSED - when is block added to freelist?

2002-09-04 Thread Miller, Jay
or actions trigger Oracle to put a block back on the freelist after changing PCTUSED to a higher value? Is that correct Jay? Jared On Tuesday 03 September 2002 15:38, Miller, Jay wrote: I have one huge table (takes up about 30% of the total database storage) which has a monthly batch deletion of old

RE: automatic segment space management

2002-09-04 Thread Miller, Jay
-- 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 list

ALTER TABLE MOVE command causes table to grow

2002-09-05 Thread Miller, Jay
are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 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 FAX: (858) 538-5051 San Diego, California

RE: PCTUSED - when is block added to freelist?

2002-09-05 Thread Miller, Jay
at the head of the chain. Rick Miller, Jay JayMiller@TDWater To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED

RE: ALTER TABLE MOVE command causes table to grow

2002-09-05 Thread Miller, Jay
was from an extent size of 4 meg to one of 25 meg. Both are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat

RE: ALTER TABLE MOVE command causes table to grow

2002-09-05 Thread Miller, Jay
an extent size of 4 meg to one of 25 meg. Both are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 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 FAX

RE: ALTER TABLE MOVE command causes table to grow

2002-09-05 Thread Miller, Jay
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 REMOVE

RE: ALTER TABLE MOVE command causes table to grow

2002-09-06 Thread Miller, Jay
of 4 meg to one of 25 meg. Both are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services

RE: ALTER TABLE MOVE command causes table to grow

2002-09-09 Thread Miller, Jay
://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

Recreating database from hot backup but only 1 tablespace - Urgen

2002-09-09 Thread Miller, Jay
-- 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 list

RE: Recreating database from hot backup but only 1 tablespace - U

2002-09-09 Thread Miller, Jay
are welcome. 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: ALTER TABLE MOVE command causes table to grow

2002-09-10 Thread Miller, Jay
-- 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 list

RE: ALTER TABLE MOVE command causes table to grow

2002-09-11 Thread Miller, Jay
tablespaces. Oracle 8.1.7.2 Solaris 2.6 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Recreating database from hot backup but only 1 tablespace - U

2002-09-17 Thread Miller, Jay
: 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 REMOVE yourself

RE: Consulting Position Available-Oracle DBA/Developer/NYC

2002-09-19 Thread Miller, Jay
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

RE: Export problem

2002-05-21 Thread Miller, Jay
://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

RE: How to enable Java

2002-05-21 Thread Miller, Jay
: 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 REMOVE yourself

RE: Upgrade is Necessary?

2002-05-22 Thread Miller, Jay
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-- Public Internet access / Mailing Lists

Solution to Microsoft Transaction Server/Standby database problem

2002-06-03 Thread Miller, Jay
-- 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 list

RE: 9iR2 Install Problem

2002-06-03 Thread Miller, Jay
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 Diego, California

Permissions on user trace files

2002-06-05 Thread Miller, Jay
happy giving them permission to do so, since it means I won't need to run it for them several times a day. I'm on Solaris 2.6, Oracle 8.1.7.2 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: custom DD views to allow users to see source without needing

2002-06-05 Thread Miller, Jay
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 PROTECTED] Fat

RE: Permissions on user trace files

2002-06-06 Thread Miller, Jay
and then run tkprof on the resulting file. I'm perfectly happy giving them permission to do so, since it means I won't need to run it for them several times a day. I'm on Solaris 2.6, Oracle 8.1.7.2 TIA, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay

RE: Is this a good upgrade path from 8.0.4 to 8.1.7.2?

2002-06-07 Thread Miller, Jay
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: (858

RE: how to you stop an export?

2002-06-11 Thread Miller, Jay
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: (858) 538

RE: Hints being ignored

2002-07-01 Thread Miller, Jay
-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: Frequent ''ORA -1650: unable to extend rollback segment error

2002-07-01 Thread Miller, Jay
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: Unidentified sessions brought us to maximum processes - more

2002-07-02 Thread Miller, Jay
: 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

  1   2   3   >