Re: ORACLE 6 - ODBC - ACCESS

Stefan Buecken wrote:
>
> Hi,
>
> I am working on an old ORACLE 6 server. With a little luck I managed to
> establish an ODBC-connection between Access 2.0 and this Oracle server.
> I tried to import tables from Access to Oracle. This worked well until I
> made a typing mistake. One tablename in Access started with lower case
> letters. This table has been imported into the Oracle database correctly
> but it is not accessible in Oracle. When I list the tables by 'select *
> from tab' the table is listed. When I import the table via ODBC into
> Access the datas are shown. When I try to access the table in Oracle I
> get an error message that the table is not existing.
>
> Does anyone know how I can access or drop this table? I have dba rights,
> this would allow to delete the entries about the table from the system
> tables (OBJ$ aso.). Because I am not familiar with the basic structur of
> oracle this seems to be to dangerous for me.

  It is very dangerous to touch the system data dictionary directly except AUD$. As a result do not try to delete records from data dictionary. You can find the table name from the DBA_TABLES. In your case, your table name may consist some special characters. As a result, you can get the your table name into a variable from DBA_TABLES and drop the table by using this variable.

---
Name   : Lun Wing San (Certified Oracle Database Administrator)

Title  : Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.