Can anybody tell me the syntax that how to add a data file to an existing tablespace. Thank you in advance.
Can anybody tell me the syntax that how to add a data file to an existing tablespace. Thank you in advance.
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.
No one has followed this question yet.