Results 1 to 3 of 3

Thread: using exp,SQL DBA need help

  1. #1
    Join Date
    Sep 2002
    Posts
    159

    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

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    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.

  3. #3
    Join Date
    Oct 2005
    Posts
    2,557

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •