January 16, 2011

How to Create OracleDUB File

To export the file from the oracle from "scott" user
****************************************************
1.select start-->select Run-->enter cmd-->click ok-->go to D drive

2.Type the following command in the command prompt


d:\>exp scott/tiger file="scott.dmp"
*************************************************************
Import the dump file into our oracle of "scott" user
************************************************************
1.select start-->select Run-->enter cmd-->click ok-->go to D drive

2.Type the following command in the command prompt


d:\>imp scott/tiger file="scott.dmp" full=y
*******************************************************
Note:In the Oracle database an account on scott must be exist in our db

No comments:

Post a Comment

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

My Favorite Site's List

#update below script more than 500 posts