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
8886 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 is the use of ocr?

0 Answers Oracle,

What is fill factor? : sql server DBA

0 Answers

Why would you use sql agent? : sql server DBA

0 Answers

WHEN DOWN TIME WHAT CAN U DO?

1 Answers TCS,

how can you connect from 10g user to 11g user??

0 Answers HP,

I lost one datafile i dont have backup how can you recover that???

2 Answers HP,

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers

How to start SQL Server in minimal configuration mode?

1 Answers

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers Oracle,

what r the types of backup?

5 Answers CSC,

For more DB Administration Interview Questions Click Here