On 01/02/2016 07:24 PM, Nana Okyere wrote: > The tables are not in an explicitly named schema. By default, it uses > the schema of the user logged in. Looking at the debug output on the > console, I can see that it uses the correct schema i.e. SYSTEM.
that's the problem; it's not appropriate to create end-user tables in SYSTEM on Oracle, that account / schema is for administrative tables only. You can see that SQLAlchemy's reflection queries explicitly skip over SYSTEM so that these administrative tables aren't included in table lists. See http://www.dba-oracle.com/t_sys_sstem_dictionary_schemas.htm for details on the SYSTEM schema. I'm assuming you're using Oracle because this is part of a job. If you're strictly learning about databases and don't actually need to use Oracle, it's one of the worst databases to practice on as it's very old, "enterprise" and loaded with esoterics; I'd start out with a Postgresql or MySQL. > > I set the logging to debug and went through the whole process. I'll > attach the entire output. I'm using flask-migrate, which just puts a > nice wrapper around alembic for flask development purposes. So the > 'migrate' command is a proxy an alias for autogenerate. 'upgrade' and > 'downgrade' are the same. So please see the output attached. Thank you. > > Nana > > -- > You received this message because you are subscribed to the Google > Groups "sqlalchemy-alembic" group. > To unsubscribe from this group and stop receiving emails from it, send > an email to sqlalchemy-alembic+unsubscr...@googlegroups.com > <mailto:sqlalchemy-alembic+unsubscr...@googlegroups.com>. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "sqlalchemy-alembic" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy-alembic+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
