Poor performance importing LOBS

mail2web - Check your email from the web at http://mail2web.com/ . -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: SV: SQL Question

egards -!-Johan -!- -!- -!- -!-> -Ursprungligt meddelande- -!-> Fran: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]For Henrik Ekenberg -!-> <[EMAIL PROTECTED]> -!-> Skickat: den 28 januari 2003 07:44 -!-> Till: Multiple recipients of list ORACLE-L -!-> Amne: SQL Questio

SQL Question

- There's fun in being serious. -- Wynton Marsalis Henrik EkenbergAnoto AB -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henrik Ekenber INET: [EMAIL PROTECTED]>" <[EMAIL PROTECTED] Fat City Ne

RE: SQLPlus Substitution Variables

You can use the SQL*Plus commands DEFINE to provide values for variables and UNDEFINE to "reset" them. Karen Original Message: - Date: Wed, 15 Jan 2003 07:04:18 -0800 To: [EMAIL PROTECTED] I am using substitution variables in SQLPlus, but don't want to be pro

Dead shared server msgs in alert log + core dumps

- mail2web - Check your email from the web at http://mail2web.com/ . -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

[no subject]

HELP

OMF question

Hi !   I 've a question regarding OMF realted parameter CREATE_DB_ONLINE_LOG_N. Now y is'nt this parameter mentioned in the list of parameters in the Oracle Documenttion cd of 9i. Is it obsolete or oracle does not recommend it's use.   regards Tc  

bioinformatics

is there any strategy from oracle in bioinformatics? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: Install Oracle 8i on Windows XP?

versations? Original Message: - Date: Mon, 29 Jul 2002 10:43:29 -0800 To: [EMAIL PROTECTED] Eric, Need I remind you that this is an Oracle forum? mail2web - Check your email from the web at http://ma

shutdown abort not advised on NT, memory probs

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

RE: SMP on windows2000

smpfaq.htm Original Message: - Date: Thu, 25 Jul 2002 10:13:49 -0800 To: [EMAIL PROTECTED] I've been wondering same, logged an iTAR. Will keep you in the loop. background (same old crap, sorry, nothing specific): http://www.winntmag.com/Art

RE: (Fwd/2)

mposed for corporate executives to sign off on the validity of their accounting. regards, ep Original Message: - Date: Tue, 16 Jul 2002 08:53:34 -0800 To: [EMAIL PROTECTED] Eric, Have you considered the POSSIBILITY that Larry sold the stock without the benefit of insider trading,

oracle and shared scsi raid array

ated. TIA Danny Hughes DBA Knobias.com 601-978-3399 x103 [EMAIL PROTECTED] www.knobias.com --CTAMBEFQWATMTARUCPBS Content-Type: multipart/related; boundary="DQTUDDRTJMVXEMHYHHMP" --DQTUDDRTJMVXEMHYHHMP Content-Type: text/html; charset=windows-1252 Content-Trans

Re: Software Vs Hardware Firewall.

nbergAnoto AB Direct +46 (0)8 410 78 577 Mäster Samuelsgatan 56 Mobile +46 (0) 733 478 577 111 21 Stockholm, Sweden www.anoto.com Switchb +46(0)8 410 78 500 E-mail :[EMAIL PROTECTED]

Replication trouble

Any advice ? Regards HEnrik -- ------- E-mail :[EMAIL PROTECTED] Fax +46 (0)8 410 78 501 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED]>" <[EMAIL PROTECTED] Fat City Net

Re: Names server

://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED]>" <[EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Linux for Big(ish) Databases

Hi, Why using Linux on Sparc ? Solaris is free up to 8 cpus. Or is the Oracle price different ? Regards HEnrik -- E-mail :[EMAIL PROTECTED] Fax +46 (0)8 410 78 501 Sweden On Mon, 4 Mar 2002, Steven Lembark wrote: -!- -!- -!-> We've got a new database to put togethe

Re: Clash of the DBs in eWeek

Hi, I have also an other question. Do you you why they did not test postgressql ? Regards Henrik -- --- E-mail :[EMAIL PROTECTED] On Thu, 28 Feb 2002, Jesse, Rich wrote: -!-Anybody happen to see the cover story on

Linux Cluster

-- --- There's fun in being serious. -- Wynton Marsalis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED]>" <[EMAIL PROTECTED] Fat City Network Services-- (85

Free dbs / Mysql Ver 2

good or bad history ? -!- -!- -!- -!- -!-Regards -!-HEnrik -!- -!- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED]>" <[EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

Free dbs / Mysql

-- Author: Henrik Ekenber INET: [EMAIL PROTECTED]>" <[EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yo

RE: help

Title: help Does this mean that I am no longer on the mailing list? Thanks you for your help Mer -Original Message-From: Boag, Merridy [SMTP:[EMAIL PROTECTED]] [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 18 December 2001 10:26To: Multiple recipients of list ORACLE-LSubject

RE: help

Title: help Please remove me from the mailing list, Thank you Mer -Original Message-From: Boag, Merridy [SMTP:[EMAIL PROTECTED]] [mailto:[EMAIL PROTECTED]]Sent: Tuesday, 18 December 2001 10:11To: Multiple recipients of list ORACLE-LSubject: help HELP

help

Title: help HELP ** [This message and any attachment is confidential between the sender and the person it is intended for. If we have sent you this message by mistake, please let us know by return email, and erase all copies of this message and its attachments. Thank you.]

Bind Variables

d variables and what their experiences are. TIA Danny Hughes DBA Knobias.com [EMAIL PROTECTED] www.knobias.com --HALPYZPZYFFYCGAKLKOY Content-Type: multipart/related; boundary="KMQGUMGTJRAMPYVFBAEF" --KMQGUMGTJRAMPYVFBAEF Content-Type: text/html; charset=windows-12

Info request for installing Ora 7.3 on AIX 4.1

FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] 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

How to install the O9i cluster DB on a PC

a similar, but extended, step (5). Have fun, Luca Canali OCP-DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: Master/master with diff username possible ?

he usual workaround is to replicate -!-to the same schema and then use synonyms. -!- -!-HTH, -!- -!--- Anita -!- -! "Henrik Ekenberg <[EMAIL PROTECTED]>" -!-<[EMAIL PROTECTED]> wrote: -!-> Hello, -!-> -!-> We are running 8.1.7 on Solaris 8 on E4500. -!-> We need to rep

Re: advanced queuing

uses AQ as the -!-> propagation mechanism for asynchronous parallel -!-> propagation (serial and synchronous use the two-phase -!-> commit process). Or are you asking if anyone has -!-> written their own custom replication using AQ? -!-> -!-> HTH, -!-> -!-> -- Anita -!-> -!->

Master/master with diff username possible ?

nberg Anoto AB E-mail :[EMAIL PROTECTED] Tel +46 (0)8 410 78 500 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED]>" <[EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: JMS vrs AQ

. -- Vernon Law Henrik Ekenberg Anoto AB Direct+46 (0)8 410 78 577 Vasagatan 7 Mobile+46 (0)733 478 577 111 20 Stockholm, Sweden www.anoto.com Switchb. +46 (0)8 410 78 500 E-mail :[EMAIL PROTECTED

Re: JMS vrs AQ

Switchb. +46 (0)8 410 78 500 E-mail :[EMAIL PROTECTED] Fax +46 (0)8 410 78 501 On Mon, 30 Jul 2001, Christopher Spence wrote: -!-I was wondering if anyone has compared performance of JMS and AQ, used -!-both, or know of some good documents. -!- -!-We currently use JMS, which I have

Out of office until Tuesday 26th June

I will be on annual leave until Tuesday 26th June. For matters that cannot wait until then, please email Ray Feighery at [EMAIL PROTECTED] or phone +61 2 8437 6311 Thanks and regards Jeffrey Lim Infrastructure Consultant RecruitASP Pty Ltd PO Box 300, St Leonards New South Wales 1590

Upgrade one Site

E-mail :[EMAIL PROTECTED] Fax +46 (0)8 410 78 501 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED]>" <[EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, C

Re: stupid question about indexes and partitions

0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools & Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: h

Re: what to put in place of null

- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult ([EMAIL PROTECTED]) INET:

Re: Oracle Standards Document Sought

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

Re: V$transaction query?

see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult ([EMAIL PROTECTED]) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Intern

Re: foreign key

+44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools & Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L

Re: LDAP/OID

.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult ([EMAIL PROTECTED]) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: V$transaction query?

iole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult ([EMAIL PROTECTED]) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: cannot drop snapshot with partition.

hen the -!-snapshot was renamed, is probably to log a tar with -!-support so they can walk you through correcting the -!-data dictionary corruption. This is not something I'd -!-advise trying on your own unless you can afford to -!-lose this db. -!- -!-HTH, -!- -!--- Anita -!- -!- -! &qu

Re: Connection auditing

--- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City

RE: Mean/Median

) || -Original Message- || From: Pat Hildebrand [mailto:[EMAIL PROTECTED]] || Sent: Monday, May 14, 2001 10:56 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: Mean/Median || || || || > || > Any scripts (sql or pl/sql) out there to compute various || statistical

RE: ASP Assistance

that My_Template is set to 'template_o'. If I run with now lines commented, My_Template winds up blank. What am I doing wrong? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Rogge INET: [EMAIL PROTECTED]

RE: Installing Oracle 8.1.6 Client on Solaris without x-windows

Title: RE: Installing Oracle 8.1.6 Client on Solaris without x-windows Thanx! This buggers up my day, but still - thanx -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Monday, April 09, 2001 1:05 PMTo: 'Johan Locke@iCommerce '; 'Multiple rec

Installing Oracle 8.1.6 Client on Solaris without x-windows

ta i-Commerce Internet Services Direct Line: +27 11 516 5343 mailto:[EMAIL PROTECTED] http://www.didata.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Locke@iCommerce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San D

Funny Error... Any Ideas what the hell is happening here? Trace F

Hi All Funny Error... Any Ideas what the hell is happening here... Kind Regards Johan Locke http://www.JohanLocke.co.za Certified Oracle 8 & 8i DBA Certified Oracle Developer Dimension Data i-Commerce Internet Services Direct Line: +27 11 516 5343 mailto:[EMAIL PROTE

RE: Re-claiming the space from Table after deleteion

size & high activity and > online use of the tables]. > >Kind Regards and thanks to all there, > > >Rafi Ahmad > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: > INET: [EMAIL PROTECTED] > >Fat

RE: LONG to char

sistant Datatypes - which I can understand) Any ideas on how to get around this? Regards JL -----Original Message- Sent: Tuesday, February 20, 2001 5:23 PM To: [EMAIL PROTECTED] Johan, What do you exactly want to do? If you could explain it in more detail, I might be able to help, at least

LONG to char

Anybody have any Idee how to conevrt a LONG datatype to char/varchar Regards JL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Locke@i-Commerce Services INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Which is faster?

e contr_id=Variable2; Thanks in advance. Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet ac

RE: Truncate in a procedure?

5:50 AM To: Multiple recipients of list ORACLE-L Hi, I wanted to let u know that when u issue a truncate command, it will issue a implicit commit internally. This may be something which u would not like to have in a transaction. Just a FYI.. Regards Rajagopal Venkataramany --- "Smith,

RE: When you should use NOLOGGING while creating indexes

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

RE: Renaming a Column

e to rename a column.You can instead > use alias for that column name in your queries. > Or you have to create a new table from existing one > Drop existing table.And recreate a table by > selecting from new table. > > Regards > Bipin > --- Heikki Jantunen <[EMA

RE: Renaming a Column

Sorry sorry ID-10-T error Cheers JL -Original Message- Sent: Wednesday, February 14, 2001 9:19 AM To: '[EMAIL PROTECTED]' Wait wait wait... Yes you can rename a column in 8i, it just depends to what value your compatibility parameter is set Regards JL -Origin

RE: can not create database by dbassist

Finalize me queue lock: Waiting to be notified: "Finalizer thread" (0x8b658) Monitor registry: owner "Thread-4" (0xcada28, 1 entry) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Netwo

RE: Renaming a Column

n.You can instead use alias for that column name in your queries. Or you have to create a new table from existing one Drop existing table.And recreate a table by selecting from new table. Regards Bipin --- Heikki Jantunen <[EMAIL PROTECTED]> wrote: > Hi all, > > I need to rename some

RE: Off Topic: Row Locking - Row Id

your risk" "Johan Locke@i-CommeTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> rce Services"cc: rce Services"cc:

RE: Off Topic: Row Locking - Row Id

ws down the > processing tremendously. Conversly, if I could use the user's web session > termination, which will terminate the database session, to make oracle > release the lock on that row it makes my life a lot easier. > > About 90% of the people will access the site w

RE: Off Topic: Row Locking - Row Id

00 0 Hope this helps!! Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA "This is my opinion and does not bind my employer. Use at your own risk" "Johan L

RE: Off Topic: Row Locking - Row Id

which is locked in every table. and can give u the desired value for each row.. try select col1, col2,., rowid from tablename; saurabh - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, February 12, 2001 10:35 AM > Hi > > A

Off Topic: Row Locking - Row Id

DBA "These are my opinions and does not bind my employer. Use at your risk" elkinsl@flash .net To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc:

RE: Submitting a URL to Search engines

-600-7-006 Fax: (011) 782-9313 Email: [EMAIL PROTECTED] This message may contain information which is confidential and subject to legal privilege. If you are not the intended recipient, you may not peruse, use, disseminate, dis

RE: Oracle startup script for Solaris

Johan Locke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Locke@i-Commerce Services INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Oracle startup script for Solaris

INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [E

Sql*Loader

e see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Locke@i-Commerce Services INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --