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

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2495

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

2161

what is a user-defined lock?

1134

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3806

how can you process messages in order asynchronously?

1033

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1791

how can you create a user-defined lock?

1053

What are the commands used in dcl? : sql server DBA

1129

What is replication? : sql server DBA

1225

Why would you call update statistics? : sql server DBA

1034

how can you enable flashback feature?

1004

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2248

How to start SQL Server in minimal configuration mode?

8071

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2519

how can you record information about current session?

1100