how to copy(migrate) the database one server to another server
without using expdp/impdp how it is possible.
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 is asm?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
how can you process messages in order asynchronously?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How would you extract DDL of a table without using a GUI tool?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What is a system database and what is a user database? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
What is a correlated sub-query? : sql server DBA
how can you create a user-defined lock?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
how to restore files with rman?
What the different components in replication and what is their use? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?