If
you use Oracle Standard Edition to create a production database, you
need to be sure to create any corresponding test databases in Oracle
Standard Edition too. Otherwise you may find that some SQL might be
tested successfully, only to fail when you implement it in production.
You can see what I mean in the example below. First I created a table with segment creation deferred in the Oracle Enterprise Edition test database:
C:\Users\AJ0294094>sqlplus cmp
SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 16 12:35:04 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create table tab1 (col1 number)
2 segment creation deferred
3 /
Table created.
SQL>
Later, when I tried to create the same table in the Oracle Standard Edition production database, Oracle returned an ORA-00439:
C:\Users\AJ0294094>sqlplus cmp
SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 16 12:37:13 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
SQL> create table tab1 (col1 number)
2 segment creation deferred
3 /
create table tab1 (col1 number)
*
ERROR at line 1:
ORA-00439: feature not enabled: Deferred Segment Creation
SQL>
SQL>
No comments:
Post a Comment