| Oracle exp command for a remote database [message #62760] |
Thu, 12 August 2004 01:33  |
Kusuma Sashidhar
Messages: 1
Registered: August 2004
|
Junior Member |
|
|
Hi,
I have multiple database servers. I would like to create backup script on one server to take all the databases dump. Currently I am taking the export user by user, by using "exp user/passwd@remotedatabase file=file.dmp owner=user".
Now I would like to take a full dump as oracle user. How should the export command be? If it was local database, then I could have said "exp / file=file.dmp full=y" as oracle user. Now how can i specify @REMOTEDATABASE?
Please help.
Regards
Kusuma
|
|
|
|
| Re: Oracle exp command for a remote database [message #62763 is a reply to message #62760] |
Thu, 12 August 2004 03:08  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
In USERID parameter use appropriate connect string to connect to a particular database and by this you can get connected to the remote database and take a logical backup of it. For example use following :
exp userid=system/manager@remote1 file=file1.dmp full=y
Use a user who have appropriate privileges to export the database.
Daljit Singh
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
