AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: USER_TABLESPACES has more rows than
DBA_TABLESPACES
Keith,
yes, it's regular behaviour that the TS$ entry remains but the discrepancy
betw
by: [EMAIL PROTECTED]
01/14/2003 08:44 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: USER_TABLESPACES has more rows than DBA_TABLESPACES
Keith,
yes, it's regular behaviour th
riginal Message -
> From: "Stephane Faroult" <[EMAIL PROTECTED]>
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Monday, January 13, 2003 1:34 PM
> Subject: Re: USER_TABLESPACES has more rows than DBA_TABLESPACES
>
> >
Keith,
yes, it's regular behaviour that the TS$ entry remains but the discrepancy
between those 2 views is a bug which is fixed in 8.0.6. Basically,
DBA_TABLESPACES excludes 'INVALID' tablespaces but USER_TABLESPACES doesn't.
There are duplicates for the bug. The numbers are 284887, 553723 and 5
I'm still confused. They are not in DBA_TABLESPACES, only
USER_TABLESPACES.Keith- Original Message - From:
"Stephane Faroult" <[EMAIL PROTECTED]>To: "Multiple
recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Monday,
January 13, 2003 1:34 PMS
> Keith Moore wrote:
>
> Has anyone else seen this or can you explain it?
>
> I have 7 tablespaces in USER_TABLESPACES that don't exist in
> DBA_TABLESPACES. These have been dropped, but somehow did not
> disappear from USER_TABLESPACES. They have a status of INVALID.
>
> The database is version