Re: Buffer use under Oracle
- From: Binyamin Dissen <bdissen@xxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 12 May 2004 16:20:55 +0300
On Wed, 12 May 2004 13:28:00 +0100 M.K.Jha@xxxxxxxx wrote:
:>Hi,
:>can u send the output of following query...
:>after that tryt to explain ... your Q?
:>select rpad(a.index_name,30),rpad(a.column_name,30), b.NULLABLE ,
:>rpad(a.column_position,5)
:>from all_ind_columns a, all_tab_columns b
:>where a.table_name like upper('&tab') and
:>a.table_name=b.table_name and
:>a.column_name=b.column_name
:>order by 1,4;
The index columns are non-nullable. One column is a timestamp.
What should this be telling me?
--
Binyamin Dissen <bdissen@xxxxxxxxxxxxxxxxxx>
http://www.dissensoftware.com
Director, Dissen Software, Bar & Grill - Israel
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
