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
What is fill factor? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What are the different types of database compression introduced in sql server 2008? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
How would you go about verifying the network name that the local_listener is currently using?
how can you get actual data change values from previous transactions in oracle?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
how can you communicate with operating system files from oracle?
how can you connect from 10g user to 11g user??
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
How do you trace the traffic hitting a sql server? : sql server DBA