Verma, you could map the file directory to your web server, then it could be served to anyone to whom you provide access. But that may not be what you are looking for. Hope that helps, BenG.
[EMAIL PROTECTED] wrote: >Can I modified the file being stored as a reference in oracle? >I read, using BFILE type allows file to be used as read-only. >Storing file on file system will make it server dependent. I have to access >that file from multiple servers. >Any thought. > > >-----Original Message----- >From: Ben Groeneveld [mailto:[EMAIL PROTECTED]] >Sent: Friday, August 02, 2002 12:04 PM >To: JRun-Talk >Subject: Re: Storing xml in oracle 8i > > >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 >> > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
