Re: ORA-16000: database open for read-only access

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 2 Jun 2014 11:09:55 -0700
Message-ID: <CAORjz=Nu+j4Yw+fPundYTz-4P8hsLuVHWF9PwZnRmOYtNhXueQ_at_mail.gmail.com>

On Mon, Jun 2, 2014 at 11:03 AM, Adam Musch <ahmusch_at_gmail.com> wrote:

> I recently started tripping that error (11.2.0.3) with a query that was
> using the MATERIALIZE hint. I don't know if queries with common table
> expressions but that materialize without the hint can also cause that error.

CTE's will always fail on queries in when oracle is mounted but not opened.

Probably the same applies here.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Sr Oracle DBA at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/ Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 02 2014 - 20:09:55 CEST