what is the syntax for adding a datafile on oracle 11
We have just recently upgraded an oracle 8 database to oracle 11 on the oracle database appliance and are performing our migration this weekend. We are nearing capacity on the one datafile in the users tablespace and I need to add another. I am familiar with the oracle 8 syntax but wanted to check to make sure that I have the syntax correct.