We’re using TOAD 12 to manage our Oracle 11g database which is used for static analysis -load data, analyze, load data, analyze, repeat (vs Transactional)…
We would like to create a “mini Warehouse” and agggregate our data for comparative analysis. We will be using the same hardware, howeever we have a separate drive array available that I would like to utilize.
Since they will be on the same machine, I dont see any advantage to creating anothe Oracle instance, nor do I know how. Please correct me if there is an advantage to two Oracle instances on the same machine (sounds like a mess, and with licensing as well!)
In Toad, I can create a new tablespace and click on the tab to add a datafile. If I click on the browse button there, it brings up a grid of all my exisitng datafiles. My current datafiles are on the E:\drive and I wish the new ones to be on the F:\drive. How can this be done?