未启用延迟的细分创建功能(ORA-00439) [英] Deferred Segment Creation feature not enabled (ORA-00439)

问题描述

我有.sql带有DDL的脚本文件，可用于60多个表.我试图将脚本复制粘贴到连接到数据库"SQL Server 11g Express Edition 11.2.0.2.0版-64位生产"的SQL Developer中.

I have .sql script file with DDL for more than 60 tables. I am trying to copy-paste the script into SQL Developer, connected to a database which is "Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production".

示例DDL脚本:

CREATE TABLE UserName."Table_Name" 
   (    "Col1" NUMBER(*,0), 
    "Col2" VARCHAR2(50 BYTE), 
    "Col3" VARCHAR2(50 BYTE)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  TABLESPACE "USERS" ;

Error report -
SQL Error: ORA-00439: feature not enabled: Deferred Segment Creation
00439. 00000 -  "feature not enabled: %s"
*Cause:    The specified feature is not enabled.
*Action:   Do not attempt to use this feature.

如果我在DDL脚本中删除了SEGMENT CREATION DEFERRED:

If I remove SEGMENT CREATION DEFERRED in the DDL Script:

CREATE TABLE UserName."Table_Name" 
   (    "Col1" NUMBER(*,0), 
    "Col2" VARCHAR2(50 BYTE), 
    "Col3" VARCHAR2(50 BYTE)
   ) 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  TABLESPACE "USERS" ;

这有效.但是我无法在每个表脚本中手动删除它.

This works. But I can't manually remove that in each and every table script.

如果我有.dmp转储文件，那么以下语法也可以解决问题；在源实例上:

If I have .dmp dump file then the following syntax will also solve the issue; on the source instance:

EXPDP user/pwd dumpfile=somename.dmp directory=DATA_DUMP_DIR nologfile=Y version=10.2

并在目标实例上

IMPDP user/pwd dumpfile=somename.dmp directory=DATA_DUMP_DIR nologfile=Y version=10.2

但是我没有.dmp文件，只有一个.sql文件.

But I don't have a .dmp file, I only have a .sql file.

哪种方法是最好的?

推荐答案

延迟的段创建选项在企业版(EE)中可用

The deferred segment creation option is not available in Oracle 11g Express Edition (XE), which is what you are using. It's only available in Enterprise Edition (EE).

如果您不想执行导出/导入操作并且只能使用已经提供的脚本文件，则唯一的选择是查找并删除SEGMENT CREATION DEFERRED子句的所有实例.

If you don't want to do an export/import and can only use the supplied script file you already have, your only option is to find and remove all instances of the SEGMENT CREATION DEFERRED clause.

任何文本编辑都可以做到这一点，SQL Developer .

Any text edit can do that of course, and SQL Developer has its own find/replace in the SQL Worksheet window.

这篇关于未启用延迟的细分创建功能(ORA-00439)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！