Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Recovering from Oracle 7.1(SCO Unix) database crash
I had a cold backup of all database files. I restored this to the oracle partition.Then I imported from a previous export backup using full option.The import log showed several errors because of existance of various objects. So I dropped all tablespaces created by me with cascade constraints option and then tried the import.Some errors were still reported.
How do I ensure that the latest version of objects like Procedures,
Functions etc. are imported?
Are these stored in the user tablespaces or the system tablespace?
Do the sys objects like Views, Synonyms, Procedures, etc ever change and
if so do these get imported if a later version is in the export backup?
--
Posted via CNET Help.com
http://www.help.com/
Received on Tue Jan 23 2001 - 01:30:07 CST