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, that's what my forum is for!
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!