Re: rman restore procedure

Antonio 6sette wrote:
> ALTER TABLESPACE temp add tempfile
> *
> ERROR at line 1:
> ORA-01268: invalid TEMPFILE clause for alter of permanent TABLESPACE
>
> from the views I see that the temporary tablespace is ok.
>
> SQL> SELECT * from dba_tablespaces where tablespace_name='TEMP';
>
> TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT
> ---------------------------
> TEMP 8192 40960 40960
> 1 50 0 ONLINE TEMPORARY LOGGING
> NO DICTIONARYUSER NO MANUAL DISABLED
>
> SQL> SELECT * from dba_data_files where tablespace_name='TEMP';
>
> FILE_NAME TABLESPACE_NAME
> -------------------------------
> /home/oracle/oradata/DIP/temp.dbf TEMP
>
> Can anyone explain me this behaviour ??

If you have metalink access, Note: 160426.1 (or is it 248290.1?) has an enlightening explanation.

jg

--
@home.com is bogus.
http://dilbertblog.typepad.com/the_dilbert_blog/2005/12/top_the_cartoon.html#comments