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

Which autogrowth database setting is good? : sql server DBA

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

why Datapump is faster than traditional export and import

what is a user-defined lock?

What are the different ways you can create databases in sql server? : sql server DBA

how can you generate profile of pl/sql applications to identify performance bottlenecks?

If CPU is very slow What can u do to speed up?

What would you do with an "in-doubt" distributed transaction?

wat is global index and local indes

How can you rebuild an index?

Compare and contrast TRUNCATE and DELETE for a table.

What are the ways tablespaces can be managed and how do they differ?

For more DB Administration Interview Questions Click Here