I am using SQL Developer with a 12c database and have a database with tons of ID columns that are auto-generated.
I am now in the process of exporting this data to another database and generated to scripts for all the data, except that the ID data is being put in those scripts.
When I try to use these import statements, it obviously fails because the ID column is set to auto-generate.
I have looked in the export wizard in SQL Developer to find a way to generically remove the ID column and I don't see one.
I have hundreds of tables so going through and unchecking the ID column on each is going to be very time consuming.
Anyone know if a simple way to do this?
Thanks!