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
8838 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

What are the steps you will take to improve performance of a poor performing query?

0 Answers

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers IBM,

Why would you use sql agent? : sql server DBA

0 Answers

what are the differences of where and if in SAS?

0 Answers

What questions might be they ask in managerial round in capgemini.

1 Answers Cap Gemini, iGate,

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers

How can you rebuild an index?

6 Answers

what is a user-defined lock?

0 Answers Oracle,

why do we give pctfree and pctused in create table statement?

1 Answers CTS,

What are the recovery models for a database? : sql server DBA

0 Answers

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers

now one user in online.now i want drop him..how do u drop him?

4 Answers Wipro,

For more DB Administration Interview Questions Click Here