Re: Oracle Reports 6i Vs 9i

2002-08-19 Thread Charlie Mengler
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). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641

Re: SSO - and nothing else

2002-08-15 Thread Charlie Mengler
may also send the HELP command for other information (like subscribing). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131

Re: Unix Script Quest : Urgent

2002-08-09 Thread Charlie Mengler
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). -- Charlie Mengler Maintenance

user(s) RBS

2002-07-30 Thread Charlie Mengler
If I'm interested in a specific RBS, how do I determine which user(s) are making use of this segement? How do I determine which RBS a particular user is using? -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641

Re: ANALYZE question

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

Re: Where is Oracle 9.2 init.ora?

2002-07-11 Thread Charlie Mengler
). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Lack of planning on your part doesn't constitute an emergency on my part

Re: Oracle 9.2 spfile catch 22

2002-07-11 Thread Charlie Mengler
') 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). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED

Re: system event waits

2002-07-02 Thread Charlie Mengler
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). -- Charlie Mengler Maintenance

Re: Oracle DBA with TS SCI Clearance Needed in Dayton, Ohio..

2002-06-26 Thread Charlie Mengler
: Charlie Mengler 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

Re: V9.2 SGA

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

Re: Difference Between DBMS/RDBMS

2002-06-25 Thread Charlie Mengler
on a Univac box with only 8K words. I was the Sys. Admin on a VAX 11/780 (VMS V1.3) in 1979 which had 256KB of RAM and supported a s/w development staff of more than a dozen programmers! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL

Re: NOT IN performance problem

2002-06-25 Thread Charlie Mengler
want to be removed from). You may also send the HELP command for other information (like subscribing). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 The Micro$oft Haiku Creed San

V9.2 SGA

2002-06-24 Thread Charlie Mengler
this total to around 32MB. TIA HAND! -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 The Micro$oft Haiku Creed San Diego, CA 92131 Chaos reigns within. Reflect, repent, and reboot. Order

Re: Urgent : UTL file problem

2002-06-21 Thread Charlie Mengler
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: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Oracle developer openings in San Diego

2002-06-18 Thread Charlie Mengler
of employees from approximately 2,900 to 1,500 remaining after the previously announced divestiture of its Supply Chain Enablement business. http://sdweb02.peregrine.com/prgn_corp_ap/CorporateInfo/pstFinancialNewsFullBody.cfm? objectid=1410EACF-81F9-11D6-967F00508BD33BE3 HAND! -- Charlie Mengler

Re: how to identify what sql statements are generating archived logs

2002-06-14 Thread Charlie Mengler
-- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 There are no stupid questions, but there are many inquisitive idiots! -- Please see

Discount book websites

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

Re: 64-bit OS

2002-06-12 Thread Charlie Mengler
want to be removed from). You may also send the HELP command for other information (like subscribing). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA

Re: grant access to another user's objects?

2002-06-10 Thread Charlie Mengler
command for other information (like subscribing). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Am I sure? Of course I'm sure. I could be wrong

iTAR

2002-05-07 Thread Charlie Mengler
I've been unsuccessful submitting an iTAR so far this morning. I'd like to hear if other list members have had success or failure opening a new iTAR today. FWIW - It fails using both Netscape IE browsers; but I get different symptoms from eachof them. -- Charlie Mengler

Re: Does any one know how to call LDAP from UNIX script ?

2002-05-02 Thread Charlie Mengler
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229

Re: Database Normalization-Outdated?

2002-04-30 Thread Charlie Mengler
,value,event code,comment) combination describing everything about that customer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: Size of segment

2002-04-29 Thread Charlie Mengler
://www.orafaq.com -- Author: Charlie Mengler 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: CPU Pegged at 100%

2002-04-26 Thread Charlie Mengler
0 fixed_sga75,804 75,804 0 log_buffer 163,840163,840 0 - Thanks, Raghu -- Charlie Mengler

AUDIT_ACTIONS

2002-04-25 Thread Charlie Mengler
: http://www.orafaq.com -- Author: Charlie Mengler 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: ioug-a question

2002-04-21 Thread Charlie Mengler
') 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: Charlie Mengler INET

Re: Ang: Re:Import excelfile into Oracle table

2002-04-18 Thread Charlie Mengler
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Re: initjvm and rmjvm failing

2002-04-16 Thread Charlie Mengler
(application/octet-stream) Encoding: 7bit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Re: OC4J

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

Re: Overall database tuning

2002-04-14 Thread Charlie Mengler
is not in the DB but in the application. Where to start? Get the book Oracle Performance Tuning 101 by Gaja Vaidyanatha RTFM. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

V$SESSION

2002-04-11 Thread Charlie Mengler
683581 -1 14 13785328 11-APR-02 117 -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131

Re: disk subsystem performance question

2002-04-10 Thread Charlie Mengler
load job almost doubled in time from 150 minutes to 270 minutes due to the double writes incurred by RAID-5 overhead. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Re: disk subsystem performance question

2002-04-10 Thread Charlie Mengler
(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: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Re: archive log curr v. switch logfile

2002-03-29 Thread Charlie Mengler
: 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). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831

Backups

2002-03-29 Thread Charlie Mengler
How many sites are doing cold backups? At what frequency? How many sites are doing hot backups? At what frequency? Does anybody know the existance of any Best Practices paper on the web that discuss the topic of Oracle backups? If so, what's the URL? TIA! -- Charlie Mengler

undocumented initSID.ora parameter

2002-03-25 Thread Charlie Mengler
What is the undocumented (unsupported) parameter which allows/forces Oracle to ignore the state of the redo logfiles open up anyways? TIA! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858

6i webforms

2002-03-25 Thread Charlie Mengler
the thin clent to the DB and back again? Please note that this delay is intermittent. For much of the time the response time via webforms is perfectly OK. TIA HAND! -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct

Re: OAS 9i anyone?

2002-03-21 Thread Charlie Mengler
the list if you so desire. HTH YMMV HAND! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Re: ORACLE 9i Database and Oracle9ias application

2002-03-21 Thread Charlie Mengler
or not? Yes, you can use oracle for both, but will need a way to change ORACLE_HOME. FWIW - I don't believe that all pieces of 9iAS are actually certified to run with 9i DB. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat

Re: PCTFREE and PCTUSED

2002-03-20 Thread Charlie Mengler
') 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). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED

Re: ORACLE TUNING

2002-03-19 Thread Charlie Mengler
from). You may also send the HELP command for other information (like subscribing). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Lead, follow

Re: Poll Questions

2002-03-13 Thread Charlie Mengler
list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San

HOT BACKUPS

2002-03-07 Thread Charlie Mengler
Buffers268435456 bytes Redo Buffers 278528 bytes Database mounted. Database opened. SVRMGR -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network

Re: Riddle me this Oracle riddle...

2002-03-06 Thread Charlie Mengler
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). -- Charlie Mengler Maintenance Warehouse

Re: Does Oracle 9iAS only run on Apache?

2002-03-01 Thread Charlie Mengler
and are they supported by Oracle? Take your pick. No, of course not. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Re: OPS$ / default accounts

2002-02-01 Thread Charlie Mengler
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). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641

Re: ORA-01555 Mystery (Help)

2002-01-25 Thread Charlie Mengler
may also send the HELP command for other information (like subscribing). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Our customers are part of our team

Re: How to calculate Last and First Day of Month?

2002-01-23 Thread Charlie Mengler
. Can you please tell me how to get first and last days of the month given SYSDATE? thanks a lot Regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Re: Oracle8i and LDAP

2002-01-16 Thread Charlie Mengler
information (like subscribing). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 I'm as busy as a one armed wall paper hanger! -- Please see the official

Re: new to DBA

2002-01-14 Thread Charlie Mengler
the HELP command for other information (like subscribing). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 I'm as busy as a one armed wall paper hanger

RMAN

2002-01-12 Thread Charlie Mengler
Can RMAN be used to backup a V7.3.4.5 instance? In addition to the obsolete version, which I'm forced to continue to support, I'm supporting both 8i 9i instances. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City

Re: CHAINED ROWS

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

Re: Clone a database

2002-01-09 Thread Charlie Mengler
). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 6041 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 I'm as busy as a one armed wall paper hanger! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Re: Runing OS Commands from Stored Proc.

2001-12-13 Thread Charlie Mengler
LOADJAVA. Create a function call spec to call the program. Turn serveroutput and java output ON. Question 1) What is loadjava? how is it used ? 2) How is turning Java output on? TIA Bunyamin -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED

tablespace in backup mode

2001-12-10 Thread Charlie Mengler
Which table/view do I query to determine if any tablespace has been left in hot backup mode? -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 6041 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Rose are red

Re: DBA Weakest Link

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

Re: DBA Weakest Link

2001-12-07 Thread Charlie Mengler
What is the error message associated with the often seen ORA-01555 error? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

V7 online backups

2001-12-06 Thread Charlie Mengler
! -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 to_date((2440588+((date_time-mod(date_time,86400))/86400)),'J')-8/24+mod(date_time

Re: Delete slowing..

2001-11-29 Thread Charlie Mengler
://www.orafaq.com -- Author: Charlie Mengler 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: ORA-12701 on Oracle 9i

2001-11-29 Thread Charlie Mengler
12701 Instance terminated by USER, pid = 4066 ORA-1092 signalled during: ALTER DATABASE OPEN... Thanks Yuval. -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229

v$session_wait

2001-11-27 Thread Charlie Mengler
One of the fields is WAIT_TIME A non-zero value is the session's last wait time. A zero value means the session is currently waiting What are the units associated with this number? -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED

Re: 9iAS

2001-11-22 Thread Charlie Mengler
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: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

SQL Tuning

2001-11-20 Thread Charlie Mengler
Yesterday at the SDOUG meeting Mark Gurry gave a 2 hour presentation on tuning. His slides can be found at http://www.sdoug.org/ Slide #62 held the answer to Rajendra Jamadagni index problem. He's the author of a couple of books on Oracle SQL tuning. HTH HAND! -- Charlie Mengler

Re: Problems with Linking PROC Code

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

Re: select and rollback

2001-11-15 Thread Charlie Mengler
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). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED]10641 Scripps Summit Ct. 858

Re: Online index rebuilds

2001-11-15 Thread Charlie Mengler
on 9.0.1.1.1 EE WIN2K Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: executing unix commands from PL/SQL

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

Forms6

2001-11-09 Thread Charlie Mengler
. -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED]10641 Scripps Summit Ct. 858-831-2229San Diego, CA 92131 Extraordinary DBA - Design on the Fly Just In Time Programming -- Please see the official ORACLE-L FAQ

Network Appliance

2001-10-29 Thread Charlie Mengler
I've been asked to review Power Point marketing presentation and a white paper both publishd by Network Appliance. I'd like to hear off list from anyone who has had some hands on experience with this technology. TIA HAND! -- Charlie Mengler Maintenance Warehouse

Re: Cross Platform RPC

2001-10-25 Thread Charlie Mengler
-- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED]10641 Scripps Summit Ct. 858-831-2229San Diego, CA 92131 NOTHING is impossible for the person who does not have to do it! -- Please see the official ORACLE-L

Re: Update invalid trigger_text in DBA_TRIGGERS?

2001-10-25 Thread Charlie Mengler
ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Rebuilding Indexes Question

2001-10-22 Thread Charlie Mengler
://www.orafaq.com -- Author: Charlie Mengler 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

9i upgrade problems

2001-10-20 Thread Charlie Mengler
PROTECTED] Disconnected from Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production With the Partitioning option JServer Release 9.0.1.0.0 - Production -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services

Re: Extents size.

2001-10-03 Thread Charlie Mengler
: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Partitioning

2001-10-03 Thread Charlie Mengler
. http://www.oracle.com/ip/deploy/database/oracle9i/index.html?sp_pkgsum.html HTH YMMV! -- Charlie MenglerMaintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131

inefficient SQL detector

2001-10-03 Thread Charlie Mengler
that hopefully will GREATLY increase the selectivity of the SQL, rather than doing cartesian joins across tables. HTH YMMV! -- Charlie MenglerMaintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229

Re: stripes or separate spindles

2001-09-26 Thread Charlie Mengler
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). -- Charlie MenglerMaintenance Warehouse [EMAIL PROTECTED

Re: Installing 8.1.7

2001-09-25 Thread Charlie Mengler
of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Charlie MenglerMaintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229

9iAS Forms on Solaris (or Unix)

2001-09-17 Thread Charlie Mengler
to an environmental variable, filename case sensitivity (since the FMB files were created on NT), or something else. I'd like to hear from anyone who is successfully using *mmb, *olb, *plx files on Unix to generate fmx files. -- Charlie MenglerMaintenance Warehouse [EMAIL

[Fwd: RE: Looking for 24 X 7 Design Considerations]

2001-09-17 Thread Charlie Mengler
I guess then I'm "nutso", because I have a 9i DB in production. Any independently verifiable substantiation for your claim would be welcomed. This 9i instance has had flawless performance for the last two months; which is how long it has been in production. Original Message

RE: Looking for 24 X 7 Design Considerations

2001-09-17 Thread Charlie Mengler
, for example. Paul Baumgartel --- Charlie Mengler [EMAIL PROTECTED] wrote: I guess then I'm nutso, because I have a 9i DB in production. Any independently verifiable substantiation for your claim would be welcomed. This 9i instance has had flawless performance for the last two months; which

Re: Copy Oracle's binary.

2001-09-17 Thread Charlie Mengler
://www.orafaq.com -- Author: Charlie Mengler 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

Off Topic posts

2001-09-12 Thread Charlie Mengler
Topic posts have exceeded on topic ones. -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Data-free analysis results in a success-free history. -- Please see

RE: dbms_utility.compile_schema

2001-09-12 Thread Charlie Mengler
When there are mutiple INVALID objects it can be the case that object Z uses object Y which uses object X. If X, Y Z are invalid, you'd need to invoke dbms_utility.compile_schema up to THREE times if the invalid objects are compiled in alphabetical order. My PL/SQL procedure use an invalid

Re: Ftp from PL/SQL

2001-09-12 Thread Charlie Mengler
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229

Re: Publishing HTML

2001-09-10 Thread Charlie Mengler
ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Publishing HTML

2001-09-07 Thread Charlie Mengler
doing a real time DB query anytime somebody wants to look at the phone list on the web. TIA HAND! -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Data-free

Re: Advice required : Executing application PL/SQL when database is s

2001-09-06 Thread Charlie Mengler
(like subscribing). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Data-free analysis results in a success-free history. -- Please see the official ORACLE

Re: Last time an Index was used..

2001-09-06 Thread Charlie Mengler
for other information (like subscribing). -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Data-free analysis results in a success-free history. -- Please see

Re: Export/Import question

2001-09-05 Thread Charlie Mengler
://www.orafaq.com -- Author: Charlie Mengler 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

file/tablespace deleted at the OS level

2001-09-01 Thread Charlie Mengler
file and startup. If my recovery steps fail, I'll get all the files for this instance restored from Thursday's cold backups. TIA HAND! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

OT: financial problems with fatcity.com

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

OT: Peoplestaff spammer aka Rick Zabor

2001-08-30 Thread Charlie Mengler
of the solution, then you are part of the problem. HAND TIA! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: UTL_FILE and ksh

2001-08-30 Thread Charlie Mengler
are to have the processes writing the file to only make the file readable to other processes once it is complete? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Re: Preventing logins from applications

2001-08-28 Thread Charlie Mengler
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). -- Charlie Mengler Maintenance Warehouse [EMAIL

Re: svrmgrl, sqlplus question ???

2001-08-27 Thread Charlie Mengler
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Converting EBCDIC to ASCII

2001-08-17 Thread Charlie Mengler
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). -- Charlie Mengler Maintenance Warehouse

9iAS

2001-08-08 Thread Charlie Mengler
clueless WRT which Oracle product or feature to provide me any of this capabilities. So which part of 9iAS does each of the three tasks listed above? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services

Re: Unix Client Install

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

Re: completely off-topic question...

2001-08-03 Thread Charlie Mengler
www.acronymfinder.com Hope This Helps! Michael wrote: ...which means it's probably going to start a great big thread :)I see a lot of emails with HTH on them, seemingly some sort of way to say "thankyou" or something... as they're always at the end of somebodies message right before they sign

  1   2   >