Hi all - just wondering if anyone had any ideas? When I think about it there's got to be a way shouldnt there?
Sorry for the delayed response. If you're using 7.0+, you can connect to the Oracle connection, then go to Data>Replace Data Source. Then, select the replacement and voila, it should work!