-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|