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.

Recommended Answers

Put this in a batch file and call as desired.
[CODE]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[/CODE]

Jump to Post

All 6 Replies

Re: oracle Backup 80 80

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

Re: oracle Backup 80 80

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?

Re: oracle Backup 80 80

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

Re: oracle Backup 80 80

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

Re: oracle Backup 80 80

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
commented: Marvellous, Thanx +4
Re: oracle Backup 80 80

Thanx Man....

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.