Can anybody tell me the syntax that how to add a data file to an existing tablespace. Thank you in advance.
asked
How do you add a data file to a tablespace?
I appreciate your interest in Oracle, but have you considered looking in the online Oracle user guides before posting a question? And if you do post, suggest what problems you had following the Oracle docs? It would probably take you less time to do that than post a generic question here...
ALTER TABLESPACE <tablespace> ADD DATAFILE '<datafile>' SIZE <size> AUTOEXTEND <options>
AUTOEXTEND can be "OFF" or "ON" with further options of "NEXT <size>" and "MAXSIZE <size>" for the increment and the maximum size.
Here's one way:
It appears that you would:
alter tablespace <name> add <datafile>
That's a 10g reference. I think you use 9, so I looked at the 10g "New Features" and tablespaces have changed, but not the basics, so I think this command will work on 9.
