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
between those 2 views is a bug which
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 PMSubject: Re: USER_
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
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 Moore wrote:
Has anyone else seen this or can you explain it?
I have 7 tablespaces
/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 that the TS$ entry remains but the discrepancy
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 8.0.5