The ALTER TABLE school the ALLOCATE among the SIZE 10 m;

Why the error report:
SQL error: ORA - 01735: invalid ALTER TABLE options
01735. In 00000 - "invalid ALTER TABLE option"
* Cause:
* Action:

CodePudding user response:

Your order is wrong, need to change to:

 
The ALTER TABLE school the ALLOCATE among (DATAFILE 'data file path' SIZE 10 m); 

CodePudding user response:

Size clause in parentheses, but now the manual allocation of the specified size among no too big significance, don't know your purpose?