在表进行闪回操作后,表 RECYCLETEST 上的索引和触发器将按照 OBJECT_NAME 列中所示进行命名。根据以上查询,可以使用原始名称重新命名对象,如下所示: ALTER INDEX "BIN$04LhcpnianfgMAAAAAANPw==$0" RENAME TO IN_RT_01; ALTER TRIGGER "BIN$04LhcpnganfgMAAAAAANPw==$0" RENAME TO TR_RT; 一个值得注意的例...
For the Oracle's cost-based optimizer (CBO) to work correctly, you need to regularly compute statistics for your tables and indexes using the Oracle-suppliedDBMS_STATSpackage or theANALYZE TABLEstatement. DB2 Explain Plan Visual explain plan is supported for DB2 versions 8.x and 9.x. It is ...
CJQ0 typically handles job queues for the older DBMS_JOB framework but also plays a part in the execution of DBMS_SCHEDULER jobs by managing the job queue and distributing jobs to job slaves (Jnnn processes) for execution. CQJ0 is related to job scheduling, specifically for Oracle's Scheduler...
Q1)- What is the relationship between level 0 and level 1 DFD diagrams? Explain. Q2)- What does Use Case mean? and what does use case describe? Q3)- What does triggers mean in use case, and what are t Given a pipeline A of five stages, where eac...
In SQL, what type of integrity are you enforcing by using the CHECK clause? Indicate if the following statements are true or false. If the answer is false, explain why. 1. The OF clause for the CREATE TRIGGER statement specifies the ta...
You may keep multiple execution plans in the plan table by assigning each a unique statement_id. Or you may choose to delete the rows from the plan table after you are finished looking at the execution plan. You can also roll back an EXPLAIN PLAN statement in order to remove the ...
1) in normal RDBMS when user triggers a activation then all records in New table has to be compared across old records to understand its a new or old record this comparison is done at ABAP layer by fetching all records into ABAP layer. Then if the record is new then it will be insert...
Remember the logon trigger changes my current schema to APP_SCHEMA. MARTINNASH@bi20p> alter session set current_schema = martinnash; Session altered. MARTINNASH@bi20p> select * from table(dbms_xplan.display); PLAN_TABLE_OUTPUT --- --- | Id | Operation | Name | Rows | Bytes | Cost ...