First - your question has NOTHING to do with Sql Developer which is the topic for this forum. Please mark the thread ANSWERED and repost in the General DB forum.
For reasons unexplained I am trying to sync up columns_id between two tables with the same columns in both, but in different ordering.
The reasons are 'unexplained' because you haven't explained them.
There should be a DBMS method to reorder the columns.
No - there should NOT be such a method.
In database work the order of the columns in a table has no meaning/significance at all. It is totally irrevelant.
And with Oracle it is NOT possible to try to control it since there are MANY things that cause Oracle to create new columns that you likely aren't even aware of.
Create an object type with 5 attributes and use it as a column: Oracle will create SIX new columns. One of them is visible but the other 5 (that match the 5 attributes) will be hidden.
That ordering you are trying to do using visible/invisible does NOT change the physical order of the columns. It ONLY changes the logical Oracle.
Your code/apps have a MAJOR flaw if they try to depend on the physical order of columns.
And if you want a specific logical order just create a view and order the projected columns any way you wish.
If you need more help than the above please repost in the proper forum.
Well, i think think that is the correct forum, which part of 'ideas' grants one to be the gatekeeper?
I say let OP post andd let general population decide rather than one person, you are welcome to post your opinion about this idea in that forum not here.