Email: service@parnassusdata.com 7 x 24 online support!

    You are here

    • You are here:
    • Home > Blogs > PDSERVICE's blog > How to view & recover other objects such as views, stored procedures, functions via PRM DUL

How to view & recover other objects such as views, stored procedures, functions via PRM DUL

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.