Re: Oracle Locally Managed Tablespaces

Hi,

Yes, there is difference. Use the following example to see the difference. Create 2
tables with different initial sizes and have a look at the size and number of extents
using view dba_extents. You will notice the difference:

create table ... initial 64K ...
create table ... initial 1G ...
select * from dba_extents

regards,
Marek Received on Sat Nov 05 2005 - 16:39:39 CST