Home » Infrastructure » Unix » Porting from UNIX to NT
Porting from UNIX to NT [message #137373] Wed, 14 September 2005 23:32 Go to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10707
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.

Previous Topic: Unix shell script to run sqlplus procedure with IN parameter
Next Topic: Help in Shell Scripting
Goto Forum:
  


Current Time: Thu Mar 28 21:16:00 CDT 2024