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 : OracleDateApril 29, 2010In relation toDatabaseOracle External TableDateDecember 24, 2012In relation toDatabaseUse datapump(impdp) to import a table : Oracle 10gDateMay 6, 2010In relation toDatabase