Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00439: feature not enabled: Deferred Segment Creation

ErikaWhittomeApr 17 2010 — edited Jun 19 2013
I have a new RAC database that is standard edition 11gr2. I'm trying to datapump over about 200 tables in one schema from the developers sandpit which they made, also 11gr2. When I import the schema using datapump, there are 180- something errors on "ORA-00439: feature not enabled: Deferred Segment Creation"

Here's a sample one:

CREATE TABLE erika."ARDOME_URP_EVENT_DESC"
("UED_EVENT" VARCHAR2(32 BYTE), "UED_COL" VARCHAR2(10 BYTE),
"UED_DESC" VARCHAR2(128 BYTE))
SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
/

So I can run this "create table" sql on the sandpit, but not on the new RAC. I get
ORA-00439: feature not enabled: Deferred Segment Creation.

The parameter is set on the RAC database:

SQL> show parameter segment

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
deferred_segment_creation boolean TRUE




THe sandpit is enterprise edition ( the developers probabrly just clicked "next"). The header is of the sandpit in SQLPlus is:
Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


On my RAC, I just installed standard edition.

This list of all the features and edtions does NOT list deferred segment creation as a "feature" of enteprise edition:

http://www.oracle.com/database/product_editions.html

Can anyone shed some light here? Is this new feature a licensed option?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2013
Added on Apr 17 2010
40 comments
30,731 views