• oracle标准版不支持tts


    [oracle@11g ~]$ expdp \'/ as sysdba\' directory=DMP dumpfile=se-tts.dmp logfile=se-tts-exp.log cluster=n transport_tablespaces=JYC EXCLUDE=TABLE_STATISTICS,INDEX_STATISTICS

    Export: Release 11.2.0.1.0 - Production on Mon Feb 19 15:17:06 2024

    Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

    Connected to: Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
    Starting "SYS"."SYS_EXPORT_TRANSPORTABLE_01":  "/******** AS SYSDBA" directory=DMP dumpfile=se-tts.dmp logfile=se-tts-exp.log cluster=n transport_tablespaces=JYC EXCLUDE=TABLE_STATISTICS,INDEX_STATISTICS 
    ORA-39123: Data Pump transportable tablespace job aborted
    ORA-00439: feature not enabled: Export transportable tablespaces

    Job "SYS"."SYS_EXPORT_TRANSPORTABLE_01" stopped due to fatal error at 15:17:10

    [oracle@11g ~]$ oerr ora 439
    00439, 00000, "feature not enabled: %s"
    // *Cause:  The specified feature is not enabled.
    // *Action: Do not attempt to use this feature.
    [oracle@11g ~]$ exp userid=\"/ as sysdba\" transport_tablespace=y tablespaces=JYC file=se-tts.dmp log=se-tts-exp.log statistics=none

    Export: Release 11.2.0.1.0 - Production on Mon Feb 19 15:19:03 2024

    Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


    Connected to: Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
    Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
    EXP-00017: feature "Export transportable tablespaces" is needed, but not present in database
    ORA-00439: feature not enabled: Export transportable tablespaces
    EXP-00000: Export terminated unsuccessfully

    SQL> select * from v$option where upper(parameter)  like '%TABLESPACE%';

    PARAMETER
    ----------------------------------------------------------------
    VALUE
    ----------------------------------------------------------------
    Point-in-time tablespace recovery
    FALSE

    Export transportable tablespaces
    FALSE

  • 相关阅读:
    MongoDB集群和安全
    Xilinx AXI USB2.0 Device IP 手册阅读笔记
    掌握Perl命令行:深入解析命令行参数的艺术
    信息技术课如何禁止学生玩游戏
    关于MAC如何安装ubuntu
    Vue的devtools安装教程
    export LD_LIBRARY_PATH=.:$LD_LIBRARY_PATH的作用
    自定义存储文件
    c# 扩展类,扩展方法
    雷达有源干扰识别仿真
  • 原文地址:https://blog.csdn.net/jycjyc/article/details/136171432