Damn, I was afraid of that and really knew that! I was just hoping I was wrong. DB is 9i. If I have to restore a package body and have to go to the point of doing a tablespace point in time recovery to an alternate node, do I only need the system tablespace or do I also need the tablespace that is the default tablespace for the schema that owned the package and body? -- .. David > >> You can't use LogMiner. Logminer can't reconstruct DDL. You can use >> CVS (or equivalent) or your documentation. What you may try is >> to look into the recycle bin, if you have it (oracle version 10g). >> If you have none of the above, then don't be a girlie man, sit >> down and white (spelling the Austrian accent) it from scratch. -- To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe To search the archives - //www.freelists.org/archives/oracle-l/