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

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

how can you initialize log miner?

0 Answers   Oracle,

How can you enable a trace for a session?

1 Answers  

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,




What purpose does the model database server? : sql server DBA

0 Answers  

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers  

What view would you use to determine free space in a tablespace?

3 Answers  

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  

how can you connect from 10g user to 11g user??

0 Answers   HP,

What is blocking and how would you troubleshoot it?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories