ALTER TABLESPACE ts_name ADD DATAFILE '/new_volume/sid/ts_nameXX.dbf' SIZE ???M;When you add the datafile, make sure you specify the new disk volume your SysAdmin has set up for you.
Dig Deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.