1. 查看数据库中的无效对象 check oracle object SQL> select count(*) from dba_objects where status='INVALID'; 2. 关闭应用,数据库和监听不能关闭 cd $ADMIN_SCRIPTS_HOME ./adadstpall.sh apps/apps 3. 用APP用户,执行adadmin打开维护模式并重新编译APPS Schema; 打开维护模式 adadmin->Change Maintenance...
1. 查看数据库中的无效对象 check oracle object SQL> select count(*) from dba_objects where status='INVALID'; 2. 关闭应用,数据库和监听不能关闭 cd $ADMIN_SCRIPTS_HOME ./adadstpall.sh apps/apps 3. 用APP用户,执行adadmin打开维护模式并重新编译APPS Schema; 打开维护模式 adadmin->Change Maintenance...
ORA-12170:TNS:Connect timeout occurred，说明CPSETL.BI_FEED_CUSTOMER_SNAPSHOT里有远程dblink涉及，需要具体诊断该远程dblink访问问题。
点第一个,按住shift键点最后一个,右键recompile就OK了
--编译所有无效PROCEDURE对象BEGIN FOR cur IN ( SELECT object_name ,object_type FROM dba_objects WHERE object_type = 'PROCEDURE' AND status = 'INVALID' ) LOOP DBMS_OUTPUT.PUT_LINE(cur.object_name); EXECUTE IMMEDIATE 'ALTER ' || cur.object_type || ' ' || cur.object_name || ' COMPILE...
select owner,object_name,object_type from dba_objects o where status = ‘INVALID’ and owner = ‘GZDQMP’ and o.OBJECT_TYPE=’VIEW’;解决是重新编译。 ORA-04065:未执行,已更改或删除stored procedureXXX(过程名) 错误说明:同一个过程中调用了多过程,先跑的过程中有DROP表后重建的操作,DROP表的操作...
在12c建pdb的语法里,还新出现了一个option叫PATH_PREFIX,用来限制一些对象(directory objects/oracle XML/create pfile/oracle wallets)只能在特定目录下。这个目录前缀,一旦添加将伴随着pdb直到终老,连datapump想换个目录都不行,所以添加一定要谨慎。 在Oracle 18c里做pdb迁移的时候,执行DBMS_PDB.CHECK_PLUG_COMPATIBIL...
Check your database for invalid objects. Invoke SQL*Plus and log in as the SYS user with SYSDBA privileges. Run the following query: Copy SQL> select count(*) from dba_objects where status='INVALID'; If the query returns a count value of 0, the database does not have invalid object...
TTS_FULL_CHECK 对 TTS 执行完整的或部分相关性检查 TABLESPACES 要导出的表空间列表 TRANSPORT_TABLESPACE 导出可传输的表空间元数据 (N) TEMPLATE 调用 iAS 模式导出的模板名 在没有警告的情况下成功终止导出。 === C:Documents and Settingsadministrator>imp help=y Import: Release 9.2.0.1...
so this command may take a long time to execute on a database with a large number of invalid objects. Use the following queries to track recompilation progress: 1. Query returning the number of invalid objects remaining. This number should decrease with time. ...