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


Please Help Members By Posting Answers For Below Questions

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

1850


What is replication? : sql server DBA

845


what are the benefits of flashback feature?

780


how can you initialize log miner?

830


which background process invoke at the time of upgradation tell me???

2462


How to start SQL Server in minimal configuration mode?

7322


how can you generate profile of pl/sql applications to identify performance bottlenecks?

812


What is a system database and what is a user database? : sql server DBA

825


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3492


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

4046


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

813


Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

817


What are the commands you'd issue to show the explain plan for "select * from dual"?

1977


Where do you find the default index fill factor and how to change it? : sql server DBA

803


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2283