Wednesday 16 November 2011

how to export your specified tables on oracle

Exporting data from oracle to file? 
hi friends this is the command for exporting specified tables on oracle database. it is very useful command on oracle software
where it is useful?

if you want to transfer data and that table structures then it is very useful to you

exp userid=username/password FILE=urname.dmp tables=table1,table2,table3................

here urname.dmp means it is dump file that contains all the details about that particular schema

No comments:

Post a Comment