On 15 Sep 2006 10:34:20 -0700, soalvajavab1@yahoo.com wrote:

>I export an access table using Oracle ODBC driver to Oracle schema,
>it add character " to table name and all its column names like this
>
>"ff_to_oracle"
>(
> ID VARCHAR2(20),
> "empid" VARCHAR2(20),
> "empname" VARCHAR2(50),
> "empdept" VARCHAR2(20),
> "create_date" DATE
>)
>
>and when I want to query the imported table in Oracle I have to say:
>
>select * from "ff_to_otracle"
>
>
>Is there anyway to get rid off " charater during the ODBC process?
>Thanks for help

There is:
Make sure ALL of your identifiers (table names, column names etc), are
in UPPERCASE prior to conversion.
So
FF_TO_ORACLE
(ID
EMPID
EMPNAME
EMPDEPT
CREATE_DATE

etc.

This is a known feature and has been documented here often. You could
have searched http://groups.google.com prior to posting.

--
Sybrand Bakker, Senior Oracle DBA