Create Table As

Create Table As  (CTAS) Note: Redo only created when in ARCHIVE LOG mode	CREATE TABLE <table_name> AS SELECT <column_name, column_name, ..., <column_name> FROM <table_name>;
	CREATE TABLE t AS SELECT * FROM all_tables;