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 are the recovery models for a database? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
What is a system database and what is a user database? : sql server DBA
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
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?
what do you understand by fine-grained auditing?
What are statistics, under what circumstances they go out of date, how do you update them?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is replication? : sql server DBA
who owns the operating system files created by the utl_file package?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
what are the benefits of flashback feature?
how can you communicate with operating system files from oracle?