You can do
CREATE TABLE LIKE ...
and
CREATE TABLE SELECT ...
but not:
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, 2013, Oracle Corporation and/or its affiliates. All rights reserved.