zircon06
Technical User
- Jan 8, 2007
- 81
Any one help me steps to restore into existing database from dmp file.
Thanks
Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Restore from dmp file
- Thread starter zircon06
- Start date
- Status
Hi ziron06
Could you provide a bit more info, was it exported from the same user/schema, is it a single table, multiple tables, from the same dB, from a different dB, etc... ?
A simple import would be :
imp user_name/password FILE=file_name.dmp IGNORE=Y TABLES= (tbl_nm_from_exp, tbl2_name_from_exp) LOG=path_to_log/imp-0316.log
Good luck
DrD
Could you provide a bit more info, was it exported from the same user/schema, is it a single table, multiple tables, from the same dB, from a different dB, etc... ?
A simple import would be :
imp user_name/password FILE=file_name.dmp IGNORE=Y TABLES= (tbl_nm_from_exp, tbl2_name_from_exp) LOG=path_to_log/imp-0316.log
Good luck
DrD
- Status