OraFAQ Forum: SQL & PL/SQL » Approximate 50MB files per day to be saved in Oracle Database

Home » SQL & PL/SQL » SQL & PL/SQL » Approximate 50MB files per day to be saved in Oracle Database (Oracle 11gR2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Approximate 50MB files per day to be saved in Oracle Database [message #676319]

Thu, 30 May 2019 06:38

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Hi Experts,

I have a requirement to store files(text, PDF, scan copies, images) per transaction for a customer. This can result in 50MB files per day and according to the archive policy, I have to store the data for 7 years. Application is built on the Oracle database, and the first thing comes to my mind is the BLOB store. Has anybody faced this situation, can you please suggest the best option. I have below option in mind which I have to read and dig in more, appreciate if anybody has done this and faced any issues.

1. Oracle DBFS
2. Oracle BFILE with deduplication, compression, and encryption through Internal-LOB storage (like SecureFile)

Thanks,
SRK

Report message to a moderator

[Message index]

		Approximate 50MB files per day to be saved in Oracle Database By: srinivas.k2005 on Thu, 30 May 2019 06:38
		Re: Approximate 50MB files per day to be saved in Oracle Database By: Bill B on Mon, 03 June 2019 12:31

Previous Topic:	select START_TIME = TO_DATE returns 0
Next Topic:	Combining 3 queries into 1

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 17:33:30 CDT 2024