Search This Blog

Monday, December 19, 2011

Add datafile to a tablespace

select file_name from dba_data_files where tablespace_name='tablespacename';

note down the 'datafilename with complete location'

ALTER TABLESPACE tablespacename ADD DATAFILE 'datafilename with complete location' SIZE 1M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
/

No comments:

Post a Comment