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