Reference no: EM131182378
1. Use Command Line to export User (ie. Harry) to C:LAB454Harry.dmp
2. UseInteractiveCommand Line to export Movie table to C:LAB454Movie.dmp
3. Use either Command Line orInteractiveCommand 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 showthe 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?
Attachment:- Imp-Exp-and-DataPump.rar
|
Coefficient of kinetic friction
: A 200 N box is pushed up an incline that is 5.00 m long and rises 1.00 m. The incline has a coefficient of kinetic friction of 0.200. The work done by the pushing force is
|
|
Calculate the required power
: A pump is to be installed to increase the flowrate through this pipe and nozzle by 20%. Calculate the required power.
|
|
Calculate and display a letter grade for each student
: Calculate and display a letter grade for each student - A flowchart showing the program processing flow
|
|
Isothermal expansion of an ideal gas
: Understanding of Thermodynamics: a. Is the isothermal expansion of an ideal gas into a vacuum an irreversible process?Elaborateandexplainwhy. b.Explainwhy liquids typically have a larger molar heat capacity at constant pressure than the gaseous ph..
|
|
How many rows in each of harrys table
: How many rows in each of Harry's table - Drop Movie table and truncate Employee table.
|
|
Develop a workplace training for a team of us managers
: Develop a workplace training for a team of U.S. managers who are to be sent to work overseas. Select a country of your choice where these managers will be tasked to oversee a number of employees native to that country
|
|
Determining parameters
: Addthelag compensator using bode plots. Showthecharacteristics (margins) of uncompensated and compensated system to explainthepreocessof determining parameters. Show your step and ramp response to confirm your answer.
|
|
Minimum length of a runway in m that can allow
: A small airplane needs to reach a speed of 280 km/h to take off. (a). What is the minimum length of a runway in m that can allow the plane to takeoff if it accelerates at the rate of 3.80 m/s2? (b) How much time does the plane take to reach that s..
|
|
Find whether a graph has a hamiltonian path
: The Hamiltonian Path problem is the problem of determining whether a graph has a Hamiltonian Path. Explain why this problem is in NP. Explain why the problem of determining whether a graph has a Hamiltonian Path is NP-complete.
|