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 |
What is checkpoint?
Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
orra 1555 what is this error,why it is occur?
what is difference between user managed backup and rman backup?
how can you enable flashback feature?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?
what is grd?
when does an alert gets signaled?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?