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
8879 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 would you extract DDL of a table without using a GUI tool?

0 Answers

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers

what is a user-defined lock?

0 Answers Oracle,

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

4 Answers DELL, TCS,

Give two methods you could use to determine what DDL changes have been made.

2 Answers

which background process will run @ the time of creation of catalog database

1 Answers CSC,

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers IBM,

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers

How would you determine the time zone under which a database was operating?

2 Answers

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers STC,

what is ora 600?

1 Answers

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

For more DB Administration Interview Questions Click Here