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

Hot backup procedure?

If we issue alter database begin backup. What happens to database?

by issuing "alter tablespace begin backup;" what happens to tablespace?

What are the different sql server versions you have worked on? : sql server DBA

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

deleted of control file how will u recover control file?

What are the different types of indexes available in sql server? : sql server DBA

How many memory layers are in the shared pool?

Name three advisory statistics you can collect.

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

What is transparent data encryption? : sql server DBA

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

For more DB Administration Interview Questions Click Here