Re: Question: RMAN - Getting closer...

On 1 Sep 2005 13:26:15 -0700, "BD" <bobby_dread_at_hotmail.com> wrote:

>And, FWIW(2), the same command without the aux tablespace and the PIT
>recovery works:
>
>run {allocate channel dev1 type disk;sql "alter session set
>nls_date_format=''MM-DD-YYYY HH24:MI:SS''"; restore tablespace
>small_tables_2;}

That may be the case, but the documentation you have been reading specifically states NLS_DATE_FORMAT needs to be an *environment variable* that has been set prior to starting RMAN. Your alter session commands are bound to fail.

--
Sybrand Bakker, Senior Oracle DBA