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 is the difference between SQL, DDL, and DML?

7 Answers   BeBo Technologies, Wipro,

---

structural difference between bitmap and btree index ?

1 Answers   Infosys,

---

which is the best training centre for learning oracle?

13 Answers  

---

What are the Characteristics of Data Files ?

3 Answers  

---

How to calculate date and time differences in oracle?

0 Answers  

---

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

2 Answers   AppLabs,

---

if you ctreate table identity

0 Answers  

---

What is using clause and give example?

0 Answers  

---

In oracle there is column command, how will you explain that?

0 Answers   Aricent,

---

Difference between sub query and nested query ?

19 Answers   Keane India Ltd, TCS,

---

How to convert a date to char in oracle? Give one example.

0 Answers  

---

What is a snapshot in oracle database?

0 Answers  

---