How will u copy the objects of one schema to another schema in datapump & ex

How will u copy the objects of one schema to another schema in datapump & export/import?

Question Posted / kittu_chintu2005

How will u copy the objects of one schema to another schema in datapump & export/import?..

Answer / kittu_chintu2005

Impdp directory=dpump_dir1 dumpfile=xxxxx.dmp remap_schema=user1:user2
Imp file=xxxxxx.dmp \ from user=user1 touser=user2

Is This Answer Correct ?

4 Yes

2 No

More DB Administration Interview Questions

How to determine the service pack currently installed on SQL Server?

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

What is the importance of a recovery model? : sql server DBA

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

Name two files used for network connection to a database.

what is a user-defined lock?

How many memory layers are in the shared pool?

which background process will run @ the time of creation of catalog database

the process of adding a cpu in sql server is called..?

What are the steps you will take to improve performance of a poor performing query?

How would you best determine why your MVIEW couldn't FAST REFRESH?

what functionality does oracle provide to secure sensitive information?

For more DB Administration Interview Questions Click Here