| Author |
Message |
kvmb
*nix forums beginner
Joined: 20 Jul 2006
Posts: 2
|
 Posted: Thu Jul 20, 2006 9:58 pm Post subject:
Re: Datablock structure: changes from a version to another ?
|
|
|
Why ?
As far as I can remember- no real changes since Oracle 7 (if we consider
blocks containing normal heap
or clustered tables)
From 7 to 8.0 - the block address format changed a bit ... and of the first
version byte in the block
Then the interpretation of the DBA changed again with the introduction of
relative datafiles - but this
doesn't really changes the blockstructure....
Nothing really changed with the introduction of partitions - don't know
where that comes from...
With the introduction of ASSM on 9i the structure changed - some extra bytes
Then with BIGFILE tablespace in 10g the interpretation of the DBA changed
again - no relative file#,
only offsets...
so - no real big changes ... but others might know more ...
cheers,
Kurt
"Spendius" <spendius@muchomail.com> wrote in message
news:1153391169.439726.160410@i3g2000cwc.googlegroups.com...
| Quote: | Hello,
In which measure Oracle carries out changes to its block
structure with new versions ? Is there any *real* modifications
in this regard from a version to the next one ?
Thank you.
Spendius
|
|
|
| Back to top |
|
 |
sybrandb
*nix forums beginner
Joined: 13 Jul 2006
Posts: 22
|
| Posted: Thu Jul 20, 2006 11:29 am Post subject:
Re: Datablock structure: changes from a version to another ?
|
|
|
Spendius wrote:
| Quote: | Hello,
In which measure Oracle carries out changes to its block
structure with new versions ? Is there any *real* modifications
in this regard from a version to the next one ?
Thank you.
Spendius
|
The block format was revised in 8.0 to allow for partitioning.
It was revised again in 10g to allow for bigfile tablespaces.
Such revisions are usually documented in the release notes.
--
Sybrand Bakker
Senior Oracle DBA |
|
| Back to top |
|
|
Spendius
*nix forums addict
Joined: 09 May 2005
Posts: 75
|
| Posted: Thu Jul 20, 2006 10:26 am Post subject:
Datablock structure: changes from a version to another ?
|
|
|
Hello,
In which measure Oracle carries out changes to its block
structure with new versions ? Is there any *real* modifications
in this regard from a version to the next one ?
Thank you.
Spendius |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
»
Server
