SQLFILE parameter of impdp data pump import can help you in generating SQL Script of all the DDL that import would have been executed. In this video I have explained the steps of how you can do that. Hope you find it helpful. Thanks for watching. Have a great day!