Re: Oracle 9i install gives 817 in v$version

nospam_at_chrismccarthysoftware.com (Chris) wrote in news:7d812462.0204152350.45965094_at_posting.google.com:
> Hemant, thanks for your reply.
> TWO_TASK is undefined, here's the query output you mentioned.
> There is only one Oracle installation on the server as it was a
> fresh OS and Oracle install.
> I'll try to find the cds and take another look.
> Perhaps the 9i app server comes with the 8i database, which would
> explain my confusion.

9iAS comes with a *cache* database that is only meant for caching (readonly) access and not for other things (people have run into several problems when trying to do so, do please don't try).

It's removed from the next version of 9iAS so I would recommend that you don't spill your time investigating what you could do with a "database cache". If you want a database you should install the 8i or 9i database into a separate ORACLE_HOME.

• Sander