how to copy(migrate) the database one server to another server
without using expdp/impdp how it is possible.
Answers were Sorted based on User's Feedback
Answer / ravindra
Hi,
Correct if i am wrong.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.
Thanks & Regards,
Ravindra
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / 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 |
one datafile is lost in standy side how can you recover that??
Oracle 11g new features?
How would you force a log switch?
what is meant by gateway
What does coalescing a tablespace do?
what is the purpose of catlaog in oracle rman?
What is dcl? : sql server DBA
Explain the concept of the DUAL table.
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
what r the types of backup?
How can we see the database version in os level
what are the benefits of flashback feature?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)