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?

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

Add your comments here.
Name
Comment
(max 400 chars - plain text)