I have a 5 Million row table that I'm trying to recreate as a partitioned table sy roughly into partitons pt1,pt2.............now my question is after creating these partitons should i change my application who orginally say acessed the tables as

select * from t1

now should i go around and change the code at every place to

select * from pt1
select * from pt2

and so on ?what could be the repercussions of partioning a table

i am running oracle8.1.6 R2 on redhat linux 6.2