View Single Post
  #1 (permalink)  
Old August 14th, 2008, 20:44
sknmail@rediffmail.com sknmail@rediffmail.com is offline
Member
 
Join Date: May 2007
Location: India
Posts: 69
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 1
Thanked 2 Times in 2 Posts
Rep Power: 2
sknmail@rediffmail.com is on a distinguished road
Send a message via Yahoo to sknmail@rediffmail.com
Creation of large database

Hi All,

This query I have is not specific to OTM, but general DB related question for one of the WMS system's DB needs to be configured.

If I have to copy and recreate a large database of size > 500GB, what would be the quick approach in terms of time and effort.
- Copying of datafiles and other configuration files and cloning the database
- Use Oracle import utility

Another query is if I need to move the database of above or more than above size between different platform for e.g. from Linux to Solaris or other Unix flavour, what should be the right approach for doing that. Do you think that first approach 1 is possible which I think is infeasible.

Any help with information would be highly appreciated.

Thanks,
Suresh
Reply With Quote