how to copy(migrate) the database one server to another server
without using expdp/impdp how it is possible.
Answer Posted / ravindra
Hi,
Correct if i am wrong.We can do through package
procedure.Create empty database on target database and
create dblink between two databases.Now we have to prepare
package and transfer the each schema.
Thanks & Regards,
Ravindra
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Where would you look for errors from the database engine?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the operating modes in which database mirroring runs? : sql server DBA
What happens on checkpoint? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
when does an alert gets signaled?
What is the importance of a recovery model? : sql server DBA
what is a user-defined lock?
what are the types of connection load-balancing?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What is a correlated sub-query? : sql server DBA
What authentication modes does sql server support? : sql server DBA
what is asm?