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)

how can you enable flashback feature?

894

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1051

---

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1661

---

how can you communicate with operating system files from oracle?

981

---

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

2662

---

how can you process messages in order asynchronously?

930

---

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

2017

---

Why would you call update statistics? : sql server DBA

948

---

How can you control the amount of free space in your index pages? : sql server DBA

1232

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1987

---

what do you understand by fine-grained auditing?

1014

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2408

---

what is the use of recording information about current session?

995

---

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

962

---

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

2293

---