I use exp and expdp to export database tables on command line but it generates binary .dmp files. I want to export/import tables as .sql* files on command line like pl/sql developer app can do. Is there a specific command for this or extra parameters for exp/expdp?
*sql files must contain table creation scripts and insert statements.
Thanks.
Best Answer
You can generate DDL statements using imp/impdp utilities:
But this method will generate just schema DDL. INSERT statements will not be generated.