Is it possible while exporting, the dumpfile is exported as a text file so that we can see the contents of it?
For example I have exported just a table and what I require is to have a text file as a dumpfile.
No you cant read dmp file contents............but after exporting you can import it to the sqlfile where sqlfile contains all the DDL/DML command of those exp data
expdp user/paswd directory=dir_name dumpfile=user.dmp logfile=user.log
impdp user/paswd directory=dir_name dumpfile=user.dmp sqlfile=exp_user.sql
now sqlscript_user.sql contains all the DML/DDL commands..........where users can read
you can skip expdp part if you use network_link clause in impdp
Fran I am sorry if I am not able to convey my message. Suppose table has 100 records and i want to export it as a text file. When the text file is viewed it should contain those 100 records.
I hope you understand what my requirement is.