This content has been marked as final. Show 7 replies
Yes, in our Exadata environment the DBFS was used for the whole migration which was more than 70 databases.
Most of the migrations was done via expdp/impdp and we use the DBFS for the dumpfiles.
That the DBFS was used as Windows Share is really new for me. I doesn't heard actually from those implementations.
But may me what about external tables.
May be this would be another way to do the load.
Do you think about external tables?
Sure external tables .. but where to place the flat files? On the exadata nodes? if so do you create accounts and expect users to scp to them? We have a bunch of windows users who expect to just drag and drop files on a share and load them into Exa. Just looking for a convenient and secure way to do this.
You certainly dont want all of your company able to access those flat files while they sit on an open share.
Thoughts anyone on this?
If you're allowing perhaps less-technical users to perform their own data loads, you may want to consider some infrastructure around validating the submitted data, ensuring the users are authorized, keeping the users separate, and cleaning up the files. Perhaps a web-based file upload app, or something involving dbms_file_transfer?
Use an scp client like winscp... i believe it can integrate with windows such that it can add a shortcut in the sendto list or register for scp::// and sftp:// urls....
This however is nt really an exadata specific question....
I do not believe dbfs will work with samba since it does not work with NFS.
Edited by: robinsc on Mar 12, 2013 11:29 AM