Toad World® Forums

When resizing datafile: Error occurs : ORA-02248: invalid option for ALTER SESSION

ORA-02248: invalid option for ALTER SESSION

When Resizing one datafile, this error occurs

since 12.11.0.1x, but not in older releases.

It sounds like you are looking at datafiles for all pluggable databases, and trying to change a datafile in a different pluggable database than the one you are connected to. In this case, Toad would issue "Alter session set container = " before attempting to alter the datafile, and then it should switch it back to the original container after that.

Will you turn on spool SQL and let me know the full ALTER SESSION SQL that Toad is running?

Thanks.