Interested to Buy Any Domain ? << Click Here >> for more details...
how to copy(migrate) the database one server to another server
without using expdp/impdp how it is possible.
- 4 Answers
- 8887 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
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
how can you process messages in order asynchronously?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what functionality does oracle provide to secure sensitive information?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What the different topologies in which replication can be configured? : sql server DBA
What is the importance of a recovery model? : sql server DBA
what are the differences of where and if in SAS?
how to restore files with rman?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
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?
How can you control the amount of free space in your index pages? : sql server DBA
Explain materialized views and how they are used.
Why would you use sql agent? : sql server DBA
