Using SQL Developer, I am trying to copy the data from a Materialized View on one database/connection to a table (of the same name) on another database/connection.
The name and columns of the MV and table are exactly the same.
I tried to use the database copy tool on SQL Developer but I ran into errors. I am not very sure which options I should check/uncheck.
I am using: Oracle 19c
SQL Developer version: 21.4.3.063 Build: 063.0100