Non Standard Block size [message #271853] |
Wed, 03 October 2007 03:00 |
tanmoy1048
Messages: 133 Registered: June 2007
|
Senior Member |
|
|
If I wanna some tables in nonstandard block size like 16 K, then what Should I do?
1.allocate memory to db_16k_cache_size
2.create tablespace of 16K
3.move table with alter table move statement
what else should I do? oracle 10gR2 in solries.
|
|
|
|
Re: Non Standard Block size [message #272650 is a reply to message #271857] |
Fri, 05 October 2007 15:33 |
OracleDisected
Messages: 25 Registered: September 2007 Location: Mexico
|
Junior Member |
|
|
R You sure?
The first step instructs the DB to reserve only the amount of memory specified to handle blocks of 16k of size.
Guess it's the first object with distinct blocksize, then steps (2) and (3) must be done.
Regards
[Edit MC: url to poster blog removed. We don't care about your blog in this post. If you have an answer on your site, post a link to this answer. If you don't, post your blog url in Marketplace]
[Updated on: Thu, 11 October 2007 12:39] by Moderator Report message to a moderator
|
|
|
|
Re: Non Standard Block size [message #273245 is a reply to message #272678] |
Tue, 09 October 2007 12:49 |
OracleDisected
Messages: 25 Registered: September 2007 Location: Mexico
|
Junior Member |
|
|
I agree with you... I've had a semantic 'worm-hole': I understood that just with step 1 is enough, and you're telling us: "after step 1, maybe bounce, then do step 2 and 3".
Regards
[Edit MC: url to poster blog removed. We don't care about your blog in this post. If you have an answer on your site, post a link to this answer. If you don't, post your blog url in Marketplace]
[Updated on: Thu, 11 October 2007 12:38] by Moderator Report message to a moderator
|
|
|
|