Puzzling Tablespace 
Author Message
 Puzzling Tablespace
I have a tablespace for indexes consisting of 6 datafiles. If I query
DBA_SEGMENTS I get 19 rows returned showing various values for the
initial extent. If I limit this query by DISTINCT I get 8 rows returned.
Why? Surely I should get 6 rows or less (only 1 if initial extent was
the same for all datafiles.

Can someone explain this please!

Regards

Alex



Tue, 23 Oct 2001 03:00:00 GMT
 Puzzling Tablespace

Forgot

Oracle 7.3.4
Sequent DYNIX/ptx 4

Quote:

> I have a tablespace for indexes consisting of 6 datafiles. If I query
> DBA_SEGMENTS I get 19 rows returned showing various values for the
> initial extent. If I limit this query by DISTINCT I get 8 rows returned.
> Why? Surely I should get 6 rows or less (only 1 if initial extent was
> the same for all datafiles.

> Can someone explain this please!

> Regards

> Alex



Tue, 23 Oct 2001 03:00:00 GMT
 Puzzling Tablespace
Forget it!! - It is Friday after all!!

Alex

Quote:

> Forgot

> Oracle 7.3.4
> Sequent DYNIX/ptx 4


> > I have a tablespace for indexes consisting of 6 datafiles. If I query
> > DBA_SEGMENTS I get 19 rows returned showing various values for the
> > initial extent. If I limit this query by DISTINCT I get 8 rows returned.
> > Why? Surely I should get 6 rows or less (only 1 if initial extent was
> > the same for all datafiles.

> > Can someone explain this please!

> > Regards

> > Alex



Tue, 23 Oct 2001 03:00:00 GMT
 Puzzling Tablespace
Hi,
Dba_segments gives you varius segment info like
table,cluster,index,temp,rollback  etc.
If you want to see the data files use view  v$datafile.You can also join
them with v$tablespace using TS# common column.
FYI :There will be no storage parameters for datafiles.
Quote:

>I have a tablespace for indexes consisting of 6 datafiles. If I query
>DBA_SEGMENTS I get 19 rows returned showing various values for the
>initial extent. If I limit this query by DISTINCT I get 8 rows returned.
>Why? Surely I should get 6 rows or less (only 1 if initial extent was
>the same for all datafiles.

>Can someone explain this please!

>Regards

>Alex



Tue, 23 Oct 2001 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Date puzzle has me puzzled

2. Solve this Paradox puzzle...! (a real puzzle)

3. Copy from tablespace to tablespace

4. Dropping tablespace (zero-block tablespace)

5. 8i Tablespace removal if someone has deleted the .dbf instead of dropping the tablespace

6. moving tables from the system tablespace to a new tablespace

7. Moving Tables from Tablespace A to Tablespace B

8. locally-managed tablespaces vs dictionary-managed tablespaces in 8i

9. moving data from 8.0.5 user_data tablespace to 8.1.7 users tablespace

10. Tablespace local management and temporary tablespace

11. Dropping tablespace (create zero-block tablespace)

12. Tablespace tablespace hackery


 
Powered by phpBB® Forum Software