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

1 Answers
5217 Views
I also Faced
E-Mail Answers

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

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers Infosys,

what are the types of connection load-balancing?

0 Answers Oracle,

why Datapump is faster than traditional export and import

4 Answers Mphasis,

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

0 Answers

Can you redefine a table online?

0 Answers Oracle,

What the different types of replication and why are they used? : sql server DBA

0 Answers

How to make a replica of existing oracle server to another server?

3 Answers

how does an oracle clusterware manage crs resources?

0 Answers Oracle,

what is the purpose of catlaog in oracle rman?

2 Answers Value Labs,

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers

what are the benefits of flashback feature?

0 Answers Oracle,

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers Value Labs,

For more DB Administration Interview Questions Click Here