Answer / priya reddy

show error;
This is the command used to view the errors..

Answer / santo

Sometimes 'Show error' won't display the required
info...then check dba_errors table

select text from dba_errors where name='****';

Answer / santosh

show error package <package name>
to check the compilation errors
similarly for functions

show error function <function name>

and for procedures

show error procedure <procedure name>

Explain about your sql server dba experience? : sql server DBA

0 Answers  

---

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

0 Answers   HP,

---

How can we see the database version in os level

6 Answers   Oracle,

---

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  

---

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

0 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  

---

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

---

How to start SQL Server in minimal configuration mode?

1 Answers  

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---