easiest way to clone a table?

From: <mh_at_pixar.com>
Date: Wed, 24 Sep 2008 00:14:22 GMT
Message-ID: <yDfCk.1142$x%.1090@nlpi070.nbdc.sbc.com>

Given a table FOO, what is the easiest way to create a table COPY_OF_FOO that has identical schema, indexes, etc.?

Preferrably something that can be scripted or performed programatically, and not via Toad, etc.

Many TIA!

Mark Harrison
Pixar Animation Studios
Received on Tue Sep 23 2008 - 19:14:22 CDT

Original text of this message