Home > IT Answers > DataManagement > If I am Exporting Oracle 8i Database to new O...
Help

Question

  Asked: Mar 11 2008   6:34 AM GMT
  Asked by: 1349

If I am Exporting Oracle 8i Database to new Oracle10g there is any problem with Oracle block sizes during import


Export utility, Oracle 10g, Oracle 8i


If I am Exporting Oracle 8i Database to new Oracle10g there is any problem with Oracle block sizes during import ? where as Oracle 10g has defaultly 8kb block size and Oracle 8i has 2kb Block size so it can import 8i database to 10g without any problem or we have to create additional 2kb block size during the time of Database creation of Oracle10g .

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Mar 11 2008  3:29 PM GMT  by FrankKulash




Hi,

There's no problem exporting from a database with one block size and importing into a database with another block size. Export/import is a logical operation, and it makes no attempt to copy physical characteristics (like ROWID).
  • AddThis Social Bookmark Button

Browse more Questions and Answers on DataManagement and Oracle.

Looking for relevant DataManagement Whitepapers? Visit the SearchDataManagement.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register