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
Why does Oracle not permit the use of PCTUSED with indexes?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the operating modes in which database mirroring runs? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
what do you understand by flashback feature of oracle?
what is the role of dip user in our database?
which background process invoke at the time of upgradation tell me???
what are the performance views in an oracle rac environment?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
what is grd?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What the different types of replication and why are they used? : sql server DBA
What are the recovery models for a database? : sql server DBA