5 Replies Latest reply: Jun 23, 2012 12:33 AM by JustinCave RSS

    database export

    875255
      if i export the database for backup it saves the .dmp file on default location in "C:\Documents and Settings\user". if i want to change that location how to change that?
        • 1. Re: database export
          415289
          if using exp give full path in FILE parameter
          incase of expdp create directory with full path where you want to store dmp.
          • 2. Re: database export
            875255
            im using exp. how to give parameters
            • 3. Re: database export
              Mahir M. Quluzade
              If your dmp file in C:\Documents and Settings\user\TEST.dmp
              You can copy to D:\DUMPS\TEST.dmp and use this file with IMP as
                imp user/password file='D:\DUMPS\TEST.DMP' 
              Regards
              Mahir M. Quluzade
              • 4. Re: database export
                875255
                do we have an option like some software which automatically(makes backup after a specified period like after every hour) makes backup of the whole database as .dmp and saves it to specified location?????
                • 5. Re: database export
                  JustinCave
                  1) Although a dump file is a logical backup, I sincerely hope you are not using it as your primary method of backing up a database. You need physical backups (RMAN or user-managed). Logical backups can compliment but not replace physical backups.

                  2) You could certainly schedule the export utility to run regularly and to write files to whatever location you desire. It would be exceedingly unusual to want a full database export every hour however. That generally implies that you're doing something wrong.

                  3) This doesn't appear to relate to database security. It would probably be more appropriate in the Export/Import/SQL Loader and External Tables forum or even in the Database - General forum.

                  Justin

                  Edited by: Justin Cave on Jun 23, 2012 1:30 AM