| Porting from UNIX to NT [message #137373] |
Wed, 14 September 2005 23:32  |
milind_sri
Messages: 70
Registered: February 2005
Location: Pune
|
Member |
|
|
Hi Gurus,
I have to work on Oracle Unix to Oracle-NT porting.
I have not done it before.
My questions to you experts are:-
1.Will we face problems in data porting.
2.Do we anticipate data losses or type conversion problems.
3.What is the best approach to follow for porting of data from Unix to Oracle.
Please reply and give me a feedback on the same.
Thanks in advance.
Milind.
|
|
|
|
| Re: Porting from UNIX to NT [message #137439 is a reply to message #137373] |
Thu, 15 September 2005 04:34  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>3.What is the best approach to follow for porting of data from Unix to Oracle.
Unix to windows?
You have only three options.
1. export and import
which is the easiest one. If the volume of data is large, it will take some time (more downtime).
2. Use of materialized views.
It is painful. But, downtime is very minimal.
3. In case you are in 10g, you can make use of transportable tablesapce.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
