Thanks for the help, I'm still having problems but I'm closer.
Okay so I have taken the following steps:
1) Installed 0.6 from trunk.
2) Added echo='debug' to create_engine()
When I add tables to the database I always specify them as
schem.table_name as you mention.
The SQL statement that
Did you verify that the full query gives results?
SELECT table_name FROM all_tables
WHERE nvl(tablespace_name, 'no tablespace') NOT IN ('SYSTEM', 'SYSAUX')
AND owner = 'SCHEM';
I've been away from Oracle for a while, but I do remember it is unusual, but
still possible for user's tables to be in
Yes, I forgot to say about this.
The first query (the one that is conducted by SQLAlchemy) doesn't work
when run on the database.
The second query you provided, does work so it appears that my tables
are actually stored in the SYSTEM tablespace.
Do you know of a way around this?
On 18 Sep,
What does the second query report for tablespace_name? SYSTEM?
If so, you need to talk to your DBA about why the default tablespace for
your owner is SYSTEM. Normally the system is configured to have user tables
go somewhere else.
From the SQLAlchemy side, the maintainers of
Okay it is clear that this is a tablespaces issue. I should have
spotted it earlier. I'm sure all my problems will be resolved once I
just change the tablespaces to something other than system or sysaux
and get the default tablespace for the user changed.
Thanks for the assistance.
On 18 Sep,
On Sep 17, 2009, at 11:20 AM, tomolds wrote:
Hi,
I have exactly the same schema in Postgresql, MySQL and Oracle.
I am reflecting the tables in my application using: self.meta.reflect
(bind=self.engine, schema='schem')
This works perfectly for MySQL and Postgresql but for Oracle I get