where export file?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: where export file?

  1. #1
    Join Date
    Feb 2001
    Posts
    30
    Hi all,

    I need to backup my database structure. I try with Enterprise
    manager and exp command. Both show successful but I can't
    find saved backup file *.dmp. Either I define and default.

    User have exp_full_database for my created account. and I try with sysman on enterprise manager.

    Please advise me.

    ora8i on NT.

  2. #2
    Join Date
    Nov 2000
    Posts
    33
    run your exp utility and while giving dump file name to export specify the path also

    like : c:\backup\abc.dmp


  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    This is Rohit Nirkhe from India.In order to take backups using export or enterprise manager,u have to specify the whole path for ur dump file.

    e.g. exp sys/sys@bscs521 file=c:\data\users.dmp
    log=c:\data\users.log

    Same in the case of enterprise manager.
    In case of any help please be free to write to me
    at rohitsn@orasearch.net


    Regards,
    Rohit Nirkhe,Oracle DBA,OCP


  4. #4
    Join Date
    Feb 2001
    Posts
    30

    Thumbs up Really thank !!

    Thank to anujpathak and rohitsn.

    It works great!!

    Thank you again.

    Fog2k

Posting Permissions

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


Click Here to Expand Forum to Full Width