Verma, if you are looking for performance, consider storing your large objects outside of oracle directly on the file system. You can store a reference to the file in oracle. Filesystems are pretty good at serving large stuff quickly - works great for us! Hope that helps, BenG.
[EMAIL PROTECTED] wrote: >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
