Best way to grabe the schema objects

[Chandra]

What is the best way to grab the schema object. (Import)
Thanks.

[jlakhani]

can you rephrase your question? Are you saying you want to extract an object's ddl? or the object and its data? particulary a table I assume? if yes then you can use export.

[Chandra]

I am sorry, i want to extract object's DDL for (TABLE/VIEWS/ etc)

Thanks.

[dknight]

In your export, use the option

ROWS=N

[jlakhani]

You can also use Toad/Sql Navigator to extract object DDL.

[pando]

show=y

or indexfile=x