Sign Up Login


  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / aravind

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

wat is global index and local indes

1 Answers   Oracle,

what are the differences of where and if in SAS?

0 Answers  

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers  

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

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 can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,

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  

one datafile is lost in standy side how can you recover that??

2 Answers  

What is dbcc? : sql server DBA

0 Answers  

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

How can you gather statistics on a table?

3 Answers  

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 Answers  

For more DB Administration Interview Questions Click Here
Categories