RE: Pondering Question of the Day-RESPECT

oved 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 FAX: (858) 538-5051 San Diego, California

Listener consolidation

would be appreciated greatly. Stephen Andert -- 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

Re: DBA Job at a Chocolate Factory

Steve, I don't about unique, but variety is what I enjoy. I've worked at a bank, mortgage bank, diesel engine sales and service, city government and am currently working for an insurance company. Stephen Andert [EMAIL PROTECTED] 03/21 9:06 AM Seven years ago I was offered an Oracle

Re: Sql Loader documentation

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

Re: How to break into DBA/Systems work without going brokedoing

ttp://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 thi

Re: Oracles TBT's

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] Fat City Network Services-- (858

Re: Stephen Andert's article

Thanks for all the feedback. Hope everyone that uses SQL*Loader benefits from it. Stephen [EMAIL PROTECTED] 04/13 10:31 AM On Fri, 13 Apr 2001, Jonathan Gennick wrote: Stephen Andert, a member of this list, has a SQL*Loader-related article running on the O'Reilly Associates web site. You

RE: Stephen Andert's article

the a bast-case scenario. I like to read a lot and when I read technical books, I always have a pen, highlighter and post-its. You can tell how much I got out of a book by how may post-it's are sticking out of it. Stephen Andert [EMAIL PROTECTED] 04/13 11:06 AM Jonathan, Congratulations

OT: RE: Do not belive BUSH and your army goverment so much

and world religion on an Oracle Tech List for the sake of bandwidth. -- 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 Inter

Re: Meeting at IOUG

I'll be there and would like to meet as many of you as possible. If anyone who knows the ropes can suggest a time/place, that would be great. As this is my first IOUG event, I don't have any ideas on where/when, so it's up to all you "veterans". Keep this thread going. Step

Re: Meeting at IOUG

I nominate Monday evening. That way those of us who don't know anyone will have more familiar faces the rest of the week (especially at the big bash on Tuesday). I don't have a clue where to meet. IOUG veterans any suggestions? Stephen Andert -- Please see the official ORACLE-L FAQ

Re: Locally Managed Tablespaces

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

Re: Looking for opions on I/Watch from Quest

not found a manageable way to page according to our business rules. Other than that, it is a pretty good tool. I prefer to use Spotlight to look at the system live and SQLab Xpert to tune SQL. YMMV, HTH, etc. Stephen Andert [EMAIL PROTECTED] 05/08/01 12:43PM I am looking for opions

Re: desc SQL*PLUS

). -- 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: 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: 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: 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: 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: 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

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: 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

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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: Privileges

, it's just managing the developers that is a pain because of this. Have fun. Stephen Andert [EMAIL PROTECTED] 08/07/01 09:00AM I have granted 'all' to a table owned by owner1 to a role. I granted this role to user1. User1 can access this table via SQL*Plus and Developer. However, when

Re: sqlloader stops

Lyuda, I'll jump intothe game of 20 questions. Is the batch file kicking off the jobs in serial (one after the other) or in parallel (maybe using to put each one in the background)? Stephen Andert [EMAIL PROTECTED] 08/08/01 07:06AM If I execute one load at the time maually it loads

OT: List slow today?

Other than during IOUG-A, I haven't seen this few messages. Is my mail server eating messages or is it just a slow day? Stephen

RE: OT -- training

Christopher, On that same thought, I read the best response to a company who won't train their people because then they'll leave. Which would you rather have happen? Train people and have them leave or not train them and have them stay? I know where I'd rather work. Stephen Andert

Re: Netbackup with Oracle 817

Nbir, Well I'm no expert on backups, but we are in the process of rolling out rman and Veritas Netbackup across our company. This includes several databases that are well over 200GB. We have an ATL (Automated Tape Library) with around 300 slots and currently 10 drives. We are having some,

RE: Comment on 'Practical Oracle 8i'

That's nothing, I've got 3 486's in my garage. Stephen If you have any questions, please feel free to call me or drop me a note. Stephen Andert480-445-2506 [EMAIL PROTECTED] 08/16/01 01:06PM i got a 75Mhz pentium sitting in my desk drawer :) joe [EMAIL PROTECTED] 08/16/01 03:45PM

RE: OT: DBA tasks

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

Exporting partitioned tables

. I RTFM'd and that error message indicates that the object is gone. This object is not dropped and re-created by any process. Any ideas? Stephen Andert

Re: How do they get the answer?

Well, to me it looks like WHERE subject_id IN (102, 105);will select 2 classes. Since there are a minimum of 2 teachers per class, this will select at least 4 teachers. Am I missing something? Stephen [EMAIL PROTECTED] 08/21/01 09:25AM I am taking the Self-Test software test for the

RMAN Copies

ters, tips, suggestions, etc. Stephen Andert

Re: OT: Unix - performance tuning (vmstat 5)

Try this: var_pid=`echo $var_grep_vmstat | grep -v grep | (read u v w x y z; echo ${v} )`kill $var_pid the grep -v grep will remove any lines with the word grep. HTH Stephen [EMAIL PROTECTED] 08/22/01 05:05AM Hi Unix Gurus,I submit a job to monitor the CPU utilization etc every 15 mins

Standard SQLNET.ORA with multiple O_HOME's

a master location on a nightly basis and would like to do the same with a standard sqlnet.ora. Any thoughts? Thanks Stephen Andert

RE: Data Center monitoring

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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: financial problems with fatcity.com

I second that motion. I just spent over $100 to get my 2 boys signed up for Cub Scouts and one of them has weekly dues of $1.00. For me it $12/yr would be worth it. Maybe offer a lifetime membership of $25 or something. My 2 cents worth Stephen Andert [EMAIL PROTECTED] 08/29/01 08:15AM I

RE: Lisa

Lisa, do you have a file of "titles" or do you keep coming up with new ones? I read your messages just to see things like: Dog Bone AdministratorThe Bootylicious DBA and many more StephenNo funny sig line

RE: Oracle DBA With Internet Experience Needed in Harrisburg,

A lot cheaper that regular mail where he would have to pay for printing, paper, envelopes and postage. It's all relative. Stephen [EMAIL PROTECTED] 08/30/01 12:26PM 1500 users / 10$ = 6.6 cents per email. Pretty expensive rates don't yathink?-Original Message-From: Farnsworth,

Re: SQL*LOADER ERROR

Hello, Have you connected with "sqlplus username/password@qtel"? If you did sqlplus without the @qtel, you are not using the listener. In that case, you will probably want to get the listener running (or running correctly). HTH Stephen [EMAIL PROTECTED] 09/04/01 01:56AM Hi

RE: Interesting News..

In fact today's Wall Street Journal quotes HP's CEO as saying the Compaq name will go away. I guess running it into the ground would take too much time so she is just going to abandon the Compaq name. They did say they plan to keep some of the "valuable sub-brands" like Presario. We

User Query Tools

Hey all, I just got out from a meeting where I was told that some of our users are asking for a tool to do their own queries against our database so they wouldn't have to request reports and such from IS. Oh BTW, they don't know (or feel the need to learn) SQL so they will be needing

New York/East Coast !!!!

I sure hope our members on the East Coast are ok. If anyone is out there and has access, I'd be happy to pass along any messages to family, etc. Let us know if you guys are ok. Stephen Andert -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET

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

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: 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: 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

Microsoft Transaction Server hangs

I'm looking into this for a colleague. Environment NT 4 SP 6 Oracle server 8.1.5 At several times throughout the day, the connection hangs. MTS seems to still be running, the db is still accessible. Bouncing the MTS service resolves the problem for a while. I have asked them to check

RE: Microsoft Transaction Server hangs

Thanks for your response. I have not worked with MTS, can you please tell me what I should have my colleague do to turn on tracing and identify the location of the log file? They are in a different state and since it is not unix, I am a bit behind the curve and I have very big shots

Re: Rollbacks - ORA-1555

tasks can eat up more rbs, but since they are dba activities, we just shrink a single rollback segment at a time if it gets too big. HTH Stephen Andert [EMAIL PROTECTED] 12/04/01 03:50PM Greetings All I am some what new to the list, so forgive me if I don't have the proper etiquette

ODBC Microsoft Transaction Server

SetConnectAttr Failed(0) SQLPOINTER [Unknown attribute 201] Any help pointing me where to look for the root cause of this problem would be appreciated. Thanks If you have any questions, please feel free to drop me a note. Stephen Andert Scottsdale, Arizona -- Please see the official ORACLE-L

Re: Recommenations for a DB conversion using SQL Loader

Depending on how much data you have, look at doing a little tuning of the BINDSIZE and ROWS parameters. Send me a personal e-mail if you want more information on that. Stephen Andert Scottsdale, Arizona [EMAIL PROTECTED] 12/12/01 11:35 AM Ken, A few things you could try here: 1) disable

RE: SqlLoader

(echo $ORACLE_HOME on Unix) decides what db to connect to and could be pointing you to a different db. HTH Stephen Andert [EMAIL PROTECTED] 12/12/01 23:54 PM Thank you for your reply. The user does have DBA rights and also owns the table that is being referenced. If it was a table rights

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

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: 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: 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: 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: OT: a bit of a brag...

Congrats! I hope my boys' resume looks as impressive someday. (I'll give them a few years yet as they're just 5 and 9 now). Stephen Andert [EMAIL PROTECTED] 05/14/01 01:20PM My eldest graduated from college Saturday. A double major in Spanish and German, cum laude, and a Fullbright

Re: Performance tuning

Azhar, I agree with the other responses (more RAM, don't use OPTIMAL on your RBS's) but would also suggestdropping all indexes except PK until the load is done, therebuild them. Also, does this table have any triggers? If so, if can you disable them during the load, that will help speed

Re: OT: Working from home

Mark, Well, in order to give you my 2 cents worth, lets answer those in order: Accountability: Work needs be get done whether in office or at home. If it gets done and db's are running well, it shouldn't matter where it gets done from. This is very hard for some managers to understand

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:RE: Multiple Listeners

Dick, Well, I've not seen the bug you describe and we have over 20 db's in one listener on several different boxes. We are in 8.1.6 on Compaq Tru64. We did have a problem trying to get one listener in 8.1.6 to listed for 8.0.x and 7.3.x databases and WWS discovered that a bug they thought

Re: any way to stop rollback for dml?/8.1.7.1/Solaris 8

Steve, As far as speeding up the sqlldr process, you could take a look at an article on O'Reilly's web site. It's at http://oracle.oreilly.com/news/oraclesqlload_0401.htmland documents the fairly painless process I used to speed up data loads we are doing here. HTH Stephen Andert [EMAIL

RE: sqlloader process dies

Lyuda, What are your settings (BINDSIZE, ROWS, etc)? Also how big and how many rollback segments do you have? How big is their tablespace? If you have any questions, please feel free to drop me a note. Stephen Andert [EMAIL PROTECTED] 07/31/01 04:30PM I could do it but the trick

RE: (Fwd) Oracle8i Database Administration Boot camp

moke break since that was the only way to get away from my desk sometimes. It worked. Stephen Andert [EMAIL PROTECTED] 07/31/01 10:10PM there are times I regret giving up smoking -- I want the cigarette breaks.I wonder if I can get away with a non-smoking break hm.From: Kimberly Smi

RE: New York/East Coast !!!!

:25 AM Is there anyway we can submit names of family members in NY -Original Message- From: Stephen Andert [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 11:25 AM To: Multiple recipients of list ORACLE-L Subject: New York/East Coast I sure hope our members

RE: STOP THE PRESS!!

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] Fat City Network

Re: OT Terrorist Acts

Rachel, Glad to see you are ok! I was glad to see the message from Ross saying you were ok. Stephen Andert [EMAIL PROTECTED] 09/11 6:35 PM just because we will have to kill does not mean we have to like it. It's what separates us from animals. My heart is bleeding for the families

Re: The DBA in the IS organization

-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 To REMOVE

RE: {9i New Feature: Query Flashback }: This one is long

If he is preparing a presentation, it is definitly one I won't want to miss. Stephen Andert [EMAIL PROTECTED] 10/23/01 02:40AM I think Joe's just doing it to be helpfuland as a way of learning the 9i stuff... he has to play with it to beable to write about it--- Larry Elkins [EMAIL

RE: i need check fragmentation of index

Watch out though! From the 8.1.6 documentation: "Validating the structure of an object prevents SELECT, INSERT, UPDATE, and DELETEstatements from concurrently accessing the object. Therefore, do not use this clause on thetables, clusters, and indexes of your production applications during

Re: Oracle related docs/OCP materials

Boy, this was sure a disappointment. No white papers that I could find. The What's News section is listing the 9i beta test offerwhich expired nearly a month ago. The only thing there was the change to spend money on your 2 products. :( [EMAIL PROTECTED] 11/10/01 08:00AM Hi, We

RE: Oracle related docs/OCP materials

Yes, it is a big part of why I was able to pass my Performance Tuning OCP test. Stephen [EMAIL PROTECTED] 11/13/01 09:55AM Have you guys checkout out www.freeocp.com created by one of our own list members Mr. Ethan Post? -Original Message-From: Arslan Bahar

Re: Bug 1367773

So far no one answered so I tried and was told Your search returned no hits! I generally have the worst luck in looking up bugs. I do ocassionally hit a few bugs, but most of the time nothin'. HTH Stephen [EMAIL PROTECTED] 11/14/01 07:45AM Hi List,does anyone have description (body) of

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

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: 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

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: 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

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: 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

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

  1   2   >