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

Comments

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 11.2.0.2 and I didn't notice any problems with deffered segements. It's supported.

Tim... said...

Hi.

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

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

Cheers

Tim...

Marcus Mönnig said...

In 11.2.0.1 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 11.2.0.2?
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired