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



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

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  


Give the reasoning behind using an index.

2 Answers  


what do you understand by fine-grained auditing?

0 Answers   Oracle,


what is the use of ocr?

0 Answers   Oracle,


what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,






You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  


What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  


What is the default port no on which sql server listens? : sql server DBA

0 Answers  


Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  


What are the commands used in dcl? : sql server DBA

0 Answers  


Where in the Oracle directory tree structure are audit traces placed?

1 Answers  


Explain what partitioning is and what its benefit is.

2 Answers  


Categories