if the table isn't local i.e. database link you'll need to create a local version to sniff
CREATE TABLE foo AS SELECT * FROM [email protected] WHERE rownum < 11;
but surely this is enough? actually no, this will be a best guess by oracle.
if you need more control then the next bit of sql will allow you to tailor the schema create script without all the scripted guff that oracle likes to add.
SELECT DECODE(A.COLUMN_ID,1,'CREATE TABLE '
|| A.TABLE_NAME