7 x 24 在线支持!
How to view & recover other objects such as views, stored procedures, functions via PRM DUL
Hi Team,
I was testing the PRM-DUL tool on my Oracle database.The tool only recovers the tables of the DB schemas.
How to view & recover other objects such as views, stored procedures, functions etc. ? Please explain.
Answer:
you can recover other objects from the base table , for example you can recover procedure from sys.source$ table , and PRM can help you extract source$ from datafile , and then you got all procedure.
Question:
If the system tablespace is corrupted, How does the recovery of views, stored procedures, functions etc. work ?
Answer:
Even system tablespace is corrupted , prm can still extract data from the dbf datafile . Unless system tablespace is lost , then no one can recover view/stored procedure any more.