Table 14-1. Storage options for Oracle Multimedia and Oracle Text
Type Storage options
Text/images VARCHAR2
BLOB
CLOB
VARCHAR
CHAR
LONG
LONG RAW
Object attribute
Master-detail stores (in which the master table identifies the text or image and the detail table
contains the content)
BFILEs
URLs that point to content
DICOM
Extensibility Features and Options | 325
Oracle Database 10g was enhanced to store large documents of up to 128 terabytes
in LOBs. Oracle Database 11g Multimedia object type media size limits are extended
to those of BLOBs (between 8 and 128 terabytes). Also introduced in this version of
Multimedia is a new, higher-performing BLOB implementation accessible via Oracle??™s
SecureFiles.
Oracle Multimedia and Oracle Text support a number of commonly used formats:
??? Documents can be indexed while stored in formats such as ASCII, Microsoft
Word, Excel, and PowerPoint, WordPerfect, HTML, XML, and Adobe Acrobat
(PDF).
??? Audio formats supported include AU, AIFF, AIFF-C, WAV, MPEG1, MPEG2,
and MPEG4 audio formats.
Pages:
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706