Subodh, Look at the "CREATE TABLE" documentation. It's very easy to do what you want to do. Tom ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Subodh Deshpande Sent: Tuesday, December 23, 2008 9:38 AM To: ORACLE-L Subject: partation, table and tablespaces hi, is it possible to create a single table with partations in different tablespaces, as per my understanding other IOT we can not assign multiple tablespaces for a single partationed table. e.g requirement is -- a is table will have a1,a2,a3 partations in aa1, aa2, aa3 tablesapces