Re: In which tablespaces are objects located?

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: 2000/05/25
Message-ID: <20000525.4595700@noname.nodomain.nowhere>#1/1

        Run, do not walk, to the nearest bookstore. When there purchase the following:

		Oracle <n>, the Complete Reference, Kevin Loney
		Oralce 101, Carmichael, Theriault, and ???
		Oracle DBA Handbook, Kevin Loney

	After you master these a book or two on performance tuning, and 

Oracle Backup and Recovery and ....                 

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 5/24/00, 2:17:47 PM, argosy22_at_my-deja.com wrote regarding In which tablespaces are objects located?:

> Hi all,
 

> I have inherited a database with a tablespace: RBS
> that has 3 rollback segments: R01, R02, R03
> and is owned by SYS.
 

> The rollback segments are offline, but the tablespace
> is online. But when I look at this file on the Unix side,
> it is always current to within 30 minutes.
 

> I was thinking of taking the tablespace offline,
> but first I wondered what objects are contained in
> it. We know about the rollback segments. But what else?
> I'm thinking of stored functions or procedures.

> This query does not return the tablespace.
 

> Select DEFAULT TABLESPACE,
> TEMPORARY TABLESPACE
> from dba users
> group by DEFAULT TABLESPACE,
> TEMPORARY TABLESPACE

> These the views that have a column about tablespaces.
 

> SYS ALL CLUSTERS TABLESPACE NAME
> SYS ALL INDEXES TABLESPACE NAME
> SYS ALL TABLES TABLESPACE NAME
> SYS DBA CLUSTERS TABLESPACE NAME
> SYS DBA DATA FILES TABLESPACE NAME
> SYS DBA EXTENTS TABLESPACE NAME
> SYS DBA FREE SPACE TABLESPACE NAME
> SYS DBA FREE SPACE COALESCED TABLESPACE NAME
> SYS DBA INDEXES TABLESPACE NAME
> SYS DBA ROLLBACK SEGS TABLESPACE NAME
> SYS DBA SEGMENTS TABLESPACE NAME
> SYS DBA TABLES TABLESPACE NAME
> SYS DBA TABLESPACES TABLESPACE NAME
> SYS DBA TS QUOTAS TABLESPACE NAME
> SYS SM$TS AVAIL TABLESPACE NAME
> SYS SM$TS FREE TABLESPACE NAME
> SYS SM$TS USED TABLESPACE NAME
> SYS USER CLUSTERS TABLESPACE NAME
> SYS USER EXTENTS TABLESPACE NAME
> SYS USER FREE SPACE TABLESPACE NAME
> SYS USER INDEXES TABLESPACE NAME
> SYS USER SEGMENTS TABLESPACE NAME
> SYS USER TABLES TABLESPACE NAME
> SYS USER TABLESPACES TABLESPACE NAME
> SYS USER TS QUOTAS TABLESPACE NAME
> SYS V $SORT SEGMENT TABLESPACE NAME
 
> Other than the views that are specific to an object type,
> (ie. dba tables, dba indexes, dba rollback segs)
> I can't see any view that links objects and tablespaces
> together. Is there one?

> How can I tell which tablespace an object is stored in?
> Or, what objects are in which tablespace?
 

> Ciao,
 

> Argosy

> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu May 25 2000 - 00:00:00 CDT