2 Replies Latest reply: Feb 24, 2014 6:03 AM by 816575 RSS

    Migrate to Exadata with Data Pump

    Thomas Vu-Oracle

      Hi all,

       

          I have the backup full database on pSeries by Data Pump with expdp full=Y and I want to import only User Data to Exadata that already created instance and Tablespaces. Would you advise me more with the following script:

       

      impdp userid=system/***** directory=testdp dumpfile=test_full_%U.dmp logfile=test_full.log parallel=40 job_name=testimpdp cluster=NO full=Y EXCLUDE=SCHEMA:"='SYSMAN'" EXCLUDE=TABLESPACE

       

      Thanks,

      Thomas