Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

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


Please Help Members By Posting Answers For Below Questions

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1116

Which autogrowth database setting is good? : sql server DBA

1163

internal architecture

2201

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1985

how to restore files with rman?

2305

What is dbcc? : sql server DBA

1297

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

1178

What is replication? : sql server DBA

1182

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

1146

what is the last version,the release date of that version and fix pack of ibm db2 udb?

1976

how can you create a user-defined lock?

1022

Where would you look for errors from the database engine?

2859

Why does Oracle not permit the use of PCTUSED with indexes?

2947

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1295

what is the role of dip user in our database?

2417