0

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.

2
Contributors
6
Replies
7
Views
6 Years
Discussion Span
Last Post by Majestics
0

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?

0

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

1

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

Edited by debasisdas: n/a

Votes + Comments
Marvellous, Thanx
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.