Re: Importing tables with funny names

Jim Yoshii wrote:
>
> A user of our database has created tables with names like "_TABLE_"
> (don't ask why cause I don't know). By double quoting the table name in
> his SQL statements he can perform any normal operations. The problem
> occurs when we do database exports. Tables with names like this export
> OK, but when we try to import them the import fails with an invalid
> character error because import doesn't double quote the table name when
> it attempts to create the table!
>
> Can anyone think of a decent work around?
>
> TIA,
>
> yoshii_at_planet.net

If there is not too much tables of this kind and if they ar not too much refered (in any way) in the database then you could create them manualy and then import with IGNORE=Y.

I think it would be mutch more simple and better if you rename all that funny-named tables using "RENAME old TO new;" before you export. This will elimenate all such troubles in the future.

Regards, Jure

-- 
 ===============================================================
 ! Jurij Modic                            Republic of Slovenia !
 !  tel: +386 61 178 55 14                Ministry of Finance  !
 !  fax: +386 61  21 45 84                Zupanciceva 3        !
 !  e-mail: jurij.modic_at_mf.sigov.mail.si  Ljubljana 1000       !
 ===============================================================