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



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

Post New Answer

More DB Administration Interview Questions

What is checkpoint?

3 Answers   Accenture,


Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  


How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers  


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

0 Answers  


orra 1555 what is this error,why it is occur?

2 Answers   Mphasis,






what is difference between user managed backup and rman backup?

1 Answers   CTS,


how can you enable flashback feature?

0 Answers   Oracle,


Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  


mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,


what is grd?

0 Answers   Oracle,


when does an alert gets signaled?

0 Answers   Oracle,


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

0 Answers  


Categories