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


Please Help Members By Posting Answers For Below Questions

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

591


Can you redefine a table online?

667


What types of replication are supported in sql server? : sql server DBA

597


Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1555


what is the last version,the release date of that version and fix pack of ibm db2 udb?

1520






Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1844


what do you understand by flashback feature of oracle?

556


What authentication modes does sql server support? : sql server DBA

692


How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2031


Why does Oracle not permit the use of PCTUSED with indexes?

2327


What the different components in replication and what is their use? : sql server DBA

535


How do you trace the traffic hitting a sql server? : sql server DBA

843


what do you understand by fine-grained auditing?

629


how can you process messages in order asynchronously?

555


how can you create a user-defined lock?

584