Andrew, Why can't you put the original table back where it original was?
Regards, David -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Gissing Sent: Tuesday, 18 May 2004 4:33 PM To: [EMAIL PROTECTED] Subject: [U2] Delete from UV_TABLES I've got a problem with odbc access to a particular account. I've traced the error to it's source, and i'm trying to figure out if I can fix without dropping the schema. Some time ago we created a new account and used the CREATE SCHEMA command. We then used a series of CREATE TABLE commands. I suspect that at some point I moved a file from residing in that account to another account, and then probably deleted the VOC entry in the original account whilst creating a new entry in the new account. So what my little handiwork did was leave intact entries in UV_TABLES and UV_COLUMNS to a file that no longer exists at the original path name. [snip] So... in a nutshell, is there a way of fixing this error short of copying the files, dropping the schema, re-creating the schema, re-creating files, copying data from the old-renamed files to the newly created ones then deleting the old-renamed files ? This is a long email - and i've you've gotten this far, I thank you for your time ! ------- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
