SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How will include next cluase to our present tablespace

522510May 6 2008 — edited May 7 2008

Hi,
I have add datafile to our tablespace , but by mistak i have not include NEXT clause
how will include next clause.

i have use following command

alter database datafile '/oradata/ocr1.dbf' next 100M;
alter database datafile '/oradata/ocr1.dbf' next 100M
*
ERROR at line 1:
ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 4 2008

Added on May 6 2008

1 comment

236 views