OraFAQ Forum: Server Utilities » database full export

Home » RDBMS Server » Server Utilities » database full export

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

database full export [message #70823]

Sun, 28 July 2002 22:34

jag
Messages: 15
Registered: July 2002

Junior Member

hi,
i would like to know how a particular user can be given the privileges so that a full/incremental/cummulative backup can be taken from that user. it must also update the sys files INCVID,INCFIL, & INCEXP.

thanks.

Report message to a moderator

Re: database full export [message #70831 is a reply to message #70823]

Mon, 29 July 2002 02:42

sunil bhola
Messages: 58
Registered: July 2002

Member

for this the user must have EXP_FULL_DATABASE & IMP_FULL_DATABASE privilege.

but if the user have CREATE SESSION privilege then he/she can export ONLY his/her scheme data.

how to assign privilege to the user

grant exp_full_database, imp_full_Database to sunil;

Report message to a moderator

Previous Topic:	very urgent..........
Next Topic:	Importing very Slow??? HELP NEEDED URGENTLY??

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 04 11:39:02 CDT 2024