ORA-00439: feature not enabled: Deferred Segment Creation
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?