Wednesday 16 November 2011

import dump file to oracle

How to Import dump file to Oracle ?

this is command for importing data to oracle. here filename.dmp means it is dump file that contains all the details about ur schema structure and ur's tables data
systax:  
imp username/password file=filename.dmp full=Y rows=Y( whenever u r specifying full=Y then rows=Y is optional)

No comments:

Post a Comment