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)

What purpose does the model database server? : sql server DBA

1259

---

how can you get actual data change values from previous transactions in oracle?

1137

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1955

---

which background process invoke at the time of upgradation tell me???

2778

---

how can you create a user-defined lock?

1053

---

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

1225

---

What are the operating modes in which database mirroring runs? : sql server DBA

1232

---

What would you do with an "in-doubt" distributed transaction?

1932

---

Why would you call update statistics? : sql server DBA

1035

---

What is a system database and what is a user database? : sql server DBA

1309

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1248

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2120

---

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3448

---

What is dbcc? : sql server DBA

1345

---

Query processing is slow(eg select query)how will u solve that

8031

---