Our environment :
Dev on SQL Server/NT (about 35GB)
Test (Pre prod) and Prod in Oracle/IBM Aix
DTS Tool (to transfer data)
We shall be doing some data transformations between SQL server and into Oracle about 35GB. I would like to prepare myself with an environment to suit this kind of data load. Can any of you please give any pointers to where all, I should be careful or Points of failures happen. eg., RBS, Datafiles (how many to allocate, size limitations, extensibility etc., and what is the best configuaration and SGA allocation and so on.
Please let me know for any specific Qns on my environment and I can post it here.