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

What the different types of replication and why are they used? : sql server DBA

0 Answers  

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

Name two files used for network connection to a database.

5 Answers  

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,




how can you find out if a table can be redefined?

0 Answers   Oracle,

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  

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

2 Answers  

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers  

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

2 Answers   HP,

How to start SQL Server in minimal configuration mode?

1 Answers  

what is incremental checkpoint?

1 Answers   CTS,

For more DB Administration Interview Questions Click Here
Categories