This has to be something I am missing…
I need to pull a subset of data from a table in an existing database to another on a different instance.
The problem I have is that the new table has a UID field which is populated by a sequence / trigger pair and the data subset has no UID field.
I played around for an hour or more before I resorted to coding the PL-SQL to do the job - this is surely one of the things which TOAD is designed to help with!
Thanks for any advice - I will gladly admit to being a contender for the Technical With All Things award for this week when somebody points me to the simple solution…