For this i believe you know your schema name and passward and your service name .
ok next step.
1. Create a batch file in your desktop ,
like : Click right buttom of your mouch in desktop , then new text document after that You created a
new text document file in your desktom .
2. then press F2 for rename it just rename > export.bat
3. then right button click of this file and click edit
and wright this :
suppose your database is on f drive and your schema name is hr and password hr and your service name is orcl then wright as below:
F:\ORACLE\PRODUCT\10.2.0\db_1\bin\EXP.exe hr/hr@orcl buffer=1048576 grants='n' file='c:\hr.DMP' FULL=Y log=C:\hr.log
in your c drive you see to file one is .dmp and .log file.
ok
ok next step.
1. Create a batch file in your desktop ,
like : Click right buttom of your mouch in desktop , then new text document after that You created a
new text document file in your desktom .
2. then press F2 for rename it just rename > export.bat
3. then right button click of this file and click edit
and wright this :
suppose your database is on f drive and your schema name is hr and password hr and your service name is orcl then wright as below:
F:\ORACLE\PRODUCT\10.2.0\db_1\bin\EXP.exe hr/hr@orcl buffer=1048576 grants='n' file='c:\hr.DMP' FULL=Y log=C:\hr.log
in your c drive you see to file one is .dmp and .log file.
ok
Time in Dhaka 
Very beautiful and necessary article. But what about importing data ?
ReplyDeleteDouble click in your desktop icon which you created export.bat file
ReplyDeletethen data is exporting and create in your desire location c drive which you define
and create a log file and dmp file.
ok enjoy.