Re: Data Dictionary problem?

In article <31jikn$6qs_at_mother.usf.edu>, reverly_at_ucs01.cfr.usf.edu (Raymond Everly) says:
>

I seemed to have figured out some of my own problem. The table I exported to ORACLE was named in lower case with lower case column names. But now how do I delete the lower cased named table? Are lower case table names and columns supported by Oracle 7 NT or should I always use uppercase names? Is there some database option I need to turn to support lowercase?

>I created a table in Oracle 7 from Microsoft Access using the ODBC driver. I can connect to the
>table remotely using Access and view records in the table. However, when I issue a select statement
>from SQL DBA Oracle says the table does not exist. I can do a 'select * from USER_TABLES'
>and I can see the table is there in a tablespace other than the user's default. Is it neccessary to qualify
>the tablespace name? Or is it possible that my database is corrupted and if so how do
>I correct it?
Received on Tue Aug 02 1994 - 00:04:30 CEST