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 |
how can you get actual data change values from previous transactions in oracle?
what is the diffrence between core dba and apps dba?
How would you begin to troubleshoot an ORA-3113 error?
What is the difference between Datapump & export/import?
What are the different sql server versions you have worked on? : sql server DBA
Compare and contrast TRUNCATE and DELETE for a table.
If CPU is very slow What can u do to speed up?
How can you gather statistics on a table?
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?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
what is rebuild index??
What are the different ways of moving data or databases between servers and databases in SQL Server?