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.
You can use TRANSFORM parameter of datapump import and have it igore the STORAGE clause contained in the datapump dumpfile but use the tablespace defaults instead.