All, So have a 'working' solution but think it is pretty bad... Someone MUST have a better solution. Here is what I had to do:
1. Have create_all explictly not test for tables existing (or else it finds it in wrong schema) create_all(checkfirst = False) 2. Explictly set the schema and owner options_defaults['table_options'] = {'schema':'cram','owner':'cram'} 3. Modify every Foreign_Key reference and prefix the schema name created_by = Field(Integer, ForeignKey('cram.app_user.control_number', name = 'property_profile_created_by_fk', use_alter = False), nullable = True, index = True) #Link field for link CreatedBy 4. Turn off use_alter in each Foreign Key ref (see above) 5. *** Modify schema.py default Index creation to truncate at 30 chars uniquely global _i_count _i_count+=1 Index('ix_%s%d' % (self._label[:22],_i_count), self, unique=self.unique) 5b. The above will go away in next pass when I set index=False and manually add the Indexes Anyone else have a cleaner incantation? Thanks, Brandon On May 23, 3:10 pm, Brandon Goldfedder <[EMAIL PROTECTED]> wrote: > All, > Perhaps someone can help me here since I am in that 'bad place' where > I am retrying things again and getting deeper than I want into it. > > I am trying to create a database (using elixir model although the > problem appears to be in sqlalchemy so asking here) in Oracle > Express. > > The problem I think is that the table names I am using exist in other > schemas. > > Before I set schema and owner I was getting the ORA-00942 error which > I think was that it was finding the table names in other schemas and > attempting to use them in the foreign key reference. > > Now, I am passing both schema and owner explictly for the table > (using_table_options(schema='cram',owner='cram')) and I now get: > > File "C:\PYTHON25\lib\site-packages\sqlalchemy-0.4.6-py2.5.egg > \sqlalchemy\sche > ma.py", line 788, in column > "foreign key" % tname) > sqlalchemy.exceptions.NoReferencedTableError: Could not find table > 'property_ite > m' with which to generate a foreign key > > Debating if I abandon using sqlalchemy to generate the creation DDL > and just use it for mapping or if there is a better solution anyone > has. > > Any help/Best Practices/Incantations in getting Oracle to work right > appreciated, > > Thanks, > Brandon --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---