datapatch meet ORA-01422
ORA
2023-09-11 14:18:40 时间
[现象]
datapatch ORA-01422: e
[解决方法]
sample 1:
--step 1:
sqlplus /nolog
conn /as sysdba
create table registry$sqlpatch_backup as select * from registry$sqlpatch ;
drop table registry$sqlpatch;
@?/rdbms/admin/catsqlreg.sql
---step 2:
alter session set container=PTUAT;
create table registry$sqlpatch_backup as select * from registry$sqlpatch ;
drop table registry$sqlpatch;
@?/rdbms/admin/catsqlreg.sql
--step 3:
alter session set container=PTDEV;
create table registry$sqlpatch_backup as select * from registry$sqlpatch ;
drop table registry$sqlpatch;
@?/rdbms/admin/catsqlreg.sql
相关文章
- ORA-19809: 超出了恢复文件数的限制
- > ORA-01841: (full) year must be between -4713 and +9999, and not be 0 及自定义my_to_date函数
- 一则> ORA-00933: SQL command not properly ended 原因:表名定义 不能加as
- 【DBA及开发必备】全解ORA-1555快照太旧错误原理及解决方案
- 记一则expdp导出失败案例(ORA-39002/39070/29283/06512/29283)
- ORA-01102: cannot mount database in EXCLUSIVE mode
- 【Mac连接Navicat报错】ORA-21561: OID generation failed
- 解决PL/SQL登录Oracle报错:【ORA-12537:TNS:连接关闭】问题
- ORA-04091:表XX发生了变化,触发器/函数不能读它
- Error querying database. Cause: java.sql.SQLException: ORA-01745: 无效的主机/绑定变量名
- Oracle出现与并行相关的ORA-00600时的调查方法
- Oracle:ORA-01219 数据库或可插入数据库未打开 仅允许在固定表或视图中查询