Oninit cdi / Archive
Talk to an expert →

Tables corrupted

Posted in 2014

Topics: General Discussion

KAMLESH GALLANI — — source: IIUG Forums & Mailing Lists

Hi, I have a database (11.70)in which all table names have changed as below: Previous Name - content New Name - /content Previous Name - edu_comm New Name - /edu/_comm and so on. I am able to do dbschema, but when doing select , it is throwing syntax error, for not recognizing '/' in the table name. The DB is 1.6 TB. Is there any way of restoring the service as soon as possible?

↪ replying to KAMLESH GALLANI
Jack Parker — — source: IIUG Forums & Mailing Lists

Have you tried =93rename table=94? j. On Jan 19, 2014, at 12:09 PM, KAMLESH GALLANI = <kamlesh.gallani@cognizant.com> wrote: > Hi,=20 >=20 > I have a database (11.70)in which all table names have changed as = below:=20 >=20 > Previous Name - content=20 > New Name - /content=20 >=20 > Previous Name - edu_comm=20 > New Name - /edu/_comm=20 > and so on.=20 >=20 > I am able to do dbschema, but when doing select , it is throwing = syntax error,=20 > for not recognizing '/' in the table name.=20 >=20 > The DB is 1.6 TB.=20 >=20 > Is there any way of restoring the service as soon as possible?=20 >=20 >=20 > = **************************************************************************= *****=20 > Forum Note: Use "Reply" to post a response in the discussion forum.=20= >=20

↪ replying to KAMLESH GALLANI
Art Kagel — — source: IIUG Forums & Mailing Lists

Does dbschema show the modified names or the original ones? Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sun, Jan 19, 2014 at 12:09 PM, KAMLESH GALLANI < kamlesh.gallani@cognizant.com> wrote: > Hi, > > I have a database (11.70)in which all table names have changed as below: > > Previous Name - content > New Name - /content > > Previous Name - edu_comm > New Name - /edu/_comm > and so on. > > I am able to do dbschema, but when doing select , it is throwing syntax > error, > for not recognizing '/' in the table name. > > The DB is 1.6 TB. > > Is there any way of restoring the service as soon as possible? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c3560c4552cb04f059d78d

↪ replying to Jack Parker
marions@muenchen-mail.de — — source: IIUG Forums & Mailing Lists

Hi, have you tried env var DELIMIDENT=Y ? Set DELIMIDENT=Y and put the table name in double quotes like here: rename table "/tab1" to "tab1" Table renamed. Please note that strings have to be enclosed in single quotes with this setting. HTH. Marion Am 2014-01-19 18:18, schrieb Jack Parker: > Have you tried =93rename table=94? > > j. > On Jan 19, 2014, at 12:09 PM, KAMLESH GALLANI = > <kamlesh.gallani@cognizant.com> wrote: > >> Hi,=20 >> =20 >> I have a database (11.70)in which all table names have changed as = > below:=20 >> =20 >> Previous Name - content=20 >> New Name - /content=20 >> =20 >> Previous Name - edu_comm=20 >> New Name - /edu/_comm=20 >> and so on.=20 >> =20 >> I am able to do dbschema, but when doing select , it is throwing = > syntax error,=20 >> for not recognizing '/' in the table name.=20 >> =20 >> The DB is 1.6 TB.=20 >> =20 >> Is there any way of restoring the service as soon as possible?=20 >> =20 >> =20 >> = > **************************************************************************= > *****=20 >> Forum Note: Use "Reply" to post a response in the discussion >> forum.=20= > >> =20 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum.