Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Adding datafile to ASM file system tablespace

User347578Jul 25 2011 — edited Jul 25 2011

Hi

Can some one plz help in writing a script to add a datafile to the system tablespace on ASM filesystems.

below is the result of the query ..

select file_name, bytes, autoextensible, maxbytes from dba_data_files where tablespace_name='SYSTEM';

FILE_NAME BYTES AUT MAXBYTES

+DATA1/cir_p/datafile/system.260.6037360 5892997120 NO 0

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 22 2011

Added on Jul 25 2011

#general-database-discussions

10 comments

2,406 views