Let me brief you my problem.Partitioning (works with partitions, not schemas)
Actually the data created for my application is in TB per year.
So whenever the year is completed, the data is moved from main schema to another schema.
This is done to make the query faster.
But whenever the old data is required, it might require the data from both the schemas.
So i wanted a select query to be fired ob both schemas using select query.
Range partition on that table will solve your problem.
So can we fire a single select query to read the data from both the tables in effective way. Eg select * from XYZ where date range between 15-Oct-2011 to 15-Mar-2012. However the data resides in 2 different schema altogether.