Answer / vineet tyagi

Without Backup Of the Datafile(Excepts System/Active Undo Datafiles)

First Of All,We will take the particular datafile offline.
After that we will create same datafile with same location or another location.Then recover the datafile and online datafile.

Steps:--
1)Alter database datafile <name> offline; (Excepts System/Active undo tablespace related files)

2)Shutdown immediate/abort
3)Startup monut

4)Alter database create datafile <name> With same locatioin and same size; Or
Alter databse create datafile <name> old location to <name> new location with same size;
5)recover database/recover datafile <name>;
6)alter database open
7)alter database datafile online;

What happens if the update subquery returns multiple rows?

0 Answers  

---

How to fetch the row which has the max value for a column?

0 Answers  

---

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

0 Answers  

---

if you update view? where we store the data?

5 Answers   Cap Gemini,

---

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

0 Answers   Atos Origin,

---

What is an oracle function?

0 Answers  

---

Can we write dml statement in function in oracle?

0 Answers  

---

What language does oracle use?

0 Answers  

---

What is an Oracle Instance?

0 Answers  

---

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3

3 Answers  

---

What are the different windows events activated at runtime ?

0 Answers   Oracle,

---

How to write a query with a left outer join in oracle?

0 Answers  

---