Home » RDBMS Server » Server Administration » Re: db_block _size 4k
Re: db_block _size 4k [message #369603] Thu, 02 November 2000 08:57
simham
Messages: 7
Registered: November 2000
Junior Member
take a full export of the database.
remove all database files
set db_block_size=4096 (for 4k) better if 8192(8k)
create the database. run catlog,catproc etc
do a full import with ignore=y

do a trial run first on sum demo database first before you do the above on your original db.

Report message to a moderator

Previous Topic: ORA-27123: unable to attach to shared memory segment
Next Topic: Performance Question
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 02 07:08:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.