RE: 8i CLOB data needs a labotomy

--openmail-part-0967fa64-00000001

Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT"
Content-Disposition: inline; filename="BDY.TXT"
Content-Transfer-Encoding: 7bit

John,

What are your very CLOB specific parameters such as PCTVERSION and CHUNKSIZE? Are they in-line / out-of-line CLOBS? What about your db block size? Does the problem have something to do with the way the Perl interface handles / sets default values for these? (and the internal Oracle ALTER - MOVE does a better job of it...) Last of all - how does it behave in 8.1.5 or 8.0.5 (if you have these databases around?)

John Kanagaraj
Brunei Shell Petroleum
http://www.geocities.com/john_sharmila

God so loved the world that He didn't send a committee! (See John 3:16 for details)
** Opinions expressed here are solely mine and not necessarily those of my employer **

> -----Original Message-----
> From: oracledba-digest-help
> Sent: Wednesday, 28 June, 2000 4:17 AM
> To: ORACLE-L; oracledba
> Cc: jbarron
> Subject: 8i CLOB data needs a labotomy
>
>
>

--openmail-part-0967fa64-00000001

Content-Type: application/ms-tnef; name="WINMAIL.DAT"
Content-Disposition: attachment; filename="WINMAIL.DAT"
Content-Transfer-Encoding: base64

eJ8+IsyPAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5N aWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEgAEAIgAAAFJFOiA4aSBDTE9C IGRhdGEgbmVlZHMgYSBsYWJvdG9teQDDCgEFgAMADgAAANAHBgAcAA4AIAAPAAMAOQEBAIAA AHAAAAAEAHAAEgBOAEpvaG4gSi4gS2FuYWdhcmFqAE9QRU5NQUlMOkpvaG4gSi4gS2FuYWdh cmFqIC9GSUMzMjEsT1BFTk1BSUwvbz1CUlVORUlcIFNIRUxMXCBQRVRST0xFVU1cIFNFUklB AAAAAAAAAAAA5hwBIIADAA4AAADQBwYAHAAOABsADgADADMBAQmAAQAhAAAAMEY3NThGRjc4 MzRDRDQxMTkzNjYwMDYwOTc5OTExQjMA8AYBBJAGAOQFAAADAAAAEAAAAAMAADAEAAAACwAP DgAAAAACAf8PAQAAAFUAAAAAAAAAjVVM0Ow8Ec6B/wgACbEDegEAAAALAAAAAAAAADEdT1JB Q0xFLUweNR1taW1lHjE2HUhQTUVYVDEeMTcdT1JBQ0xFLUxAZmF0Y2l0eS5jb20AAAAAHgAC MAEAAAAJAAAAT1BFTk1BSUwAAAAAHgADMAEAAAAmAAAAT1JBQ0xFLUwgL21pbWUgKE9SQUNM RS1MQGZhdGNpdHkuY29tKQAAAAMAFQwBAAAAAwD+DwYAAAAeAAEwAQAAACYAAABPUkFDTEUt TCAvbWltZSAoT1JBQ0xFLUxAZmF0Y2l0eS5jb20pAAAAAgELMAEAAAAvAAAAT1BFTk1BSUw6 T1JBQ0xFLUwgL21pbWUgKE9SQUNMRS1MQGZhdGNpdHkuY29tKQAAAwAAOQAAAAALAEA6AQAA AB4A9l8BAAAACQAAAE9SQUNMRS1MAAAAAAIB918BAAAAVQAAAAAAAACNVUzQ7DwRzoH/CAAJ sQN6AQAAAAsAAAAAAAAAMR1PUkFDTEUtTB41HW1pbWUeMTYdSFBNRVhUMR4xNx1PUkFDTEUt TEBmYXRjaXR5LmNvbQAAAAADAP1fAQAAAAMA/18AAAAAAgH2DwEAAAAEAAAAAAAABBAAAAAD AAAwBQAAAAsADw4AAAAAAgH/DwEAAABaAAAAAAAAAI1VTNDsPBHOgf8IAAmxA3oBAAAACwAA AAAAAAAxHW9yYWNsZWRiYR41HW1pbWUeMTYdSFBNRVhUMR4xNx1vcmFjbGVkYmFAcXVpY2tk b2MuY28udWsAAAAeAAIwAQAAAAkAAABPUEVOTUFJTAAAAAAeAAMwAQAAACsAAABvcmFjbGVk YmEgL21pbWUgKG9yYWNsZWRiYUBxdWlja2RvYy5jby51aykAAAMAFQwBAAAAAwD+DwYAAAAe AAEwAQAAACsAAABvcmFjbGVkYmEgL21pbWUgKG9yYWNsZWRiYUBxdWlja2RvYy5jby51aykA AAIBCzABAAAANAAAAE9QRU5NQUlMOm9yYWNsZWRiYSAvbWltZSAob3JhY2xlZGJhQHF1aWNr ZG9jLmNvLnVrKQADAAA5AAAAAAsAQDoBAAAAHgD2XwEAAAAKAAAAb3JhY2xlZGJhAAAAAgH3 XwEAAABaAAAAAAAAAI1VTNDsPBHOgf8IAAmxA3oBAAAACwAAAAAAAAAxHW9yYWNsZWRiYR41 HW1pbWUeMTYdSFBNRVhUMR4xNx1vcmFjbGVkYmFAcXVpY2tkb2MuY28udWsAAAADAP1fAQAA AAMA/18AAAAAAgH2DwEAAAAEAAAAAAAABRAAAAADAAAwBgAAAAsADw4AAAAAAgH/DwEAAABV AAAAAAAAAI1VTNDsPBHOgf8IAAmxA3oBAAAACwAAAAAAAAAxHWpiYXJyb24eNR1taW1lHjE2 HUhQTUVYVDEeMTcdamJhcnJvbkB3aW5kcml2ZXIuY29tAAAAAB4AAjABAAAACQAAAE9QRU5N QUlMAAAAAB4AAzABAAAAJgAAAGpiYXJyb24gL21pbWUgKGpiYXJyb25Ad2luZHJpdmVyLmNv bSkAAAADABUMAgAAAAMA/g8GAAAAHgABMAEAAAAmAAAAamJhcnJvbiAvbWltZSAoamJhcnJv bkB3aW5kcml2ZXIuY29tKQAAAAIBCzABAAAALwAAAE9QRU5NQUlMOmpiYXJyb24gL21pbWUg KGpiYXJyb25Ad2luZHJpdmVyLmNvbSkAAAMAADkAAAAACwBAOgEAAAAeAPZfAQAAAAgAAABq YmFycm9uAAIB918BAAAAVQAAAAAAAACNVUzQ7DwRzoH/CAAJsQN6AQAAAAsAAAAAAAAAMR1q YmFycm9uHjUdbWltZR4xNh1IUE1FWFQxHjE3HWpiYXJyb25Ad2luZHJpdmVyLmNvbQAAAAAD AP1fAQAAAAMA/18AAAAAAgH2DwEAAAAEAAAAAAAABgNEAQOQBgDwAwAAJgAAAAsAAgABAAAA CwAjAAAAAAADACYAAAAAAAsAKQAAAAAACwArAAAAAAADAC4AAAAAAAIBMQABAAAAAQAAAAAA AAADADYAAAAAAEAAOQDAe+qZyuC/AR4AQgABAAAAEgAAAEpvaG4gSi4gS2FuYWdhcmFqAAAA QABIALDbDJvK4L8BHgBwAAEAAAAeAAAAOGkgQ0xPQiBkYXRhIG5lZWRzIGEgbGFib3RvbXkA AAACAXEAAQAAABYAAAABv+DKl833j3UQTIMR1JNmAGCXmRGzAAAeABoMAQAAABIAAABKb2hu IEouIEthbmFnYXJhagAAAAIBHQwBAAAATgAAAE9QRU5NQUlMOkpPSE4gSi4gS0FOQUdBUkFK IC9GSUMzMjEsT1BFTk1BSUwvTz1CUlVORUlcIFNIRUxMXCBQRVRST0xFVU1cIFNFUklBAAAA HgAeDAEAAAAJAAAAT1BFTk1BSUwAAAAAHgAfDAEAAABFAAAASm9obiBKLiBLYW5hZ2FyYWog L0ZJQzMyMSxPUEVOTUFJTC9vPUJSVU5FSVwgU0hFTExcIFBFVFJPTEVVTVwgU0VSSUEAAAAA HgBCEAEAAAABAAAAAAAAAAMAgBD/////QAAHMCDb6eXJ4L8BQAAIMCDb6eXJ4L8BAwDeP69v AAALAACACCAGAAAAAADAAAAAAAAARgAAAAADhQAAAAAAAAMAAoAIIAYAAAAAAMAAAAAAAABG AAAAABCFAAAAAAAAAwAIgAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAADABaACCAGAAAA AADAAAAAAAAARgAAAAARhQAAAAAAAAMAJ4AIIAYAAAAAAMAAAAAAAABGAAAAAFKFAADjFQAA HgAogAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOC41AAsAKYAIIAYAAAAAAMAA AAAAAABGAAAAAAaFAAAAAAAACwAtgAggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADAC+A CCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAB4APYAIIAYAAAAAAMAAAAAAAABGAAAAADaF AAABAAAAAQAAAAAAAAAeAD6ACCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAA HgA/gAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAAsASoALIAYAAAAAAMAA AAAAAABGAAAAAACIAAAAAAAACwBMgAsgBgAAAAAAwAAAAAAAAEYAAAAABYgAAAAAAAAeAD0A Received on Wed Jun 28 2000 - 01:32:20 CDT