Экспорт:
expdp sysbackup/****** \
transport_tablespaces=users,lob_data \
DIRECTORY=DATA_PUMP_DIR \
dumpfile=md_export_08_03_2021.dmp \
logfile=md_export_log_08_03_2021.log
Импорт:
impdp system/oracle@pdb directory=pdb1_dir \
dumpfile=md_export_08_03_2021.dmp logfile=md_import_log_07_12_2022.log \
metrics=y \
schemas=gui_system \
transport_datafiles='/var/opt/oradata/CDB1/pdb1/o1_mf_users_h49ybkkf_.dbf',\
'/var/opt/oradata/CDB1/pdb1/lob_data.dbf'
В итоге база не содержит sequences и packages. Судя по логу, они даже не экспортировались:
;;;
Export: Release 12.1.0.2.0 - Production on Mon Mar 8 01:02:26 2021
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "SYS"."SYS_EXPORT_TRANSPORTABLE_01": system/******** AS SYSDBA transport_tablespaces=users,lob_data DIRECTORY=DATA_PUMP_DIR dumpfile=md_export_08_03_2021.dmp logfile=md_export_log_08_03_2021.log
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TRANSPORTABLE_EXPORT/INDEX/INDEX
Processing object type TRANSPORTABLE_EXPORT/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT
Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/COMMENT
Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/REF_CONSTRAINT
Processing object type TRANSPORTABLE_EXPORT/TRIGGER
Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/STATISTICS/MARKER
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Master table "SYS"."SYS_EXPORT_TRANSPORTABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TRANSPORTABLE_01 is:
/u01/app/oracle/admin/orcl/dpdump/md_export_08_03_2021.dmp
******************************************************************************
Datafiles required for transportable tablespace LOB_DATA:
/u01/app/oracle/oradata/ORCL/datafile/lob_data.dbf
Datafiles required for transportable tablespace USERS:
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_h49ybkkf_.dbf
Job "SYS"."SYS_EXPORT_TRANSPORTABLE_01" successfully completed at Mon Mar 8 01:08:21 2021 elapsed 0 00:04:12
Это стандратное поведение и если да, то как включить указанные сущности в экспорт?
Средний
