WL#2200: CREATE TABLE ... LIKE ... SELECT ...
You can do
CREATE TABLE LIKE ...
CREATE TABLE SELECT ...
CREATE TABLE LIKE ... SELECT ...
The latter being the equivalent of a COPY TABLE (WL#1071), a single-command
operation which would make life somewhat easier on db admins.
Copyright (c) 2000, 2017, Oracle Corporation and/or its affiliates. All rights reserved.