So you want someone to show you how to create a list partitioned table and use the sys_context to filter for records from one country. For each partition you can specify a table space. Now what do I get for helping you to get a good grade?
http://docs.oracle.com/cd/E11882_01/...1.htm#i1006532Code:WHERE country_id = CASE sys_context('USERENV', 'CURRENT_SCHEMA') WHEN 'PRTN_US' THEN 'USA' WHEN 'PRTN_CA' THEN 'CA' ELSE 'WTF' END;
http://psoug.org/reference/sys_context.html




Reply With Quote