Home » RDBMS Server » Server Administration » 10g Upgrade - block size change
10g Upgrade - block size change [message #267151] Wed, 12 September 2007 10:36 Go to next message
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
Member
Hello All,

I am planning to Upgrade my existing 9.2.0.5 database to 10gR2. My current block size is 4k and would like to change the block size to 8k on the new database.

If i am creating a 10g database, i need to use the same server where my existing 9i database resides. In order to do that, i need to export the 9i database schema's and import them into the newly created 10g database(with 8k block size). My question here is, in order to do that, i guess i need to have double the space that i have on the server right now. Is there any other way around to upgrade my database to 10g and change the block size to 8k?.

Thanks,
Vikramjogi
Re: 10g Upgrade - block size change [message #267161 is a reply to message #267151] Wed, 12 September 2007 10:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i guess i need to have double the space

Why?
If the block size is 2 times the initial one, the blocks can 2 times more data and there are half blocks. Total is (about) the same.

Regards
Michel
Re: 10g Upgrade - block size change [message #267188 is a reply to message #267151] Wed, 12 September 2007 12:06 Go to previous messageGo to next message
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
Member
I have just the 9i database now on the server(block size 4k) and i am planning on upgrading it to 10g with the block size changed to 8k. i.e a fresh installation of 10g. In order to do that, i thought i should be taking an export from 9i database and import it onto the 10g database, if that is the case, the same data will be present in two databases(i.e double the size). Please correct me if i wrong.

-Vikram
Re: 10g Upgrade - block size change [message #267201 is a reply to message #267188] Wed, 12 September 2007 13:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You are wrong.
Why same data will double the space?

Regards
Michel
Re: 10g Upgrade - block size change [message #267208 is a reply to message #267151] Wed, 12 September 2007 13:28 Go to previous messageGo to next message
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
Member
Michel,

May be i am missing something. I am trying to upgrade my database from 9i to 10g. Right now my block size is 4k, i am planning on changing it to 8k. Can you please suggest me what might be the best way of doing.

Thanks,
Vikram
Re: 10g Upgrade - block size change [message #267209 is a reply to message #267208] Wed, 12 September 2007 13:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
exp/imp.

Regards
Michel
Re: 10g Upgrade - block size change [message #267213 is a reply to message #267151] Wed, 12 September 2007 13:44 Go to previous message
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
Member
Thanks
Previous Topic: Database Administration
Next Topic: RMAN Invalid Objects
Goto Forum:
  


Current Time: Mon Dec 05 13:06:12 CST 2016

Total time taken to generate the page: 0.06784 seconds