Re: Exporting tables with lowercase names.

Russ -

Unfortunately, I've had to deal a bit with table and column names that just happen to be Oracle reserved words (the original data existed in MS Access or something similar...) and so I've had to use the double quote thing a time or two. What happens if the enclose the entire table name (including schema) in double quotes?

I.e. tables="USER.table_name"

Thanks,
TG

Russell wrote:

> Hi,
> I have a schema that uses all lowercase tables names, and must export one
> table.
>
> In my parfile, I have the following line:
>
> tables=USER."table_name"
>
> but I get a 'table "TABLE_NAME" does not exist' error.
>
> The documentation I have says that enclosing the name in double quotes makes
> it case-sensitive, but the facts don't seem to bear this out..
>
> Anyone else had any success with this?
>
> Russell

--
=====================================================
Thomas Gaines
Professional Research Assistant / Senior DBA
CIRES, NGDC/NOAA
303.497.3798  (office)
303.912.1241  (cell)
thomas.gaines_at_noaa.gov
=====================================================