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

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

What the different topologies in which replication can be configured? : sql server DBA

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

who owns the operating system files created by the utl_file package?

Explain the difference between a data block, an extent and a segment.

what is a crs resource?

what is incremental checkpoint?

What are the different ways of moving data or databases between servers and databases in SQL Server?

now one user in online.now i want drop him..how do u drop him?

What view would you use to look at the size of a data file?

how to restore files with rman?

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

For more DB Administration Interview Questions Click Here