Home » RDBMS Server » Server Utilities » Full Database Export
Full Database Export [message #71098] Mon, 09 September 2002 01:40 Go to next message
dipin ojha
Messages: 6
Registered: September 2002
Junior Member
Can anybody tell me the way to export a whole database?
step by step procedure.

Report message to a moderator

Re: Full Database Export [message #71099 is a reply to message #71098] Mon, 09 September 2002 02:07 Go to previous message
K.K. Raj kumar
Messages: 33
Registered: July 2002
Member
Hello,

You can use exp utility to Export the full database.
For eg:

exp userid=backupuser/backuppwd buffer=4194304 file=$fname compress=Y
grants=Y indexes=Y rows=Y full=Y constraints=Y


The user backupuser should have the privilege exp_full_database so that it will have the Entire Database backup privilege.

Report message to a moderator

Previous Topic: beginner..how to back up my database
Next Topic: please need help with oracle8i lite
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 04 04:10:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.