Create a Backup of a Table in an Oracle Database
Read Time:17 Sec
I seem to have to look this one up each time…
The SQL statement below will create a duplicate of a table in an Oracle Database.
CREATE TABLE NewTableName AS SELECT * FROM ExistingTableName;
Hope this helps someone else.
Let me know how it worked for you or if you have improvements to it in the comments.
Happy
0
Sad
0
Excited
0
Sleepy
0
Angry
0
Surprise
0
Average Rating