Answer Posted / 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;

State any two functions of oracle?

1099

---

What are the different types of trigger and explain its various uses and functions?

1168

---

What is system global area (sga) in oracle?

1035

---

How would you change old and new values in an insert, delete and update triggers?

1078

---

What is a read only transaction in oracle?

1080

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

1036

---

What is not equal to in oracle?

1049

---

How to add another datafile to a tablespace?

1091

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1114

---

What are the numeric comparison operations?

1167

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

2057

---

What is an oracle table?

1033

---

What is a read write transaction in oracle?

1134

---

What are the different editions of oracle?

1179

---

Explain oracle 12c new features for developers?

1125

---