1 use command line to export user ie harry to, Ask an Expert

Programming

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

View complete question

DBMS, Programming

Category:- DBMS
Reference No.:- M91938483

Have any Question?Write your Review or question?

Related Questions in DBMS

Question 1 a- consider that you are asked to design an

Question: 1. (a)- Consider that you are asked to design an entity relationship diagram based on the below scenario: A university consists of a number of departments (id, d_name) and each department offers some courses. A ...

Query 1 the bookstore has decided to keep track of the

Query 1: The bookstore has decided to keep track of the vendors' information. In order to do this, one new table will be added to the database. The schema for this table, as related to the existing tables, is the followi ...

Quesiton 1 what is data-manipulation language dml there are

Quesiton: 1. What is Data-Manipulation Language (DML)? There are four types of access in DML, explain each one. 2. Assume we have a Library Database consists of the following relations: author(author_id, first_name, last ...

Sqlwrite a select statement that returns one column from

SQL Write a SELECT statement that returns one column from the Vendor table named Full Name. Create this column from the VendorContactFName and VendorContactLName columns. Format it as follows: last name, comma, first nam ...

Case study problem 1 the case study company has experienced

Case Study: Problem 1 The case study company has experienced rapid growth in both the size of its client base and also in the services provided to clients. Unfortunately, the growth in data management policies, procedure ...

Question as explained throughout this course entity

Question: As explained throughout this course, entity relationship modeling is a critical element of database design. If the database is not properly modeled, it is unlikely that the database will be properly developed. ...

Analytic reportpurpose the purpose of this task is to

Analytic Report: Purpose: The purpose of this task is to provide students with practical experience in working in teams to write a Data Analytical report to provide useful insights, pattern and trends in the chosen/given ...

In sql database questions phase-1 in 100 words what steps

In SQL Database Questions: Phase-1 In 100 words, what steps can one take to avoid losing work? Which command is used to save changes to the database? What is the syntax for this command? Phase-2 In 100 words, explain the ...

Question suppose we have two kinds of doctors hospital

Question : Suppose we have two kinds of doctors: hospital doctors and family physicians. In addition to the doctor's id number, name, specialty, and years of experience, we want to record the hospital name for the hospit ...

Stored procedure please create the following stored

Stored procedure. Please create the following stored routines using CPS3740_2017S database using the tables in dreamhome database. xxxx is your email id 1) Implement a stored procedure p3Q21_xxxx to display the Branch ci ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask DBMS Expert