Re: possible to set OMF inside of PL/SQL?

From: Harald Maier <harald_at_maierh.de>
Date: Tue, 17 Feb 2004 15:54:18 +0100
Message-ID: <m3d68dwycl.fsf@ate.maierh>

rgaffuri_at_cox.net (Ryan Gaffuri) writes:

> I'm getting errors see below. nothing on metalink. I have a feeling
> this hasn't been added to the PL/SQL parser yet... Anyone ever get
> this to work? Its 9.2.0.3.
> I have the privileges. I'm running it as sysdba.
>
> EXECUTE IMMEDIATE 'ALTER SYSTEM SET
> DB_CREATE_FILE_DEST='||rFilePath.path;
>
> Failed To SET DB_CREATE_FILE_DEST ORA-02065: illegal option for ALTER
> SYSTEM
That is strange, although the Database Reference categorizes DB_CREATE_FILE_DEST as follows:

Parameter class Dynamic: ALTER SESSION, ALTER SYSTEM

Either a bug in the documentation or a bug in the implementation. 10g reports too this error.

Harald Received on Tue Feb 17 2004 - 08:54:18 CST