Sign Up Login


  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Post New Answer

More DB Administration Interview Questions

Explain CREATE DATABASE syntax?

2 Answers  

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

Can you redefine a table online?

0 Answers   Oracle,

how to restore files with rman?

0 Answers  

how can you enable flashback feature?

0 Answers   Oracle,

why we use cursors

1 Answers  

How would you extract DDL of a table without using a GUI tool?

0 Answers  

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

2 Answers  

What is dcl? : sql server DBA

0 Answers  

Why would you call update statistics? : sql server DBA

0 Answers  

deleted of control file how will u recover control file?

4 Answers   CTS,

For more DB Administration Interview Questions Click Here
Categories