Using External Table on Windows RAC ACFS
One of my customer is using Oracle RAC (126.96.36.199) on Windows 2012. This is might not be the most ideal setup I’ve ever seen, but it works and we’ll leave it by that.
One of the side effects of using Oracle RAC on Windows is that some of the basic things I am used to do when using RAC on Linux (for example) is behaving differently when it comes to windows. Here is a quick example for that.
I was asked by the customer to create an external table using a fixed-record file. This should be easy enough, right? Well, yeah – but we need to consider that we might connect to the database from either node so we need to put the file on a shared storage.
The customer is using ASM for his RAC so what better solution we have than using ACFS configured on top of the ASM?