How will u copy the objects of one schema to another schema in datapump & export/import?
Answer Posted / 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 View All Answers
You create a private database link and upon
connection, fails with: ORA-2085: connects to
what is a crs resource?
internal architecture
how can you initialize log miner?
What are the operating modes in which database mirroring runs? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How do you trace the traffic hitting a sql server? : sql server DBA
when does an alert gets signaled?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
what is logical system in sap basis
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
how does an oracle clusterware manage crs resources?
what is the use of recording information about current session?