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 the SYSTEM or SYSAUX tablespaces.

Double check with

SELECT table_name, tablespace_name  FROM all_tables WHERE owner = 'SCHEM';

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to