Re: ORA-600 error while setting utl_file_dir

On 25 Jun 2006 19:48:08 -0700, "Resant" <resant_v_at_yahoo.com> wrote:

>Hi all,
>
>I get the following error when trying to change utl_file_dir :
>
>SQL> alter system set ult_file_dir='EXT_TABLES' scope=spfile;
>
>ORA-00600: internal error code, arguments: [kspsetpao1], [1068],
>[1063], [*], [utl_file_dir], [12], [], []
>
>I use Oracle Enterprise 9.2.1.0 and have already connected using sys as
>sysdba.
>
>Any idea please for what should I do?
>
>Thank you,
>
>Resant

If EXT_TABLES is a directory object in the database, those are intended as a *replacement* of utl_file_dir, so you don't need to set utl_file_dir to your directory object, you can use it right away in your external table definition.
If EXT_TABLES is a directory name, and you did submit the statement exactly as above, including the typo (ult_file_dir), correct the typo and retry.
In all other cases, as has been stated many times before: visit Metalink and search for the ora-600 error, in this case ora-600 kspsetpao1
and/or submit a service request.

--
Sybrand Bakker, Senior Oracle DBA