I have the following questions in regards to oracle, here is my story:
I have a production database server data warehouse, which has 2 schemas. We
do a CTAS on a daily basis in order to keep data the same, we also have a in
house application which then connects to the database, that gets switch between
schemas during jobs, etc. Now we are getting a new unix server which I will be
installing oracle on it. So I will have 2 servers which with 1 schema ...
1.Can I do a CTAS between 2 servers?
2.Also we are thinking in putting between the 2 servers a (like virtual) on a
disk array (kind of flowting server?) is this possible?
3.Is mirriring possible in this case?
4.should I use oracle distributed database?
5. what about replication server's ?
can you
please help me with some of those options
Thanks
maria
Received on Mon Feb 17 2003 - 15:42:29 CST
