how to copy(migrate) the database one server to another server
without using expdp/impdp how it is possible.
- 4 Answers
- 8012 Views
- DELL, TCS, I also Faced
- E-Mail Answers
Answer Posted / mohapatra.gouranga@gmail.com
migration of database we have two ways
1)datapump
2)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.
3)transportable tablespace ( rman duplicate database / by
manaual standby method)
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)..
Above answers correct.
Now days some best methods are follwed also.
4) Using Oracle streams / Golden Gate ( zero down time)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the steps you will take to improve performance of a poor performing query?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
what is logical system in sap basis
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 is the difference between the 2 operating modes of database mirroring? : sql server DBA
what is the use of recording information about current session?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
how can you enable flashback feature?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
how can you find out if a table can be redefined?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
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
