how to copy(migrate) the database one server to another server without using e

how to copy(migrate) the database one server to another server
without using expdp/impdp how it is possible.

Question Posted / aravind

4 Answers
9181 Views
DELL, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to copy(migrate) the database one server to another server without using expdp/impdp how it is..

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

how to copy(migrate) the database one server to another server without using expdp/impdp how it is..

Answer / venu

It can be done thru hot cloning

Is This Answer Correct ?

2 Yes

0 No

how to copy(migrate) the database one server to another server without using expdp/impdp how it is..

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

how to copy(migrate) the database one server to another server without using expdp/impdp how it is..

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

Post New Answer

More DB Administration Interview Questions

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers

What column differentiates the V$ views to the GV$ views and how?

3 Answers

You have just compiled a PL/SQL package but got errors, how would you view the errors?

3 Answers

What is a system database and what is a user database? : sql server DBA

0 Answers

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers

what is the purpose of catlaog in oracle rman?

2 Answers Value Labs,

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers

How would you go about increasing the buffer cache hit ratio?

2 Answers

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

0 Answers EDS,

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers

If we issue alter database begin backup. What happens to database?

2 Answers

what is incremental checkpoint?

1 Answers CTS,

For more DB Administration Interview Questions Click Here