create table ash0420 as select *  from dba_hist_active_sess_history a where a.SAMPLE_TIME between to_date('2023-04-19 07:00:00', 'yyyy-mm-dd hh24:mi:ss') and to_date('2023-04-19 07:30:00', 'yyyy-mm-dd hh24:mi:ss');

export ORACLE_PDB_SID=PDB01

expdp /'/ as sysdba/' directory=ORADATA dumpfile=ash0420.dmp tables=sys.ash0420 logfile=20230420.log

Export: Release 19.0.0.0.0 - Production on Thu Apr 20 13:50:32 2023
Version 19.16.0.0.0

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

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "SYS"."SYS_EXPORT_TABLE_01":  "/******** AS SYSDBA" directory=ORADATA dumpfile=ash0420.dmp tables=sys.ash0420 logfile=20230420.log
ORA-39166: Object SYS.ASH0420 was not found or could not be exported or imported.
ORA-31655: no data or metadata objects selected for job
Job "SYS"."SYS_EXPORT_TABLE_01" completed with 2 error(s) at Thu Apr 20 13:50:50 2023 elapsed 0 00:00:17


exp /'/ as sysdba/'  file=/tmp/ash0420.dmp log=/tmp/20230420.log tables=sys.ash0420

http://www.cndba.cn/hbhe0316/article/116565

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle