Re: Stored Procedure to create table
Phill,
I understand what you are saying, and I don't disagree, however the original tables are auto-generated by month and year, the columns and data looking like this:
tagid | intvalue | floatvalue | stringvalue | datevalue | dataintegrity | t_stamp
53 null 866.1231558786465 null null 192 12345678978413132
the primary key consists of tagid and t_stamp.
The data written to these tables comes directly from the machines and controllers. So far I have found from 190k to 400k records in any one table.
What we want to do is move them to another schema to clean things up a bit, then perhaps, find a solution to use a single table for reporting purposes. However, I am not sure that the HMI (human machine interface) would be able to correctly read the recent data accurately.
Anyway, the goal is to create a stored proc that I could use to recreate the tables in another schema, then perform batch inserts, say like 50-100k at a time to reduce server traffic and resources.
Mike
Subject
Views
Written By
Posted
342
July 13, 2022 02:54PM
186
July 13, 2022 03:16PM
135
July 14, 2022 02:03AM
Re: Stored Procedure to create table
118
July 14, 2022 08:57AM
135
July 14, 2022 10:42AM
123
July 15, 2022 11:10AM
137
July 15, 2022 08:34PM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.