Home » RDBMS Server » Server Administration » transfer database on windows 2000 to unix
transfer database on windows 2000 to unix [message #136922] Mon, 12 September 2005 05:18 Go to next message
mostafa71
Messages: 18
Registered: May 2005
Junior Member

hi sirs,

is it posibel to transfer databse from windows 2000 to unix server . I know that is posible to export from old and import to the new one
but I want know if its posible by anather way step by step if you please.

thank you
Re: transfer database on windows 2000 to unix [message #136928 is a reply to message #136922] Mon, 12 September 2005 05:25 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
No other way. In 10g you may use a transportable tablespace.
If this is one time datbase move, export /import is the only option.
If you are worried about the downtime involved, use materialized views. This is painful. but downtime is very minimal.
Re: transfer database on windows 2000 to unix [message #137498 is a reply to message #136922] Thu, 15 September 2005 07:06 Go to previous messageGo to next message
Jay Munshi
Messages: 30
Registered: July 2004
Member
and not forget to ftp in binary mode!
regards,
Jay Munshi
http://jaydba.tripod.com
Re: transfer database on windows 2000 to unix [message #137794 is a reply to message #137498] Fri, 16 September 2005 16:18 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

The best way to transfer database form windows 2000 to unix is by Export imoport utility. It is easy and by this u can migrate database very fast campare to other method.

Friend
Sunil
Re: transfer database on windows 2000 to unix [message #137802 is a reply to message #137794] Fri, 16 September 2005 18:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> It is easy and by this u can migrate database very fast campare to other method.
What is the other method here?
when different platforms are involved, the only method is export/import (which involves considerable downtime).

Export / import is not always the fastest / Reliable method.
It depends on the volume of database.
Re: transfer database on windows 2000 to unix [message #138126 is a reply to message #137802] Tue, 20 September 2005 04:35 Go to previous messageGo to next message
Jay Munshi
Messages: 30
Registered: July 2004
Member
DDL scripts, database links? insert statements?
more painful.

move tables to a flat file and use sql loader?
http://www.oriolecorp.com/products.html#pdqout

why not stick to the topic and concentrate on solving issues?
think about it....

regards,
Jay Munshi
http://jaydba.tripod.com

[Updated on: Tue, 20 September 2005 04:49]

Report message to a moderator

Re: transfer database on windows 2000 to unix [message #215638 is a reply to message #136922] Tue, 23 January 2007 05:29 Go to previous messageGo to next message
tarunkpandit
Messages: 4
Registered: January 2007
Junior Member

Hi

Is it possible to transfer database from Microsoft 2003 * Windows to HP Unix.

how can we proceed with this task.

Is there any script which could help in switching from Microsoft 2003 to HP Unix
Re: transfer database on windows 2000 to unix [message #215643 is a reply to message #215638] Tue, 23 January 2007 05:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Same as above.
Use export and import.
In case of 10g and if the volume is very large, you may use transportable tablespaces.
Re: transfer database on windows 2000 to unix [message #215644 is a reply to message #215643] Tue, 23 January 2007 05:44 Go to previous messageGo to next message
tarunkpandit
Messages: 4
Registered: January 2007
Junior Member

Is it possible to switch Oracle 10G database from Microsoft Windows 2003 to HP Unix without having failure of instance.

For fraction of seconds tnsping timed out could work --
So that we could not have much downtime.

Is there any SQL Script which could switch Oracle 10G database from Microsoft 2003* Windows to HP Unix
Re: transfer database on windows 2000 to unix [message #215645 is a reply to message #136922] Tue, 23 January 2007 05:45 Go to previous messageGo to next message
tarunkpandit
Messages: 4
Registered: January 2007
Junior Member

Is it possible to switch Oracle 10G database from Microsoft Windows 2003 to HP Unix without having failure of instance.

For fraction of seconds tnsping timed out could work --
So that we could not have much downtime.

Is there any way

need a SQL Script which could switch Oracle 10G database from from Microsoft 2003 Windows to HP Unix
Re: transfer database on windows 2000 to unix [message #215646 is a reply to message #215644] Tue, 23 January 2007 05:47 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
@tarunkpandit: please, do not report your messages to get attention. Those reports are visible only to moderators, and are to be used to report abuse or misuse.
Re: transfer database on windows 2000 to unix [message #215648 is a reply to message #215645] Tue, 23 January 2007 05:49 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> For fraction of seconds tnsping timed out could work
Just not possible.
>>need a SQL Script which could switch Oracle 10G database from from Microsoft 2003 Windows to HP Unix
Please read/research about it first.
SQL methods are time consuming( to setup ) and not easily feasible in your case( you need to have a parallel instance). You can make use of Materialized views. But still, it will minimize the downtime (depends on your volume) and cannot just magically do the job for you.

[Updated on: Tue, 23 January 2007 05:52]

Report message to a moderator

Previous Topic: Database administration
Next Topic: downloading Tutorial for DBA
Goto Forum:
  


Current Time: Fri Dec 09 19:18:52 CST 2016

Total time taken to generate the page: 0.08866 seconds