Michael Bayer ha scritto: > On Jan 2, 2009, at 11:51 AM, jo wrote: > > >> Seems SA checks if table already exist in all_tables system table... >> and creates it only if it doesn't exist. >> >> In my case... >> >> SQL> select table_name from all_tables where >> table_name='FUNZIONE_CALCOLO', returns: >> TABLE_NAME >> ------------------------------ >> FUNZIONE_CALCOLO >> >> SQL> select table_name from all_tables where table_name='TARIFFA'; >> no rows selected >> >> instead : >> >> SQL> desc FUNZIONE_CALCOLO >> ERROR: >> ORA-04043: object FUNZIONE_CALCOLO does not exist >> >> SQL> desc TARIFFA >> ERROR: >> ORA-04043: object TARIFFA does not exist >> ------------------------------------------- >> probably it is because I droped the table funzione_calcolo. >> Is it regular that FUNZIONE_CALCOLO is in all_tables yet? >> > > no this indicates something is wrong on the Oracle side. Perhaps a > table named funzione_calcolo exists under a different username ? > yes, Michael ...
SQL> select table_name,owner from all_tables where table_name='FUNZIONE_CALCOLO', returns: TABLE_NAME OWNER ----------------- ---------- FUNZIONE_CALCOLO SYS FUNZIONE_CALCOLO JO Sorry, I'm newbie to oracle. :-[ > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---