Home » RDBMS Server » Server Administration » How to migrate db from one OS to another without using exp/imp utility
How to migrate db from one OS to another without using exp/imp utility [message #58929] Wed, 15 October 2003 01:59 Go to next message
sachin kumar gupta
Messages: 157
Registered: March 2003
Senior Member
Hi all,

In interview one question was raised how to shift db from one OS to another(say from Windows to Linux) without using exp/imp utility.

And also how to exclude the tables while exporting any user ('coz tables=A,B,C in export is a very long way if one wants to export 100 tables out of 105)

Is there any way.

TIA,
Sachin

Report message to a moderator

Re: How to migrate db from one OS to another without using exp/imp utility [message #58931 is a reply to message #58929] Wed, 15 October 2003 06:15 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Sachin,
that was a trick question meant to confuse you. Answer is you cannot 'successfully' migrate a database from Windows to Linux without using exp/imp. Exp/imp is THE way to migrate databases across different platforms, becos the datafiles are OS specific.

You cannot exclude tables in OWNER level export. You can do a user level export and exclude them during the import .. Or you can do pattern matching in table level export to export a bunch of tables(if you find it difficult to type in )..

Again if you want to export 100 of the 105 tables, you will and should be doing User level export anyway !

-Thiru

Report message to a moderator

Previous Topic: Couldn't start the oracle server on windows 2000
Next Topic: Oracle startup problem for deleting data file manually
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 13:40:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.