Re: ORACLE block utilization

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 05 May 1999 20:54:08 GMT
Message-ID: <373aafc8.25584849@192.86.155.100>

A copy of this was sent to fmendoza3286123_at_my-dejanews.com (if that email address didn't require changing) On Wed, 05 May 1999 20:36:58 GMT, you wrote:

>Can you have different table data within the same block?
>In other words can two non-clustered tables share the same block?
>

no.

only clustered tables could result in data from 2 tables being stored in one block.

>If not, then my next question is answered. If so, if you issue the alter table
>command with a different PCTUSED or PCTFREE clause how does that affect the
>other table?
>
>Thanks for all your help
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed May 05 1999 - 15:54:08 CDT