tablspace/partitions

From: prasad maganti <prasadm_g_at_yahoo.com>
Date: Wed, 08 Aug 2001 08:27:19 -0700
Message-ID: <F001.003643AD.20010808073608@fatcity.com>

Hi lists

i have a situation here.

one user requested us to increase the size of the tablespace as he needs more extents to be allocated for his table.

i queried the dba_tables for tablespace information.

but system showed nothing. and then i queried the dba_tab_partitions. it showed 4 tablespaces for that table and again i queried dba_segments and i have got another tablespace name.

when i queried dba_tab_partitions i got x1,x2,x3,x4

when i queries dba_segments i got
ts1

i verified this situation with dba_data_files. All tablespaces have got different datafiles.

I dont understand this situation. can anybody tell me?

is there anything magic with the partitions.
(like sub tablespaces in a tablespace. if yes, how to
find out them)

This is our datawarehouse environment.

thanx in adv
prasad

---

Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: prasad maganti
  INET: prasadm_g_at_yahoo.com

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: ListGuru_at_fatcity.com (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).

Received on Wed Aug 08 2001 - 10:27:19 CDT