Originally posted by Sekhar
Table Name : table1 having four columns

col1 col2 col3 col4 .

Now i am planning to put col1 and col2 in one tablespace and col2 and col3 in another tablespace. But for the developer the table should be appear as one table.
This requirement has nothing to do with any kind of Oracle's partitioning (hash, range, list). In fact this is not possible unless the table is IOT (index organized), where you can define columns col3 and col4 to be stored in an "overflow segment" of IOT, which can be located in other tablespace than your "index portion" of the same row (col1 and col2).

The only other sollution would be to split your table into two separate tables that would both contain your current primary key columns and present those two tables to your developers as an equi-join view of those two new tables.