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
9065 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 can you process messages in order asynchronously?

0 Answers Oracle,

What are the different types of indexes available in sql server? : sql server DBA

0 Answers

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

2 Answers HP,

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers

What is the difference between LMT & DLT?

1 Answers CTS,

Explain what partitioning is and what its benefit is.

2 Answers

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers

when does an alert gets signaled?

0 Answers Oracle,

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers Genpact,

How to determine the service pack currently installed on SQL Server?

1 Answers

what is difference between user managed backup and rman backup?

1 Answers CTS,

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers

For more DB Administration Interview Questions Click Here