>The view that failed did so because a view it used had been backed up >after it had - thus it failed to find a constituent part of its definition! > Hi Alastair
I find that permanent views are always a pain in the butt for this reason. They are also dangerous as anyone with permissions can change them giving rise to duff information from theron. For the sake of a line or two of code it is much safer to create a temporary view on the fly. BTW on the topic of BACKUP and RESTORE has anyone noticed a variable amount of garbage in a BACKED up file within and following GRANT statements. To date I have been unable to find the cause. Fortunately GRANT statements are at the end of the file. Regards Ian ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
