About about doing a create table as select * from ???
---------------------------
SQL> create table capper as select 'GGGGG' col1, 1000.11 col2 from dual;

Table created.

SQL> select * from capper
2 ;

COL1 COL2
----- ----------
GGGGG 1000.11

SQL> create capper2 as select * from capper;
create capper2 as select * from capper
*
ERROR at line 1:
ORA-00901: invalid CREATE command


SQL> create table capper2 as select * from capper;

Table created.

SQL> select * from capper2;

COL1 COL2
----- ----------
GGGGG 1000.11

SQL>
-----------------------------


Or you could export import the table.

regards,

Adam