8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Segment Creation on Demand (Deferred Segment Creation) 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

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!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.