-
using exp,SQL DBA need help
Hi,
am not oracle dba and I have to backup oracle 8 db using exp command (exp userid=valid_user/valied_pass full=y )
my questions
1. to run command do have to login directly on server hosting
db or it could be done from station having admin tools?
2. if server hosting more then 1 db ,where in command to specify db name?
3. is it possible to specify location for full backup using exp
Thanks
Alex
-
1. you can run it from anywhere, but it may be slow on client as file will be written where you run it from.
2. you can set oracle_sid variable or do valid_user/pass@oracle_sid
3. yes, parameter is file=
for other options, run exp -help at command prompt.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|