Create A table B, table structure exactly the same as that of A table structure, keep the B table with A table of data real-time synchronous

CodePudding user response:

To build up the table b materialized views each time you submit a table refresh

CodePudding user response:

Select into

CodePudding user response:

Try the trigger,,,

CodePudding user response:

1/f, positive solutions, materialized views is best but there are table structure changes have to start over again

CodePudding user response:

In addition to creating materialized views, but also can create timing synchronization JOB, such as once per second, or trigger will do