how to copy(migrate) the database one server to another server
without using expdp/impdp how it is possible.
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Give the reasoning behind using an index.
what do you understand by fine-grained auditing?
what is the use of ocr?
what is the purpose of catlaog in oracle rman?
You're getting high "busy buffer waits" - how can you find what's causing it?
What are statistics, under what circumstances they go out of date, how do you update them?
What is the default port no on which sql server listens? : sql server DBA
Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog
What are the commands used in dcl? : sql server DBA
Where in the Oracle directory tree structure are audit traces placed?
Explain what partitioning is and what its benefit is.