Search This Blog

Wednesday, December 28, 2011

add datafile to temp tablespace in asm

ALTER TABLESPACE TEMP ADD TEMPFILE '+DATA1_A3' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
/

you can also specify user defined location instead of system generated one.

No comments:

Post a Comment