Create a copy of an Oracle table without copying the data? Shadab Mohammad 11 years ago Do a "create table" as command without selecting any rows create table abc_new as select * from abc where 1=0; Share this: Creating Table from another Table : OracleApril 29, 2010In "Database"Oracle External TableDecember 24, 2012In "Database"Use datapump(impdp) to import a table : Oracle 10gMay 6, 2010In "Database"