On Thu, 2002-10-24 at 19:39, Carlos García Gómez wrote: > Hi all! > > I've got the following problem: I had a view with OID 5330 that had to be > removed from the database, afterwards I created again a view (with the same > name, because I need it to be this way) and get the an error telling me that > the view with OID 5330 cannot be found, How can I solve it?? You need to redefine the thing that you do not mention which refers to the view - possibly this may be another view. When you recreate that, it will be created referencing the correct OID. Regards, Andrew. -- --------------------------------------------------------------------- Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St DDI: +64(4)916-7201 MOB: +64(21)635-694 OFFICE: +64(4)499-2267 Survey for free with http://survey.net.nz/ ---------------------------------------------------------------------