816 to 815 downgrade problem ...

From: Janardhana Babu <jbdonga_at_ucdavis.edu>
Date: Wed, 26 Jul 2000 11:20:07 -0700
Message-Id: <10570.113036@fatcity.com>

Dear List,

Iam taking the 816 export file and importing into 815 database and getting the following errors:

IMP-00010: not a valid export file, header failed verification IMP-00000: Import terminated unsuccessfully.

Iam on HP-UX 11.0
I would appreciate if someone help me in resolving the problem.

Thanks,
-- Janardhana Babu

---

 From: Alex Hillman <alex_hillman_at_physia.com>  Date: Wed, 26 Jul 2000 14:40:03 -0400
 Subject: RE: How to find no of blocks

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFF730.EE67E210
Content-Type: text/plain;

        charset="iso-8859-1"

values of status are in lower case - 'cr', 'xcur'

Alex Hillman

-----Original Message-----
From: Trassens Christian [mailto:trassenc_at_TELEFONICA.COM.AR] Sent: Tuesday, July 25, 2000 5:19 PM
To: Multiple recipients of list ORACLE-L Subject: RE: How to find no of blocks

Try this:

select name, decode(status,'CR', 'Modified', 'XCUR', 'Not Modified', status)
"Status", count(*)
  from v$cache
   group by name, decode(status,'CR', 'Modified', 'XCUR', 'Not Modified', status
)

   order by 3 desc
/

REGARDS. NOTE: If you have Oracle 7.3.X, you have to run catparr.sql from $ORACLE_HOME/rdbms/admin.

> -----Mensaje original-----
> De:	Gautam_Reddy_at_Dell.com [SMTP:Gautam_Reddy_at_Dell.com]
> Enviado el:	Martes 25 de Julio de 2000 14:19
> Para:	Multiple recipients of list ORACLE-L
> Asunto:	How to find no of blocks 
> 
> How to find how many blocks of an object are present in the DB Buffer area
> at a given time. 
>  
> Thx
> Gautam
>  

--

Author: Trassens Christian
  INET: trassenc_at_TELEFONICA.COM.AR

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).

------_=_NextPart_001_01BFF730.EE67E210 Received on Wed Jul 26 2000 - 13:20:07 CDT