Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rebuilding database to change block size
You will find the database create statement in the trace file (backup
control file to trace)
You wanted to change some parameters so I think it would be good if can pre-create all the tablespaces and size them properly.
Everything else looks good.
Thx
Gautam
-----Original Message-----
From: Miller, Jay [mailto:JayMiller_at_TDWaterhouse.com]
Sent: Tuesday, June 06, 2000 11:51 AM
To: Multiple recipients of list ORACLE-L
Subject: Rebuilding database to change block size
Okay, we finally got enough storage space to hold an export of our datawarehouse so I'm going to change the block size from 4 to 16.
Obviously I'm testing this on a small play database first, but I've never done this before so I have several questions and would welcome any advice/comments/criticisms. Here's what I was thinking of:
Here's where I'm on somewhat thinner ice: 7. Issue create database command. Is there a way to generate this automatically from the existing database? It's easy enough to write from scratch but I'd rather not take chances with typos if I don't have to.
8. Change sys and system passwords.
9. I definitely want to precreate a few tablespaces where I want to change
the initial extent parameter. Is it necessary to precreate all tablespaces
and users (I can generate that script very easily)
Okay, what am I missing?
Thanks to all,
Jay
-- Author: Miller, Jay INET: JayMiller_at_TDWaterhouse.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Tue Jun 06 2000 - 11:10:20 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).