Re: Drop and Create , if act201.dat and act201.idx are missing

In article <oserjCnIIM4.742@netcom.com> oserj@netcom.com (Jim Oser) writes: > >I have a database with a table act. > >If I > mv act201.idx act201.idx.bak > mv act201.dat act201.dat.bak > >then if I try to drop the table act, > >I get the error message -545 No write permission for table table name; > >if I then try to create a new table act, > >I get error message -310 cannot create table, it already exists. > >So my question, which is somewhat academic, is there a way >that I can create a new table act using esql/c commands >for SCO unix without doing a > mv act201.dat.bak act201.dat > mv act201.idx.bak act201.idx You could do: cp act201.dat.bak act201.dat cp act201.idx.bak act201.idx But somehow I think you're looking for more than that. :) I think you are neglecting to note that there are system tables that have the act table in them. And, syscolumns has the columns of the act table. You're removing (mv them) hasn't changed a thing in the systables! The 'act' table is still table id #201 and the database is just not able to find it. Bob -- ------------------------------------------------------------------- * Bob Beaulieu (bobb@netcom.com) eztravel@netcom.com * * Tel: 408-978-0808 Fax: 408-978-7024 * * Corporate Travel Services * -------------------------------------------------------------------