This content has been marked as final. Show 2 replies
Some more info :
I am using LMT in both production and test
but when I export and import ( datapump ) - the initial extents are not 'adjusting' themselves to the new tablespace in test.
So the original tablespace in production have a 100MG initial and next extent and the target tablespace to which I remap during the import has 65k initial/next extent - but nevertheless - the tables are getting created with the old extent sizes of 100MG.
The only way I found to fix this is to actually run alter table commands on the empty tables after import, and that works fine for everything other then subpartitions.