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

One thing you could try is to pre-create the table before you begin the import. Once the export is finished, you can drop and re-create the table using a regular SQL script (using the double quoting to specify the table name) to create the table with the new storage parameters, then run import.

I haven't tried this exact operation before, but I have pre-created tables before importing, and import just ignores the CREATE TABLE command in the *.dmp file.

Good luck. Received on Wed Jan 15 1997 - 00:00:00 CST