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
What are the different sql server versions you have worked on? : sql server DBA
how can a session indicate its interest in receiving alerts?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
what are the differences of where and if in SAS?
What types of replication are supported in sql server? : sql server DBA
what do you understand by fine-grained auditing?
Where do you find the default index fill factor and how to change it? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is the default fill factor value? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Why would you use sql agent? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?