Interested to Buy Any Domain ? << Click Here >> for more details...
how to copy(migrate) the database one server to another server
without using expdp/impdp how it is possible.
- 4 Answers
- 9055 Views
- DELL, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How would you extract DDL of a table without using a GUI tool?
how can you implement fine-grained auditing?
What is the default fill factor value? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What is replication? : sql server DBA
What is fill factor? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
what are the types of connection load-balancing?
What are the different types of indexes available in sql server? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
