Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

-- This is the already existing table
CREATE TABLE Test( Test1, Test2) AS
SELECT 1,'ABC' FROM dual UNION ALL
SELECT 2,'DEF' FROM dual 
2 rows affected

CREATE TABLE Test_( Test1 INT GENERATED ALWAYS AS IDENTITY, Test2 VARCHAR2(99));
BEGIN
 INSERT INTO Test_(Test2) SELECT Test2 FROM Test ORDER BY Test1;
 INSERT INTO Test_(Test2) SELECT Test2 FROM Test ORDER BY Test1;
END;
/
1 rows affected

DROP TABLE Test
ALTER TABLE Test_ RENAME TO Test
SELECT * FROM Test


TEST1
TEST2


1
ABC

2
DEF

3
ABC

4
DEF