OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Indexes Tablespace

Wed, 05 January 2005 19:00

Lokesh Kalra
Messages: 2
Registered: January 2005

Junior Member

Hi,

How to find in which tablespace a particular index is made?

Thnx.

Wed, 05 January 2005 20:46

oracle
Messages: 9
Registered: May 2002

Junior Member

It's in the dba/all/user_indexes views:

ONTW>select tablespace_name from all_indexes where index_name = 'GEB_DCR_PK';

TABLESPACE_NAME
------------------------------
OZGINDX

hth

Thu, 06 January 2005 02:35

Lokesh Kalra
Messages: 2
Registered: January 2005

Junior Member

Thanks Frank.

Previous Topic:	ALTER INDEX . REBUILD - Why it (DDL) generates REDO?
Next Topic:	Oracle Virtual Indexes

Goto Forum:

]

Current Time: Fri Sep 27 04:26:08 CDT 2024