I am running 9.0.1.4.0 version of oracle with 4k block size.Planning to change the block size to 8k.Pls. let me know the exact steps or documentation to do this.
Printable View
I am running 9.0.1.4.0 version of oracle with 4k block size.Planning to change the block size to 8k.Pls. let me know the exact steps or documentation to do this.
1. Do full export
2. Drop all data files, redo , control files
3. Create a new DB with 8k block size
4. Run Import.
Or
Leave the system tablespace in 4k.
Create new 8k tablespace and move all the tables, indexes to 8k tablespace.
Tamil
Ok fine.Customer wants to recreate the whole database with 8k.Right now we are using 9.0.1.4.0 and has parameter db_block_size and db_block_buffers.After creating a new DB with 8k db_block_size ,Do i need to bring the db_block_buffers to hal of its original value???.The next question is do i need to run catalog/catproc etc after new database creation?.Since java system was already installed in the existing DB if i import will it automatically create all the procedures/functions from the export?.Pls. clarify.
why can't he just create a new ts with the desired block size and move the objects?
Yes, create new tablespace with 8k block size and move the objects
No no no. all you have to do is just simply change the setting in the init.ora and the new block size will take effect when you crank the database back up. I do it all the time when I clone my 2 terrabyte database. My prod is 16k and my dev is 4k. *click click* just like that!
game on
Sure u can do that way???Quote:
Originally posted by OracleDoc
No no no. all you have to do is just simply change the setting in the init.ora and the new block size will take effect when you crank the database back up.
game on
Lets see how will oracle yell at you when u change Block Size in Init.ora
Abhay.Code:sys:test> startup pfile=c:\oracle\admin\test\pfile\init.ora
ORACLE instance started.
Total System Global Area 101784276 bytes
Fixed Size 453332 bytes
Variable Size 75497472 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
ORA-00209: control file blocksize mismatch, check alert log for more info
newbie:test> startup pfile=z:\big\joke\dont\be\so_serious\init.ora
ORACLE instance started.
Total System Global Area 801784276 bytes
Fixed Size 453332 bytes
Variable Size 75497472 bytes
Database Buffers 25165824 bytes
Redo Buffers 48 bytes
ORA-0600: database blocksize changed, have a nice day!
Oracle doesn't yell at me it says nice things to me!
He was jerking your chain :-)Quote:
Originally posted by abhaysk
Sure u can do that way???
Lets see how will oracle yell at you when u change Block Size in Init.ora
Abhay.Code:sys:test> startup pfile=c:\oracle\admin\test\pfile\init.ora
ORACLE instance started.
Total System Global Area 101784276 bytes
Fixed Size 453332 bytes
Variable Size 75497472 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
ORA-00209: control file blocksize mismatch, check alert log for more info
wud have been good if the post were to be in "Obfuction Unlimited" :rolleyes: :rolleyes:Quote:
Originally posted by OracleDoc
z:\big\joke\dont\be\so_serious
somebody will try that one day now and get burned by it, your post looked like it was serious with no mention of a joke - dangerous
Lol, if someone trys it just from reading here (or anywhere else) you know as well as I do they shouldn't even be touching a key board let alone being a DBA.Quote:
Originally posted by davey23uk
somebosyw ill try that one day now and get burned by it, your post looked like it was serious with no mention of a joke - dangerous
But to be politcially correct so no ones feelings get hurt(God forbid)... I retract my above instructions on changing block size, they were wrong.
agreed - but some people are stupid :)
Right but the problem is, many who come here dont even have a clue about Oracle...Quote:
Originally posted by OracleDoc
Lol, if someone trys it just from reading here (or anywhere else) you know as well as I do they shouldn't even be touching a key board let alone being a DBA.
I was about to reply.. then I read "game on"... and left it.
Haa haa at least SOMEONE got my humor. Thanks Sanjay.
It's worth remembering that more than half the people on this site are NOT English mother-tongue and are likely to a have a VERY different sense of humour.
"game on" means nothing to me . . . obviously something American (Interesting that John Kerry talked of the other 96% of the world).
Perhaps we need HTML tags [joke] & [/joke] :)
But i dont understand why on earth one wants to show off the humor in ODBA forum.. when u gotta Obfuscation Unlimited..Quote:
Originally posted by OracleDoc
Haa haa at least SOMEONE got my humor. Thanks Sanjay.
And also DAPI said the right thing, "game on means nothing to me . . . "
Humour .. it can also be taken as .. "Its jus a Game to change ur DB Block Size" -- Can't it be?
Well i only wanted orginal poster to beware of such misleading posts.. :rolleyes: :rolleyes:
PS : good that its now moved to Obfuscation..