ORACLE
-
编辑 删除
EXPDP导出时报错ORA-12154
一、问题描述 做数据迁移时报错ORA-12154[oracle@qianzhi ~]$ expdp zrd/zrd@qianz directory=DATA_PUMP_DIR dumpfile=20180314TJJbak.dmp logfile=20180314TJJbak.log schemas=TJJExport: Release 11.2.0.4.0 - Production on Wed Mar 14 10:28:55 2018...
-
编辑 删除
SCN与时间映射转换SQL
scn转换时间select to_char(scn_to_timestamp(35212059),'YYYY-MM-DD HH24:MI:SS' ) from dual时间转换scnselect timestamp_to_scn(to_date('2014-05-22 07:00:00','YYYY-MM-DD HH24:MI:SS'))||' scn' from dual
-
编辑 删除
-bash: ulimit: core file size: cannot modify limit: Operation not permitted
ulimit
