Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links


Segment Creation on Demand (Deferred Segment Creation) in Oracle Database 11g Release 2 - Save space when creating new tables containing no rows in Oracle Database 11g Release 2.

lesio said...

It's very good article. I tested exp/imp on and I didn't notice any problems with deffered segements. It's supported.

Tim... said...


Yes. This is why that issue is listed in the section and I mentioned the fact I was talking about an un-patched "exp" utility.

Perhaps I should mention it in the section again, just so others don't misunderstand also.



Marcus Mönnig said...

In when you exported tables with the "SEGMENT CREATION DEFERRED" option with expdp from EE and imported into SE with impdp, you would get a "ORA-00439: feature not enabled: Deferred Segment Creation" error.
Does anynone know if the option is silently ignored during import in
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired