Re: DBFS or ACFS for Flat Files and Dump Files
Date: Fri, 29 Aug 2014 06:54:13 -0600
Message-ID: <540077F5.5020006_at_gmail.com>
I find it interesting that, on Exadata, Oracle says yes to DBFS and (until GI 12.1.0.2) said no to ACFS.
https://blogs.oracle.com/RobertGFreeman/entry/exadata_support_for_acfs_and
And for Exadata, it is the only real way to hold these staging files. Works like a charm and is the best practice.
As far as I'm concerned, the DBFS is simply the latest evolution to the oradav capability that has allowed us to 'mount the database table as a file system' since Oracle8i. It has had many years to mature and become robust, but the concept is from the late 90s.
However, dbfs_client is only available on Linux.
/Hans
On 29/08/2014 3:12 AM, Chitale, Hemant K wrote:
> DBFS or ACFS for Flat Files and Dump Files
>
> Are there organisations that have the courage to use DBFS or ACFS to hold
>
> (a) Flat Files to be interpreted as External Tables
>
> (b) Dump Files to be transferred to other databases
>
> What would be the objections to using storage on the Database Server
> (asopposedto NFS) ?
>
> Hemant K Chitale
>
>
> This email and any attachments are confidential and may also be
> privileged. If you are not the intended recipient, please delete all
> copies and notify the sender immediately. You may wish to refer to the
> incorporation details of Standard Chartered PLC, Standard Chartered
> Bank and their subsidiaries at
> https://www.sc.com/en/incorporation-details.html.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 29 2014 - 14:54:13 CEST