RE: Help need

[Jäck Stephan]

Deewaker, 
information you find with this select-stmt, perhaps you need to format the
output.
Depending on what you're looking for you should select either from the view:
user_indexes
all_indexes
dba_indexes
 
 select
   table_name,
   index_name,
   tablespace_name
from user_indexes 
group by table_name, index_name, tablespace_name;
 
 
TGIF
 
Stephan

-Original Message-
Sent: Friday, July 27, 2001 10:50 AM
To: Multiple recipients of list ORACLE-L



HI DBA Guru's 

I wanted to know all the Index names under respective table spaces 

For example 

Tablespace is Production 
Table name : customer, item, supplier 
index Names  idx_customer_custid 
  idx_customer_name 
  idx_item_itemid 
  idx_item_name 
  idx_supplier_itemid 
  idx_supplier_name 

Tablespace is Quality 
Table name : customer, item, supplier 
index Names  idx_customer_custid 
  idx_customer_name 
  idx_item_itemid 
  idx_item_name 
  idx_supplier_itemid 
  idx_supplier_name 

Tablespace is Development 
Table name : customer, item, supplier 
index Names  idx_customer_custid 
  idx_customer_name 
  idx_item_itemid 
  idx_item_name 
  idx_supplier_itemid 
  idx_supplier_name 

with warm regards, 

Deewaker G. V. 

 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?Q?J=E4ck_Stephan?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

table access via Browser

[Jäck Stephan]

Hi,

what would you prefer to have a simple way to view and modify 
table-data of an oracle-DB by a browser?

Is there a simpler way to go than OAS/iAS?
Any ODBC-plugins? 
Has WebDB features that can be used?

Any comments are welcome.

Thanks
Stephan


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?ISO-8859-1?Q?J=E4ck_Stephan?=
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).