How are others doing this? Do you create linux accounts for others to scp onto the box? Samba (admins are frowning on this idea). Our users really want to be able to drag and drop to a windows share if possible.
Thanks for any ideas..
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?
okay I will think about the problem.
Please describe a little bit more how your application or may be your workflow will work.
Which tools you would like to use and so on?
For me at makes no sense that so much users will do an scp.
yes DBFS is the correct tool for this.
More details can be found here
Configuring DBFS on Oracle Database Machine [ID 1054431.1]
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