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

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

From the database level, how can you tell under which time zone a database is operating?

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

how can you generate profile of pl/sql applications to identify performance bottlenecks?

What the different components in replication and what is their use? : sql server DBA

what is the diffrence between core dba and apps dba?

What authentication modes does sql server support? : sql server DBA

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

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

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

what is meant by gateway

For more DB Administration Interview Questions Click Here