Re: Importing into a LMT?

Mark.Powell_at_eds.com (Mark D Powell) wrote in message news:<2687bb95.0304021209.4df1437e_at_posting.google.com>...
> tim.kearsley_at_milton-keynes.gov.uk (Tim Kearsley) wrote in message news:<725736ef.0304020716.3adff8f2_at_posting.google.com>...

< Original post cut>

> Tim, Look at dba_extents to see the actual extent size used.
> Dba_segments and dba_tables will show the create statement initial
> extent. When Oracle allocates the table in an LMT it will allocate as
> many uniform extents as necessary to hold the initial extent storage
> request. It would be most efficient from a space usage point of view
> on import if the export file was made with the compress=n option set
> then ojbects will take only as many extent allocations as necessary to
> hold their data on import.
>
> HTH -- Mark D Powell --

Mark (and Anton),

That's most helpful, thank you.

When I check DBA_EXTENTS I do indeed see the uniform extent size used throughout. The comment re. doing the export with the COMPRESS=N option is noted too.

Tim Kearsley Received on Thu Apr 03 2003 - 03:36:25 CST