Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle DB_BLOCK_SIZE and it's relationship to TS/table initial extent

Oracle DB_BLOCK_SIZE and it's relationship to TS/table initial extent

From: bopeep <bopeep_at_yahoo.com>
Date: 2000/07/25
Message-ID: <397E1C73.E2C426F7@yahoo.com>#1/1

We are running Oracle 8.0.6 on Solaris 2.6

We're in the process of moving our databases to a new server, and the professional service team building our initial test databases built them
with 2K db_block_size. However, the actual block size will need to be recreated eventaully as at least 8K.
They want to test failover (Oracle HA), and have asked for an export of

the data on the existing machine, and want me to import on the new machine db
My question is, with 2K block size, what will be max, if there one, of the Initial extents within tablespaces/tables? What is the relationship between db block size and initial extent (multiple of?). We have a table that through export wants to create an initial extent of nearly 10GB, (the tablespace itself is built to 25GB), and when attempting to import it is obviously not able to create an initial extent of the size that it wants to.
Will the Database have to be recreated to even allow this import?

TIA Received on Tue Jul 25 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US