oracle soa db exp

env: Oracle Cloud 12c


因為問題需要把Oracle Cloud SOA DB做export備份，出現下面訊息

command:
exp aaaaa/bbbbb@B2BTPDB file=/u03/app/oracle/fast_recovery_area/OECB2BT/soalob.dmp log=/u03/app/oracle/fast_recovery_area/OECB2BT/soalob.log tables=SP954682_DBFS.SHARE buffer=1000000 feedback=10000

msg:
Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
Current user changed to SP954682_DBFS
EXP-00111: Table SHARE resides in an Encrypted Tablespace SP954682_DBFS and will not be exported
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 14:
PLS-00201: identifier 'SYS.DBMS_DBFS_SFS_ADMIN' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00085: The previous problem occurred when calling SYS.DBMS_DBFS_SFS_ADMIN.instance_info_exp for object 98776
Export terminated successfully with warnings.
這個問題主要在於SOA的Tablespace是壓縮的，導致傳統的export無法使用。

可以使用下面的指令查看Tablespace使否是壓縮的:
command:
select tablespace_name, bigfile, encrypted from dba_tablespaces;

TABLESPACE_NAME                BIG ENC

------------------------------ --- ---

SYSTEM                         NO  NOSYSAUX                         NO  NO
TEMP                           NO  NO
SP65647288_IAS_TEMP            NO  NOSP65647288_STB                 NO  YES
SP954682_DBFS                YES YES



把傳統的export指令改為10g以後推出的expot data pump就可以了
command:
expdp aaaaa/bbbbb@B2BTPDB tables=SP954682_DBFS.SHARE directory=soadmp dumpfile=soalob.dmp logfile=soalob.log

msg:
Export: Release 12.1.0.2.0 - Production on Sun Oct 15 10:45:05 2017
Copyright (c) 1982, 2015, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production

Starting "aaaaa"."SYS_EXPORT_TABLE_01":  aaaaa/********@B2BTPDB tables=SP954682_DBFS.SHARE directory=soadmp dumpfile=soalob.dmp logfile=soalob.log

Estimate in progress using BLOCKS method...

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 57.43 GB

>>> DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled