Answer Posted / bharath

Perform below steps

1) alter database datafile < file_id> offline;
2) alter database create datafile <file_id>;
3) recover datafile <file_id>;
4) alter database datafile <file_id> online;

How would you go about verifying the network name that the local_listener is currently using?

3274

---

What are the different ways you can create databases in sql server? : sql server DBA

1197

---

how can a session indicate its interest in receiving alerts?

1095

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2220

---

What the different components in replication and what is their use? : sql server DBA

1094

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

4411

---

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

1061

---

what are the types of connection load-balancing?

1047

---

what is a user-defined lock?

1145

---

how can you connect from 10g user to 11g user??

2166

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1123

---

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

8047

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2499

---

how can you communicate with operating system files from oracle?

1093

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2610

---