possible to load a string with paragraphs?

. Thanks for any inputs. _ Check out the coupons and bargains on MSN Offers! http://shopping.msn.com/softcontent/softcontent.aspx?scmId=1418 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd INET

RE: commit for triggers

table and my change subsequently fails? _ Learn how to choose, serve, and enjoy wine at Wine @ MSN. http://wine.msn.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd INET: [EMAIL PROTECTED] Fat

commit for triggers

, serve, and enjoy wine at Wine @ MSN. http://wine.msn.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

sql question

t_number= s.project_number AND b.task_number = s.task_number) _ High-speed users—be more efficient online with the new MSN Premium Internet Software. http://join.msn.com/?pgmarket=en-us&page=byoa/prem&ST=1 -- Please see the offi

Re: insert in batch loading

exed before load and create them afterwards with nologging. Even if you do 2) you will save a lot of time and have a lot less redo. Regards, Janne! David Boyd wrote: Janne, Thanks for your reply. We have 6 redo log switchings during inserting a table that has 1 million records. Our redo

Re: insert in batch loading

that would be practical, don't you think? On 11/25/2003 11:59:26 AM, David Boyd wrote: > Janne, > > Thanks for your reply. > > We have 6 redo log switchings during inserting a table that has 1 million > records. Our redo log size (100 MB) dominates the checkpoint frequen

Re: insert in batch loading

t;[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: insert in batch loading Date: Tue, 25 Nov 2003 08:19:26 -0800 David Boyd wrote: Hi All, We have some batch loading jobs that truncate the tables first, then insert i

Re: insert in batch loading

:44:33 -0800 How big are yor redo logs? How many o them do you have? On 11/25/2003 10:29:37 AM, David Boyd wrote: > Hi All, > > We have some batch loading jobs that truncate the tables first, then insert > into the tables as select from tables through database link. Those jobs run &

insert in batch loading

orafaq.net -- Author: David Boyd 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 ma

Re: database terminated

19:33 -0800 there is an ora-600 query screen on metalink. it has limited amounts of information. ora-600 is not documented anywhere else. you need toopen a TAR immediately. ora-600 is not well documented. if you dont have a support plan, you may have a problem. > > From: "David Boyd

database terminated

limit? Get Hotmail Extra Storage! http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and

Re: Refresh option for Materialized view , want to use it during refresh - for

1 product_family, > > > > mc.segment2 product_type > > > >FROM [EMAIL PROTECTED] mcs, > > > > [EMAIL PROTECTED] mc, > > > > [EMAIL PROTECTED]mic, > > > > [EMAIL PROTECTED] msi > > > >where 1=1 > > > >and mc.structure_

Re: Refresh option for Materialized view , want to use it during refresh - for

AND msi.item_type IN ('ATO MODEL','CONFIG SPARE','CONFIG > >SUB','FEATURE PACK','PRODUCT LIST>$0','PTO MODEL','SPARE') > >and msi.inventory_item_status_code IN > >('ENABLE-MAJ',

RE: Refresh option for Materialized view , want to use it during refresh - for

even during refresh period. Thanks in advance. With Warm Regards Siddharth Haldankar Zensar Technologies Ltd. Cisco Systems Inc. (Offshore Development Center) # : 091 020 4128394 [EMAIL PROTECTED] [EMAIL PROTECTED] _ Cheer a special someone with a fun Halloween eCard from American Greetings!

Re: ORA-02049: timeout: distributed transaction waiting for lock

waiting for lock > > We are in Oracle 8.1.7.4 and SunOS 5.8. We take the default value for > DISTRIBUTED_LOCK_TIMEOUT . > > Dave > > _ > Get a FREE computer virus scan online from McAfee. > http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > > -- > Pl

RE: unique index

cates when we reloaded the same 11839 records into the table? Dave _ Send and receive larger attachments with Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

unique index

larger attachments with Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

ORA-02049: timeout: distributed transaction waiting for lock

MEOUT . Dave _ Get a FREE computer virus scan online from McAfee. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd INET: [EMAIL PROT