by tablespace
From: "Joseph S. Testa" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Subject: Re: changing db_block_size
Date: Tue, 27 Mar 2001 16:50:56 -0800
last i checked that was your only choice, anyone
like t
To change the block size you have to recreate the database.
How you are going to copy the data that's another issue. You can use full
database export/import (pretty long downtime, or problems with data
consistency) or you can do a live copy. More on a live copy you can see in:
Venkat S.
Joe,
No flame. There are other methods of doing the job, but the work!!!
Spooling all the data out to comma delimited files, creating all those DDL
scripts!! You'd have to be a masochist or else into some HEAVY re-engineering!
Dick Goulet
Reply
I'd be interested in seeing that presentation, when are you presenting?
I'll be there doing the logminer thing on tuesday late afternoon, last
session before BIG BASH.
thanks, joe
To change the block size you have to recreate the database.
How you are going to copy the data that's another
all,
I would like to change the db_block_size (currently 2048) of our production
database and would be interested in hearing from those that have done this on a
not so small database. This is our oracle financials/manufacturing server and
is about 30GB in size. Did you recreate the database
export and import is your only solution to recreate the database in
different db_block_size
Winnie
Roy Ferguson [EMAIL PROTECTED]@fatcity.com on 03/27/2001 04:40:22 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
last i checked that was your only choice, anyone like to flame me for
that statement :)
joe
Roy Ferguson wrote:
all,
I would like to change the db_block_size (currently 2048) of our production
database and would be interested in hearing from those that have done this on a
not so
Roy,
You will have to recreate the database to change db_block_size.
Possibly the only way to do this is through export/import.
-full export
-remove old database
-recreate database with new block size.
-full import
30Gb database will take approximately 12 hours to complete the job on a
medium
E-L [EMAIL PROTECTED]
Subject: Re: changing db_block_size
Date: Tue, 27 Mar 2001 16:50:56 -0800
last i checked that was your only choice, anyone like to flame me for
that statement :)
joe
Roy Ferguson wrote:
all,
I would like to change the db_block_size (currently 2048) of our