table partitioning
One of our Vendor specific applications makes a ODBC connection to the Oracle DB. The DB has 3 tables that make 80% of our DB. Since we keep 5 years of data due to client requirements. So the data is huge. One of things I am looking at is to partition the tables. The vendor says the application would not support partitioned tables. I am not sure if this is true. Is it not the partitioning of table in Oracle is seemless to the application and oracle manages the data retrieval internally? Please let me know.