Re: OT: Solaris: Finding the cause for disk space growth

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

Re: What to look for in STATSPACK report

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

Re: Metalink on the blink

] The swim only hurt once - from the beginning to the end - Doc Counsilman on swimming the English Channel at age 58 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: Startup Migrate

the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: AQ

the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: ORA-904 after table rename

send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: ADMIN: Status of list server systems (and update about

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.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Strange behavior - update

common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null; COUNT(*) 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network

Re: List problems

command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: most practical 9iR2 features?

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.net -- Author: Stephen

Re: Oracle8i on Linux

FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: Strange behavior

; COUNT(*) 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Strange behavior

testing. Stay tuned and I'll post updates as I make new discoveries. Thanks Stephen -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Strange behavior

common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null; COUNT(*) 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Re: Parse Vs Execute

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

RE: RMAN restore to different machine

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

RE: Change dedicated server to shared server

. Thank You www.proximo.com [EMAIL PROTECTED] * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Wow, Man, Flashbacks!

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.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Help with a scripting problem

dual; Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Arizona User Group Meeting 10/2/03

at www.azora.org. Topic #1: Oracle Selective Audit - Ray Kowalski is a Practice Manager with Oracle Corporation Topic #2: A Close Look at SQL Statement Tuning, Dan Hotka is a Training Specialist Thanks Stephen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET

Re: archive old data

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

Re: Copying statistics : used a lot ????

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

Re: sqlload

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

Re: SQL Loader help

-- Author: Stephen Andert 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

Re: Multiple DBs - Balancing Act

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

Merge patches

patch was not going to beet our requirements. Does anyone else remember this? Are they still doing this or can multiple 1-off patches be applied now? Stephen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network

Re: How to tell Oracle the directories of script files

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.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Metalink FTP Woes

is on Oracle's side or not? Stephen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: sqlnet.expire_time

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.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: AIX 5.2 Or AIX 5.1 for Oracle 9.2 database server?

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

Re: Oracle security question

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.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City

Re: Exam

the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: Deleting Statspack tables.

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.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: International User Community

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

RE: Schedule Analyze using DBMS_STATS ???

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

Re: SQL Loader

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.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City

Re: performance of sql loader

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

Re: Db. Upgrade Assistant - any bad stories?

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.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Re: Oracle Development Suite for Linux?

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

Re: New Storage

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

RE: IOUG setting up

. If you would like to get involved, I know that many user groups value volunteers to help put on events (sign in sheet, greeter, snack coordinator, etc.) Better yet, prepare a presentation (What I needed to forget about tuning once I got my Cert). Good luck Stephen Andert President, AZORA

RE: IOUG setting up

involved, I know that many user groups value volunteers to help put on events (sign in sheet, greeter, snack coordinator, etc.) Better yet, prepare a presentation (What I needed to forget about tuning once I got my Cert). Good luck Stephen Andert President, AZORA [EMAIL PROTECTED] 02/27/03 09:49AM

Re: Listener Hanging 64 Bit Solaris 8 Oracle 9.2

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.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: hw info on Tru64 system

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

RE: STATSPACK

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.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

ARIZONA Oracle User Group (AZORA) announcement

If you're in Arizona and are interested, the Arizona Oracle User Group (AZORA) is holding it's next meeting on 2/6/2003 from 12:30 to 5:00 PM. The agenda is: 1:00 PM - Michelle Mol (Veritas) No Time for Downtime: Architecting High Availability for Oracle Databases 1:00 PM - Stephen Andert

Re: Producing .mdb output from sqlplus or SQL or PL/SQL

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

Re: Ideas for future authors

sparked some testing and I found a predictable way to significantly speed up data loads when direct is not an option. Stephen Andert [EMAIL PROTECTED] 01/15/03 09:54PM I can certainly echo the sentiments expressed in this article. Writing a book ( as a coauthour in my case) was something I

Re: [Q] how to check rollback_segment has optimal setup?

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

RE: Ideas for future authors

to significantly speed up data loads when direct is not an option. Stephen Andert [EMAIL PROTECTED] 01/15/03 09:54PM I can certainly echo the sentiments expressed in this article. Writing a book ( as a coauthour in my case) was something I had wanted to do, and harbored no illusions of quick riches

Re: Database Reorg Question

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.net -- Author: Stephen Andert INET: [EMAIL

Re: Alter table monitoring ... impact on performance??

. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: ioug.org web site

log in, or register for IOUG-A Live. Is it just me? Matt Adams - GE Appliances - [EMAIL PROTECTED] My computer beat me at chess, but I won when it came to kick boxing. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat

Re: Tru64 Direct I/O

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

Re: FW: IOUG-A

I too will attend that class, even if I can't get my boss to spring for it. They are sending me there, but they don't have to pay for the conference, so I should be able to talk them into it. Stephen Andert [EMAIL PROTECTED] 01/06/03 12:14PM Jonathan, if you do decide to give that class, I am

RE: Automatic backup on Oracle 9i -- For Jared

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

Re: Hotsos Clinic

Jeff and Gary, Any trips planned for Arizona? I'll make sure to schedule our AZORA meeting to coincide with your visit if I can get you to speak for us hopeful grin Stephen Andert VP AZORA [EMAIL PROTECTED] 01/02/03 12:19PM go to the class. Do not pass GO and do not collect $200 but GO

Re: Datafile with no extension using sqlldr

understand I can rename the file. But, is there any other way to load a datafile with no extension? TIA, Krishna -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

TNSNAMES.ora to LDAP/OiD conversion

the advantages and disadvantages of each are. If anyone has gone through this and would be willing to discuss it with me sometime, please send me contact information off-list. TIA Stephen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED

RE: Happy Holidays!!

in as an alternate, but I did get my form faxed back in time, so you can't have my slot grin. Stephen Andert [EMAIL PROTECTED] 12/20/02 12:38PM Not until it comes back to Orlando. But when it does, I'll be there. I found the best way to deal with being in a nearly-all-male work situation is to become

Re: Faking an ORA-600

vi and manually add it ??? Stephen Andert Scottsdale, Arizona [EMAIL PROTECTED] 12/19/02 01:51PM We are trying to test out monitoring software (on a test database at 8.1.6.3). We have been able to generate most of the errors that we want to monitor for, but have been unable to generate

RE: Database up longer that host?

OK, since it's virtual anyway, grin [EMAIL PROTECTED] 12/04/02 06:18PM Thanks, but I'd rather have a nice shot of Scotch. :) Jared Stephen Andert [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/04/2002 03:39 PM Please respond to ORACLE-L To: Multiple recipients of list

RE: Database up longer that host?

(*) user_count from v$session where username is not null ) s / Stephen Andert [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/02/2002 07:58 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject

Database up longer that host?

:52, 7 users, load average: 4.13, 6.93, 7.08 SQL select sysdate from dual; SYSDATE 02-DEC-2002 15:40:39 SQL Is there something wrong with the script or just a misalignment in the starts? Stephen Andert (confused in AZ) -- db_uptime.sql select 'Host Name : '||host_name

RE: Database up longer that host?

8:34 PM To: Multiple recipients of list ORACLE-L On Mon, 2 Dec 2002, Stephane Faroult wrote: Stephen Andert wrote: I use a script named db_uptime.sql (I think I got it from the list here) to calculate how long the database has been up. The output compares nicely to the unix uptime

Re: Database up longer that host?

On Mon, 2 Dec 2002, Stephane Faroult wrote: Stephen Andert wrote: I use a script named db_uptime.sql (I think I got it from the list here) to calculate how long the database

Re: Sr. Oracle DBA Position- Must be 8i and 9i Certified-

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

SUMMARY: SQL*Net Message to client/SQL*Net more data to client

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

RE: IOUG Papers

, 2002 4:09 PM To: Multiple recipients of list ORACLE-L Does anyone know what the expected time-frame is for the IOUG paper seletion committee to select papers? I submitted a couple and am on pins and needles. Thanks Stephen Andert -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

IOUG Papers

Does anyone know what the expected time-frame is for the IOUG paper seletion committee to select papers? I submitted a couple and am on pins and needles. Thanks Stephen Andert -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED

RE: SQL*Net Message to client/SQL*Net more data to client

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

Re: RV: Nuestra Profesión Ing. Sistemas

! 19.- Tienes que brindarle servicios gratis a tu jefe, amigos y familiares. !Como las putas! !Puta! ¿¿Hasta cuándo?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

SQL*Net Message to client/SQL*Net more data to client

the cause (solution) to this drop in performance??? Help Stephen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: SQL*Net Message to client/SQL*Net more data to client

7.2 Client is 8.0.5 Any ideas on a next step for finding out the cause (solution) to this drop in performance??? Help Stephen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Multiple Listeners

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

Re: Client not using tnsnames.ora?

-- Author: Stephen Andert 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: Determine process of index build - HOW

, 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: Stephen Andert INET: [EMAIL PROTECTED

Re: Report coredump w/r25run -- SOLVED

port of the application and reports. Thanks to all for the suggestions. Stephen Andert [EMAIL PROTECTED] 08/22/02 08:53PM Tru64 unix and VMS Suddenly all reports that were working just fine this morning quit working. In Unix we get memory fault and a coredump. In VMS we get %SYSTEM-F

RE: List of all zip codes,city,state to load into table.

://www.orafaq.com -- Author: Stephen Andert 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: Table Naming Conventions

') 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: Stephen Andert INET

RE: Connection problem if parameter HOME is set - SOLUTION

. Stephen [EMAIL PROTECTED] 07/19/02 12:08PM Does it have any sqlnet.ora, tnsnames.ora file? - Kirti -Original Message- From: Stephen Andert [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 19, 2002 12:53 PM To: Multiple recipients of list ORACLE-L Subject: Connection problem

Re: Oracle DB Crash

64-bit. Thanks Stephen Andert [EMAIL PROTECTED] 07/24/02 11:17AM To ALL, I'm going to ask if anyone on the list has seen the following, and if so, what did you do about it if anything. First environment: Oracle 8.1.7.4.0 on HP-UX 11.0 both in 64 bit. OCI interface programs

RE: Rant-Rant

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

Re: Error on creating index

priviliges.(unlimited tables space,connect,resource,...) what is the problem. please help me -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: 2003 IOUG Meeting

Add to that the cost of getting there (Orlando FLfor 2003), transportation to/from the airport hotel (4-6 nights at around $200/night depending on what hotel you stay at) some meals (lunch is usually provided, some evening events include enough food for dinner) That said, I hope that

Re: Rollback OPTIMAL setting

, but I want to gather more opinions and experiences. Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Re: How to make SQLLDR to run faster?

David, start shameless self-plug I wrote an article last year about tuning SQL*Loader. It is at http://oracle.oreilly.com/news/oraclesqlload_0401.htmlI experienced a huge improvement in performance and others have told me that they were able to achieve similar improvements. end shameless

Re: sqlldr

Ravi, To the best of my knowledge, there is no limitation on the number of records that can be loaded at a time other than the size of your rollback segments. I have loaded 10's of millions of rows in a single sqlldr job by setting some parameters. There are defaults that work, but don't

Re: IOUG conference get together

Count me in. When/Where? Any San Diego local(s) on the list? Stephen Andert [EMAIL PROTECTED] 04/09/02 07:43AM Do we have a location, date, time???--- Joe Testa [EMAIL PROTECTED] wrote: So for those of us going to the IOUG Conf, do we want to plan a get together? Throwing this out

Re: Database shut itself down

Dave, Maybe I'm way off base here, but it looks like there is some problem at the OS level. Is that file still there and writable? Stephen [EMAIL PROTECTED] 04/02/02 12:03PM I have a 8.1.7 database running on NT 4.0 that had a problem this morning and shut itself down. In the

Re: CLIENT VERSION

ate client-side patch? Or is none needed? Stephen Andert [EMAIL PROTECTED] 03/28/02 04:43PM Here's a way on unix:strings $ORACLE_HOME/lib/libclntsh.so | grep "^Version [7-9]"--Jeremiah Wiltonhttp://www.speakeasy.net/~jwiltonOn Thu, 28 Mar 2002, Harvinder Singh wrote: In batch script I

Pro-C differences VMS to Unix

8.0) to Unix (Oracle 8.1)? Thanks in advance for any advice or suggestions. Stephen Andert

RE: Pro-C differences VMS to Unix

e-From: Stephen Andert [mailto:[EMAIL PROTECTED]]Sent: Friday, March 29, 2002 11:08 AMTo: Multiple recipients of list ORACLE-LSubject: Pro-C differences VMS to Unix Hey all, I know there are developers lurking out there as well as dba's that have a great deal of development

Problem with standby database listener

Fellow dba's, We have come across a weird problem with a standby database. Every timewe issue "alter database mount standby database"on thestandby database, the primary database fails to connect through listener. It becomes OK after primary database is shutdown and restarted of course

Re: Template for documenting database

off-list. Stephen Andert [EMAIL PROTECTED] [EMAIL PROTECTED] 01/07 11:02 AM Hi All, I have come into a situation where most of the database systems are not very well documented. Does anyone have any templates,resources,links that may provide either a template or example of what should

Re: Analyzing partitioned tables

Here is what we use which also incorporates usingour own definition ofSTALE with monitoring on. It includes indexes as well as partitioned and non-partitioned tables as well as non-monitored tables. HTH select 'analyze table ' || '${SCHEMA}.' || a.table_name || ' compute statistics;'

Re: Becoming a DBA questions

Actually, I passed it on to my supervisor with a brief (cynical) comment. evil grin Stephen [EMAIL PROTECTED] 01/03/02 03:35PM Paul, just goes to show how many people on the listserv have me in theirkillfile, since you're the only one that caught it.joePaul Baumgartel wrote: Wow, Joe,

RE: Table MONITORING

In one version (I think is was 8.1.6.x.x)analyze stale didn't work right. In 8.1.7 (releases the we've tried, .0 and .2), it didn't work for partitioned tables. The monitor piece appears to work, soone of the other dba's here wrote a script using all_tab_modifications and dynamic sql to

Re: Becoming a DBA questions

correct you or add to your knowledge. Before you know it, you will be sitting in an interview and the interviewer will ask you to explain how to use pctfree and you will know from your conversations and testing. Good luck. Stephen Andert Scottsdale, Arizona [EMAIL PROTECTED] 12/31 2:00 AM

Re: SQL*Loader-417 Error

get GIGO. If you provide more info on your layout and the FK error I'm sure someone will be able to help. If you have any questions, please feel free to drop me a note. Stephen Andert Scottsdale, Arizona [EMAIL PROTECTED] 12/13/01 15:52 PM I am getting the following error for this line of code

  1   2   >