oracle Backup

[Majestics]

How to take a user table backup from that user account? I mean i want to give him grants to take backup... also query to take backup.

[debasisdas]

You need to run the EXP utility from the user account.

[Majestics]

thank you debasisdas for posting, i already tried that, i m using java to take backup of oracle.... I want user to take backup remotely from any computer.. For exp he must have oracle installed.... Any idea?

[debasisdas]

1. create a backup script.
2. store it in the server.
3. call it remote when required.

[Majestics]

It will be very kind if u post a sample script.... or just algorithm in post

[debasisdas]

Put this in a batch file and call as desired.

for /f "tokens=2,3,4 delims=/ " %%a in ('date /t') do set fdate=%%a%%b%%c
for /f "tokens=1,2,3,4,5 delims=: " %%a in ('time /t') do set ftime=%%a%%b%%c%%d%%e
exp userid=DEBASIS/DEBASIS@DEBASIS_DB file=C:\BACKUP\backup%fdate%%ftime%.dmp log=C:\BACKUP\backup%fdate%%ftime%.log

[Majestics]

Thanx Man....