how to copy(migrate) the database one server to another server
without using expdp/impdp how it is possible.
- 4 Answers
- 7331 Views
- DELL, TCS, I also Faced
- E-Mail Answers
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
What is a correlated sub-query? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
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 authentication modes does sql server support? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
what do you understand by fine-grained auditing?
What are the different sql server versions you have worked on? : sql server DBA
how can you communicate with operating system files from oracle?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
what is a crs resource?
What purpose does the model database server? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
What are the different types of database compression introduced in sql server 2008? : sql server DBA
how can you connect from 10g user to 11g user??
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
