Thanks Razzak and Dan. The delete duplicates did the trick! Claudine
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Monday, November 21, 2016 4:11 PM To: [email protected] Subject: Re: [RBASE-L] - Seeing double... in 9.5 At 02:09 PM 11/21/2016, Claudine Robbins wrote: >Hello all, > >I backed up and ran the bup file for a database just now and noticed >that all my Stored Procedures are doubled, i.e. I have two copies of each one. > >Does anyone have any idea how to clean this up or is this something >R:Scope might fix? And, yes I have R:Scope. Claudine, Technically, there should be absolutely no duplicate Stored Procedures, especially when re-building the database. However, without knowing all details of your database, having proper user permissions, you should be able to eliminate duplicate Stored Procedures using the following command at the R> prompt: DELETE DUPLICATES FROM SYS_PROCEDURES Very Best R:egards, Razzak -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
