Antw: RE: Little competition

. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Antw: RE: Little competition

') 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: Guido Konsolke INET

OT Re: Re: rebuilding indexes - sure to cause a ruckus

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

Antw: export with query date field

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: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Antw: Question about datatypes

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

Antw: RE: I wanna know how Oracle uses file organization in

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

Re: Desupport of RBO

to rewrite the whole app. Lucky me: enough work for the next years. Greetings, Guido [EMAIL PROTECTED] 07.10.2003 01.34 Uhr First time I've seen this note: 189702.1 Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City

Re: guidance

my 9i performance tuning exam on the first . Any advice you all want to give me ? Pretty nervous about it. Sure would appreciate your guidance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services

Antw: RE: select distinct values

the FIRST function of 9i. Oh well. INSERT INTO saved_messages ... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke

Antw: Re: ** trigger behaviour

-- Author: Guido Konsolke 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

Antw: wrapping packages

Even on a Windows client: the thing is called WRAPxx.exe (version dependent). [EMAIL PROTECTED] 19.09.2003 14.37 Uhr how can I wrap package bodies in oracle8i -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network

Antw: Move SQL Server Tables to Oracle

ideas how to do it. I have no idea ... rgds G - Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network

Re: CORRECTION RE: RE: Re: SQL help needed

see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

OT Re: RE: What is a large database?

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

Antw: Weird behavior with VARCHAR fields (was: ORA-01403

FROM TTDSLS805501 WHERE t$user = 'exped9'; statement return 0 rows in the first place? Fermin. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Antw: Database Link

: 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: Listener problem on one client computer

changed since 5 days. Best regards and thank's in advance, Damien -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Antw: Building dynamic sql that will do CSV

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

RE: RE: display x square

-- Author: Guido Konsolke 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: Query results to .csv

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

Antw: OT: Anybody want a job in Tampa FL

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

Re: your account aacaogro

Haven't met a single virus or worm that made it through our security... Maybe GroupWise isn't popular enough to get those mean mails working. Almost off to Mylady and the kids, Guido -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL

Antw: Take an Oracle 8.1 export file back to an Oracle 7.1

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

Antw: Move selected tables

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

Antw: 8i ORA-1652 after upgrading from AIX 4.3.3 to 5.1

that our application cannot commit any transactions (or so I am finding in my tests). Help. The warehouse needs to be in production tomorrow! Thanks, Saira -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network

Antw: RE: Question about the list

://www.orafaq.net -- Author: Guido Konsolke 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: Antw: Re: data is skewed - what does it mean ?

their computers like cars. They know how to drive them, but are clueless about how they work. We're still from outer space. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Antw: Re: data is skewed - what does it mean ?

obscene language by stubbornly refusing to use and index which was utilized when RBO was used. I believe that the vast majority of old and balding DBA geezers like me can make the same claims. Thus the name. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke

RE: Question about the list

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

Antw: Re: data is skewed - what does it mean ?

Hi Mladen, nice one. Never heard that. vbg Still lol, Guido [EMAIL PROTECTED] 25.07.2003 07.54 Uhr (snipped) chapter about indexes, statistics and the Curses Based Optimizer, am I right) (snipped even more) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido

Antw: SQL question : How to retrieve the File_name without

. eg :'/oracle/d0/data/user.dbf' -- user.dbf Maybe using translate function ? Thank in advance ! Philippe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: RE: Antw: SQL question : How to retrieve the File_name

? -:) Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Guido Konsolke Sent: Wednesday, July 23, 2003 3:14 AM To: Multiple recipients of list ORACLE-L Hi Philippe, eat this: select substr('/oracle/d0/data/user.dbf',instr('/oracle/d0/data/user.dbf','/',- 1)+1) from dual; hth

Antw: RE: piece-wise return of records from table

://www.orafaq.net -- Author: Guido Konsolke 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

Antw: comments on 8i's autonomous PL/SQL block?

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

RE: piece-wise return of records from table

to be returned to the front end then records 11 to 20 so on ... How may the above be optimally possible ? SQL or PL/SQL any for it ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network

Antw: Howto Unsubscribe from this list

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

Insert 8000 Byte into LONG column

long'. Does anyone have an idea how I can get the data into the table? Any help (except: change the datatype ;-)) is appreciated. Greetings, Guido -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services

Antw: Re: Insert 8000 Byte into LONG column

-- Author: Guido Konsolke 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

Antw: RE: Insert 8000 Byte into LONG column

an idea how I can get the data into the table? Any help (except: change the datatype ;-)) is appreciated. Greetings, Guido -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Antw: Privileges and PL/SQL code

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