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

Give the reasoning behind using an index.

If CPU is very slow What can u do to speed up?

Why would you use sql agent? : sql server DBA

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

What are the steps you will take, if you are tasked with securing an SQL Server?

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

What is a correlated sub-query? : sql server DBA

How to start SQL Server in minimal configuration mode?

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

what are the performance views in an oracle rac environment?

How can you gather statistics on a table?

How do you open a cluster administrator? : sql server DBA

For more DB Administration Interview Questions Click Here