duplicate database table.
I was in need to duplicate oracle database tables. Couple of ‘em. SQL Navigator is the standard application for Oracle database in my company and I was looking for a command in the app. I couldn’t find it.
So I asked my co-worker about that and he handed me an Oracle book.
Here we go. I found a great SQL statement to duplicate tables.
CREATE TABLE tableName AS SELECT * FROM tableName2
What a good trick!
