My database is getting rather large and I am deleteing old records. There is one table, VIEWITEMMOVEMENTHISTORY, that has numerous records but when I try to delete the old records I get the error: UNION ALL view 'VIEWITEMMOVEMENTHISTORY' is not updatable because the definition contains a disallowed construct.
Does anyone know how to go about deleteing the records from this table?
That's not a table. It's a VIEW, which is sort of a stored query. A view does not contain actual records - it is a query that returns records from other table(s).
The best place to start reclaiming space is usually the journal table. I believe there are Knowledge Base articles on archiving available on Customer Source and Retail Realm has an archiving utility that will take care of it for you.
Glenn Adams Tiber Creek C> My database is getting rather large and I am deleteing old records. There is
Have something to add? Share your thoughts — no account required.
Ask the community — no account required