A BFILE datatype is a pointer to
an external binary file. Before BFILEs can be used in a database, a directory alias needs
to be created with the create directory command that specifies a prefix containing the
full directory path where the BFILE target is stored.
DBMS_PIPE can communicate with any 3GL language that Oracle supports, such as
C++, Ada, Java, or COBOL, and exchange information.
UTL_MAIL, a new package in Oracle 10g, allows a PL/SQL application to send e-mails
without knowing how to use the underlying SMTP protocol stack.
?–
?–
?–
?–
?–
24 Oracle Database 11g DBA Handbook
When using an external file as a data source, for either input or output, a number of cautions
are in order. The following should be carefully considered before you use an external data source:
The database data and the external data may be frequently out of synch when one of the
data sources changes without synchronizing with the other.
It is important to make sure that the backups of the two data sources occur at nearly the
same time to ensure that the recovery of one data source will keep the two data sources
in synch.
Script files may contain passwords; many organizations forbid the plain-text representation
of any user account in a script file. In this situation, operating system validation may be a
good alternative for user authentication.
You should review the security of files located in a directory that is referenced by each
DIRECTORY object.
Pages:
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95