2 Replies Latest reply: Feb 27, 2013 5:20 PM by Sasi Nagireddy RSS

    Importing Dump

      Hi Experts.

      I have downloaded the file i.e Dump File .Now i want to import into the database,How to do that?

      Please advice.
        • 1. Re: Importing Dump
          Sasi  Nagireddy
          You mean Sample Dump File into the database

          Here the steps:-
          Connect to SQLPLUS

          Create user Dump identified by pwd;
          grant dba to dump;

          Now come out from sqlplus and in the command prompt do the following.

          You want to import data only "Y" "N" ---- "N'
          Buffer Size ---- "999999"
          From there every thing give "N"

          Do let me know if it is confusing i can guide you.


          Edited by: Nagireddy on Feb 27, 2013 6:15 PM
          • 2. Re: Importing Dump
            Sasi  Nagireddy
            Do let me know if it is confusing,

            Below my mail id :-


            Send a test a mail i can help u.