how to copy(migrate) the database one server to another server
without using expdp/impdp how it is possible.
Answer Posted / sanjayreddy
migration of database we have two ways
1)datapump
2)transportable tablespace
so we can copy/migrate the data by using 2 method from one server to another server like(linux to sun solaris or vis/versa)..
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is grd?
What is the default port no on which sql server listens? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What happens on checkpoint? : sql server DBA
what is a crs resource?
how can you initialize log miner?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
how can you get actual data change values from previous transactions in oracle?