I have a table1 which I've been loading data into for the last 6 months. The requirement now is to load all that data into another table2.
Is there a way that the data in table 1 can appear as if it exists in table 2 (only or too)? or something? because I can start loading data into table2 but I also need the last 6 months data (from table2).
Basically, I have some reports containing KPIs (which have formulas) which are created from some views which in turn are created from schema a.table a.
Now there was some new data (counters) which I started loading into schema b. table b.
Now I need to add some more KPIs to this report (making formulas using the counters in schema a. table a). But the query of the report is already showing KPIs (formulas created using counters from schemab. tableb.)
Silly question is:
Any way to do select counter1, counter2, counter3 from CELLSTATS?
Silly answer: generally no way. How would you relate them, if counter1 would be number of calls abroad and counter4 number of calls to the same network?
Anyway, there is a possibility that counters are in some relationship. It is data specific, so only the analyst (= the person who took user requirements and designed tables) should be able to tell this. It has nothing to do with Oracle (the way data is stored). Maybe you should ask him/her directly.