Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle DB_BLOCK_SIZE and it's relationship to TS/table initial extent
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