1.  Use Command Line to export User (ie. Harry) to C:LAB454Harry.dmp

2.  Use Interactive Command Line to export Movie table to C:LAB454Movie.dmp

3.  Use either Command Line or Interactive Command Line to export full database to C:LAB454Full.dmp 

How long does it take?        

How big is the dmp file?      

4.  Insert 2 new movies into your movies table - “Desperate Housewives” and “'Everybody Loves Raymond'”.

5.  How many rows in each of Harry’s table?

6.  Drop Movie table and truncate Employee table.                     

7.  Use Oracle Enterprise Manager (OEM) or SQL*PLUS  to verify Movie table is gone and employee table is empty.

8.  Use Import to restore the Movie table.

9.  Lisa, another DBA, left the company to pursue better opportunities.  She created an export file called Lisa.dmp.  You (Harry) need to restore Employee table from Lisa.dmp.

10. How many rows in each of Harry’s table?            

11. Log on SYSTEM to create an export directory called export_dumps pointing to C:LAB454Export and then give your ID (ie. Harry) Read/Write privileges on this directory.  

12. Use DataPump in DOS to export Store table.   

13.  Invoke OEM and log on as Harry and then use DataPump to export Employee table to a file called “NewEmpoloyee.dmp”.   Please show the job log – see example below.  (2 points)

14.  Continue to use OEM DataPump to import Location table from Lisa.dmp.   Did job fail or succeed?  Why?

CSC454 HW#4 Oracle11g Import/Export and DataPump(15 points)1.Use Command Line toexport User(ie. Harry) to C:\LAB454\Harry.dmp2.UseInteractiveCommand Line toexport Movie tableto C:\LAB454\Movie.dmp3.Use either Command Line or InteractiveCommand Line toexportfulldatabaseto C:\LAB454\Full.dmpa.How long does it take?b.How big is the dmp file?4.Insert 2 new movies into your movies table - “Desperate Housewives” and “'Everybody Loves Raymond'”.5.How many rows in each of Harry’s table?6.Drop Movie table and truncate Employee table.7.UseOracle Enterprise Manager(OEM)orSQL*PLUSto verify Movie table is gone and employee table is empty.8.UseImportto restore the Movie table.9.Lisa, another DBA, left the company to pursue better opportunities.She created an export file called Lisa.dmp.You (Harry) need torestore Employee table from Lisa.dmp.10. How many rows in each of Harry’s table?11.Log onSYSTEMto create an export directory calledexport_dumpspointing to C:\LAB454\Export and then give your ID (ie.Harry)Read/Writeprivileges on this directory.12.Use DataPump in DOS to export Store table.13.Invoke OEM and log on as Harry and then use DataPump to export Employee table to a file called “NewEmpoloyee.dmp”.Pleaseshow the job log– see example below.(2 points)14.Continue to use OEM DataPump to import Location table from Lisa.dmp.Did job fail or succeed?Why?1

• 1495510094-CSC454 HW4 Oracle11g Imp Exp and DataPump.doc

ComputerScienceExpert

(11)

Status NEW Posted 23 May 2017 03:05 AM My Price 9.00

-----------

Attachments

file 1503076755-Interactive export command.docx preview (2232 words )

I-----------nte-----------rac-----------tiv-----------e e-----------xpo-----------rt -----------com-----------man-----------d w-----------ith----------- De-----------fau-----------lt -----------Val-----------ues----------- B-----------y D-----------efa-----------ult-----------, w-----------hen----------- yo-----------u t-----------ype----------- �-----------�ex-----------p�-----------� c-----------omm-----------and-----------, a-----------nd -----------hit----------- en-----------ter-----------, y-----------ou -----------are----------- en-----------ter-----------ing----------- th-----------e i-----------nte-----------rac-----------tiv-----------e m-----------ode-----------, w-----------her-----------e i-----------t w-----------ill----------- pr-----------omp-----------t y-----------ou -----------for----------- va-----------rio-----------us -----------val-----------ues----------- be-----------for-----------e e-----------xpo-----------rti-----------ng -----------the----------- Or-----------acl-----------e t-----------abl-----------e d-----------ata-----------. -----------Fir-----------st,----------- it----------- wi-----------ll -----------ask----------- fo-----------r t-----------he -----------Ora-----------cle----------- sc-----------hem-----------a�-----------�s -----------use-----------rna-----------me -----------and----------- pa-----------ssw-----------ord-----------. T-----------his----------- us-----------ern-----------ame----------- ca-----------n b-----------e t-----------he -----------nam-----------e o-----------f t-----------he -----------sch-----------ema----------- th-----------at -----------you----------- ar-----------e p-----------lan-----------nin-----------g t-----------o e-----------xpo-----------rt,----------- or----------- a -----------use-----------rna-----------me -----------who----------- ha-----------s D-----------BA -----------pri-----------vil-----------ege----------- to----------- ex-----------por-----------t o-----------the-----------r

Not Rated(0)

• Buy Answer