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

**URL:** <https://forums.toadworld.com/t/when-resizing-datafile-error-occurs-ora-02248-invalid-option-for-alter-session/39010>\
**Category:** Toad for Oracle - Beta\
**Created:** [January 31, 2017, 1:13am UTC](https://forums.toadworld.com/t/when-resizing-datafile-error-occurs-ora-02248-invalid-option-for-alter-session/39010 "2017-01-31T01:13:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![felix.neugebauer](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/felix.neugebauer/32/202_2.png) [@felix.neugebauer](https://forums.toadworld.com/u/felix.neugebauer)\
**Post date:** [January 31, 2017, 1:13am UTC](https://forums.toadworld.com/t/when-resizing-datafile-error-occurs-ora-02248-invalid-option-for-alter-session/39010/1 "2017-01-31T01:13:55Z")

</div>

ORA-02248: invalid option for ALTER SESSION

When Resizing one datafile, this error occurs

since 12.11.0.1x, but not in older releases.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [February 1, 2017, 7:05pm UTC](https://forums.toadworld.com/t/when-resizing-datafile-error-occurs-ora-02248-invalid-option-for-alter-session/39010/2 "2017-02-01T19:05:42Z")

</div>

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.