Database Oracle SQL Server Database Administration – Quick Copy of Table by Wade Coombs Sep 26, 2013 0 Comment Here is a quick way to create a copy of table: SQL Server: SELECT * INTO {NEWTABLENAME} FROM {ORIGINALTABLENAME}; Oracle: CREATE TABLE {NEWTABLENAME} AS (SELECT * FROM {ORIGINALTABLENAME});