Hi All, Has anybody ever faced a challenge to store bigger size xml or any other file in the oracle 8i database. I tried using the folloing schema- CREATE TABLE ADVT_XML ( XML_NAME VARCHAR(32), XML_DATA CLOB) STORAGE (INITIAL 10M NEXT 10M) TABLESPACE ASI_DATA LOB (XML_DATA) STORE AS advt_xml_lob (TABLESPACE asi_test DISABLE STORAGE IN ROW STORAGE (INITIAL 5M NEXT 5M) CHUNK 32 PCTVERSION 0 NOCACHE LOGGING );
But I could save only 9k out of 15k file. And took almost 3 minutes to save. Has anybody ever done this? Thanks ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
