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...


How will u copy the objects of one schema to another schema in datapump & export/import?



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

what is difference between user managed backup and rman backup?

1 Answers   CTS,


orra 1555 what is this error,why it is occur?

2 Answers   Mphasis,


Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  


What is blocking and how would you troubleshoot it?

1 Answers  


How many packages we have in db

1 Answers   Tesco,


hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  


Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  


What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  


How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  


What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers  


What are the recovery models for a database? : sql server DBA

0 Answers  


when does an alert gets signaled?

0 Answers   Oracle,


Categories