RE: PL/SQL - can't accept user input - then how?

If you already have shell script front end, would it be acceptable to prompt for the input in the shell script rather than in the procedure? #!/bin/ksh echo ENTER LOGIN read USER echo ENTER PASSWORD stty -echo read PASS stty echo echo ENTER WHAT IT IS read INPUT sqlplus -s -XXX

RE: How to add ' (comma) at the begining and end of each line? Ei

Oh, and I almost forgot a ksh example (Perl? What's Perl?) cat your_file | while read LINE; do echo '$LINE'; done Or while read LINE; do echo '$LINE'; done your_file -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City

RE: How to add ' (comma) at the begining and end of each line? Ei

line. For example, abf jd djkhk jd3 Shold be convrted to 'abf', 'jd', 'djkhk', 'jd3', Any help will be really appreciated. Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services

RE: I HATE ORACLE LD_LIBRARY PATH - GRRR!!!

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

RE: anyone have opinions on the future of the 'grid'?

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

RE: insert and commit 1000 records at a time

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

RE: Table Size

How about: select sum(bytes) from dba_segments where segment_name = 'TABLE_NAME'; -Original Message- Hi All, Could somebody help me in finding the actual size of an oracle table in GB. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET

RE: OT, But really STUPID

: http://www.orafaq.net -- Author: Stephen Lee 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

RE: weird

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

RE: weird

Just one transaction. Nothing else going on. -Original Message- Stephen, Was this the only running transaction? No background stuff going on? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City

RE: weird

-- -- SYSTEM 3204 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

weird

3181 1 row selected. SQL / USERNAMEX -- -- SYSTEM 3204 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network

RE: OT, But really STUPID

I saw that on cnn.com too. Didn't the article say the guy has broken his neck three times? Maybe that tells you something. -Original Message- British Company Declares War On Internal E-mail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee

RE: weird

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

RE: DBMS_STATS and CBO

tempfile never grabbed any space. So, I think I can say that is definitely didn't run out of space; but maybe somebody walked across the space the tempfile thought it was going to get in the future. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET

RE: DBMS_STATS and CBO

Sorry about the last post. Forgot to change the subject. Duh! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: DBMS_STATS and CBO

think I can say that is definitely didn't run out of space; but maybe somebody walked across the space the tempfile thought it was going to get in the future. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat

RE: Anyone have a copy of DUL ??

to the datafiles is just stupid, and anyone who would allow it deserves everything they get. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: DBMS_STATS and CBO

any sparse file issues in future, I recommend you to copy the tempfiles to another name using cp, then rename back, -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: Is Cary's new book shipping now?

to. Which means you'll have to buy a new book. As for Cary's book, I have it on order at Amazon as well, but according to the site today, it's still not released. :( -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City

RE: [Q] ORACLE 9iR2 two ethernet cards, two listeners auestions?

') 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 Lee INET: [EMAIL

Tempfile weirdness

://www.orafaq.net -- Author: Stephen Lee 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

RE: Connect to a remote database without a link

information right into the select statement. Can it be done? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: Connect to a remote database without a link

meant from within SQL rather than SQL*Plus. kind regards Pete In article [EMAIL PROTECTED], Stephen Lee [EMAIL PROTECTED] writes The COPY command does NON-dblink connect to the remote database. -Original Message- -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http

RE: 9.2.0.4 anyone

Tru64 5.1A. 12 CPU box. Two different instances on the box. -Original Message- Hi! Which platform is it? I checked on one 4CPU Linux server with 160MB shared pool it defaulted to 1. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen

RE: 9.2.0.4 anyone

, because in time, the LRU and freelists get even longer, thus one scan takes more time to complete or fail. _kghsidx_count = 1 (The correct name is _kghdsidx_count) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat

RE: How to give permission

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

RE: 9.2.0.4 anyone

And for you cobol users out there: we have been told that the bug related to setting cursor_sharing=force when using cobol has been fixed in 9.2.0.4. So maybe that will help keep the 4031 bug in its box. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee

RE: Bus Error (Urgent)

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

RE: 9.2.0.4 anyone

: Stephen Lee 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: 9.2.0.4 anyone

are still stuck with by guess and by golly fiddling with the shared pool. -Original Message- Anyone have any negative experiences with 9.2.0.4 yet? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network

RE: 9.2.0.4 anyone

. There is a parameter (so I have been told) _kghsidx_count = 1 that makes the shared pool one big memory area. One of the fixes in 9.2.0.4 is to make this the default now (so I have been told). -Original Message- From: Stephen Lee Sent: Thursday, September 11, 2003 11:39 AM To: Multiple recipients

RE: OCP Architecture question

1. Maybe, maybe not. To make a point, take it to a ridiculous extreme: Suppose you have a tablespace of 100M with two rollback segments made of 1M extents sizes. Then each segment must use 2M each (minextents must be at least 2) which means either segmentcould possibly grow touse 98M if

RE: SGA

time_waited, average_wait from v$system_event order by time_waited / ttitle off -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Export 8.1.7 - Import 7.3.4

7.3.4 HPUX 32 database. The 7.3.4 import doesn't like the 8.1.7 export file. Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: OT -- Boston Globe job listings

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

RE: OT -- Boston Globe job listings

-- Author: Stephen Lee 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: OT -- Boston Globe job listings

://www.orafaq.net -- Author: Stephen Lee 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: OT -- Boston Globe job listings

No no! Not EDS. That was Ed's. As in: Ed's plumbing, welding, and database admin ( and professional dancing) -Original Message- Didn't the UK outsource their IT function to EDS? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL

RE: Off Topic Question - Update.inf file

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

RE: [stupid] vi question

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

RE: Multiple Datafiles and performance?

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

RE: Multiple DBs - Balancing Act

it will be a problem. -Original Message- How do you balance the load among your team? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Multiple Datafiles and performance?

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

RE: 9i - Dynamic SGA - SGA_MAX_SIZE

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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 happens if a remove a job that is running?

If the job is running, I think you have to kill the session running the job after removing the job. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: 9i-OCP Question

counselor insisted I gild the lily and take the exams again. I showed up that morning with no sleep, a throbbing hangover, and eyes looking like fried eggs pasted to my head... ...scored 60 points better... on 8/4/03 11:49 AM, Stephen Lee at [EMAIL PROTECTED] wrote: An invaluable

RE: Q. To RAC or go vertical

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

RE: streams comments

: http://www.orafaq.net -- Author: Stephen Lee 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: OT -- Boston Globe job listings

-- Author: Stephen Lee 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: streams comments

FAQ: http://www.orafaq.net -- Author: Stephen Lee 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: streams comments

: http://www.orafaq.net -- Author: Stephen Lee 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

RE: Off Topic Question - Update.inf file

Oh wow! And Tie Fighter too?!! -Original Message- Actually there is a Linux clone of MechWarriors -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: Finding dedicated server processes associated with a specifie

, s.osuser, s.sid, s.serial#, s.process USER PRCS, p.spid SVR PRCS from v$process p,v$session s where p.addr = s.paddr and s.username ' ' / -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City

RE: Q. To RAC or go vertical

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

RE: [stupid] vi question

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

RE: More On 10G

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

RE: drop user

Not Elizabeth Hurley ... :-))) !! -Original Message- Everything looks like a big hammer to you, doesn't it Stephen? ;) \ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services

RE: Q. To RAC or go vertical

Gig of RAM. ( yes, that is correct ). Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: One for bash experts....

: nawk: command not found bash: nawk: command not found bash: nawk: command not found bash: nawk: command not found bash: nawk: command not found ORACLE_HOME = [/oracle/app/oracle] ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED

RE: 9i-OCP Question

. Yes, I'll try again, once the lobotomy scars heal... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: One for bash experts....

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 Lee INET: [EMAIL PROTECTED] Fat City

RE: drop user

: http://www.orafaq.net -- Author: Stephen Lee 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: Any German here ? Character set

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

RE: Union quries: INTERSECT, MINUS, etc

There's nothing like a good high colonic to make you want to have kids! -Original Message- not very slick but I used MINUS yesterday to find parents with no children so as to purge them -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee

RE: Oracle on linux vs. on windows

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

RE: Recommendation for cheap HA solution

; it was not my idea... This is 9.2.0 on Sun Solaris. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: script

For something a little different, play with the attached free.sql script. -Original Message- where can i find a script to find segments which can't extend due to low of space in tablespace . -ak free.sql Description: Binary data

RE: possible to set continuation prompt in sql*plus?

to specify the prompt that shows on continuation lines (or otherwise pad it out) in sql*plus? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: RMAN used?

FAILSAFE. Oracle version 9.0.1.4.0... Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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 10G info note

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

RE: Unix root account remote access

Title: Message One possibility -- probably a slim possibility: If the remote site can hook up a console server to the box, then you connect to the console server, and it will be like you are right there at the console ... That's the theory anyway. -Original Message-From: Nelson,

RE: Physical Design Question

was talking about and for ease of testing upgrades than for any other pressing reason.) Auditors are a funny breed... they want total separation even at the expense of practicality. April Wells -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL

RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in

of it. There is some sort of checksum going on, even though it looks like ASCII -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: shell question

cat file sed '' file awk '{print}' file while read LINE; do echo $LINE; done file -Original Message- hi all , how can I read a text file and print line by line. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL

RE: Physical Design Question

://www.orafaq.net -- Author: Stephen Lee 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

RE: Interview Questions for a Unix Solaris System Admin

: Involves not allowing SUID files on the file system and not allowing root access to the NFS mount. This is a biggy ... really! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Find the table's name that using sequences

sequences but I failed. dba_sequence don't give too much info. Is there any idea? Thanks in advance Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: Find the table's name that using sequences

of the database anyway. Although if they're *really* good, it will be in a package, and it *will* show up in dba_source. Jared Stephen Lee [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2003 02:14 PM Please respond to ORACLE-L To: Multiple recipients

RE: unix shell script question

: Stephen Lee 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: should you seperate indexes from tables in seperate datafiles

-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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: dbf and cdx files

Are the dbf files dbase files? If so, I have something that you might be able to use or adapt to your purposes. -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, July 14, 2003 1:29 PMTo: Multiple recipients of list ORACLE-LSubject: dbf and cdx files I

RE: dbf and cdx files

:[EMAIL PROTECTED]Sent: Monday, July 14, 2003 4:09 PMTo: Multiple recipients of list ORACLE-LSubject: Re: dbf and cdx files Looks like foxpro files . Trying to open using odbc driver . -ak - Original Message - From: Stephen Lee To: Multiple recipients

RE: dbf and cdx files

; but it looks bad. This is probably the result of me getting distracted while playing around with different scenarios and never getting back to finish whatever idea I had started. Life is like that around here. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen

RE: Raid 0+1 vs. mirrored pairs

. -Original Message- Separating tables from indexes is one of those mythical things. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: service name, sid ..

it ( ? ) . Can some one clarify with some examples . -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: service name, sid ..

I forgot to say: the first listing is the tnsnames.ora on the client(s). -Original Message- From: Stephen Lee Sent: Wednesday, July 02, 2003 3:06 PM To: Multiple recipients of list ORACLE-L Subject: RE: service name, sid .. Example using Transparent Application Failover (TAF

RE: Performance

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

RE: printing out of Pl/SQL

You should be more environmentally conscious and pipe this through compress prior to sending it to lpt1. -Original Message- dd if=your file of=/dev/lpt1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City

RE: Connection Problem

Occasionally it lets me on. People at the other site tell me that they can connect ok Anyone know what might be causing the problem? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Materialized view

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

RE: explain plan

Message- List , does anybody have or know where I can get a script that will explain all of the columns from the plan_table? Does anybody have any suggestions for using ultxpls.sql? thanks, -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee

RE: Materialized view

mas.salesrep_id,sum(del.qty*del.price)-sum(del.discount) from sales_master mas, sales_details del where mas.transaction_id =del.transaction_id group by mas.salesrep_id. Thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL

RE: Migrating 8i OPS to RAC 9.2

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

RE: Migration to 9.2.0.3.0 (64 Bit) on Solaris 8 issues

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

RE: OEM question

texts to come up with Advanced Queuing. somehow this makes me glad i work for cheap places that don't use any of that.;-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: [Q] Script to generate grant privilege on a table?

privilege on a table and generate output for future usage? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: [Q] Script to generate grant privilege on a table?

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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 docs do say # of extents effect performance

section of disk space. The file could be scattered across the file system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: Oracle releases by the different platforms...

Say it aint so!!! I'm thinking we really need to migrate from AIX to Linux! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

  1   2   3   4   >