# ORA-00740: datafile size of (53687041280) blocks exceeds maximum file size **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [July 9, 2013, 2:37am UTC](https://forums.toadworld.com/t/ora-00740-datafile-size-of-53687041280-blocks-exceeds-maximum-file-size/19399 "2013-07-09T02:37:39Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![steven.cannon](https://avatars.discourse-cdn.com/v4/letter/s/ee7513/32.png) [@steven.cannon](https://forums.toadworld.com/u/steven.cannon)\ **Post date:** [July 9, 2013, 2:37am UTC](https://forums.toadworld.com/t/ora-00740-datafile-size-of-53687041280-blocks-exceeds-maximum-file-size/19399/1 "2013-07-09T02:37:39Z")
Hi, I am having problems trying to re-size tablespaces. I run the calculator tool, but then whenever I try to re-size I get the following error; ORA-00740: datafile size of (53687041280) blocks exceeds maximum file size Regardless of the size of the tablespace. I have recently upgraded to the latest version of Toad - has anyone else run into this problem? Thanks! ---
**Author:** ![alancounihan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/alancounihan/32/31_2.png) [@alancounihan](https://forums.toadworld.com/u/alancounihan)\ **Post date:** [July 9, 2013, 3:26am UTC](https://forums.toadworld.com/t/ora-00740-datafile-size-of-53687041280-blocks-exceeds-maximum-file-size/19399/2 "2013-07-09T03:26:08Z")
Hi Steven, Happens to me also. It works OK in 11.6.1. Must be a bug. Alan. ---
**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:** [July 9, 2013, 6:07am UTC](https://forums.toadworld.com/t/ora-00740-datafile-size-of-53687041280-blocks-exceeds-maximum-file-size/19399/3 "2013-07-09T06:07:39Z")
Can I see a screen shot of the resize datafile window before the error occurs, along with a spool SQL of what SQL Toad is attempting to execute? ---
**Author:** ![alancounihan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/alancounihan/32/31_2.png) [@alancounihan](https://forums.toadworld.com/u/alancounihan)\ **Post date:** [July 9, 2013, 7:19am UTC](https://forums.toadworld.com/t/ora-00740-datafile-size-of-53687041280-blocks-exceeds-maximum-file-size/19399/4 "2013-07-09T07:19:49Z")
Spooled SQL * * * Timestamp: 09/07/2013 15:14:05 declare cursor NlsParamsCursor is MaxCharLength=[1] MinCharLength=[1] NlsDateLanguage=[ NlsDateFormat=[ NlsNumericCharacters=[ NlsTimeStampFormat=[ NlsTimeStampTZFormat=[ Elapsed time: 0.013 * * * Timestamp: 09/07/2013 15:14:05 select Describe Only * * * Timestamp: 09/07/2013 15:14:06 select Describe Only * * * Timestamp: 09/07/2013 15:14:06 select Elapsed time: 0.002 * * * Timestamp: 09/07/2013 15:14:06 select Describe Only * * * Timestamp: 09/07/2013 15:14:06 select Describe Only * * * Timestamp: 09/07/2013 15:14:06 select Elapsed time: 0.003 **SELECT \* FROM nls\_session\_parameters;begin SELECT Nvl(Lengthb(Chr(16777216)), Nvl(Lengthb(Chr(65536)), Nvl(Lengthb(Chr(256)), 1))), Nvl(Lengthb(Chr(1)), 1) INTO :MaxCharLength, :MinCharLength FROM dual; for NlsRecord in NlsParamsCursor loop if NlsRecord.parameter = ‘NLS\_DATE\_LANGUAGE’ then :NlsDateLanguage := NlsRecord.value; elsif NlsRecord.parameter = ‘NLS\_DATE\_FORMAT’ then :NlsDateFormat := NlsRecord.value; elsif NlsRecord.parameter = ‘NLS\_NUMERIC\_CHARACTERS’ then :NlsNumericCharacters := NlsRecord.value; elsif NlsRecord.parameter = ‘NLS\_TIMESTAMP\_FORMAT’ then :NlsTimeStampFormat := NlsRecord.value; elsif NlsRecord.parameter = ‘NLS\_TIMESTAMP\_TZ\_FORMAT’ then :NlsTimeStampTZFormat := NlsRecord.value; end if; end loop;end;‘AMERICAN’]‘DD-MON-RR’]’.,’]‘DD-MON-RR HH.MI.SSXFF AM’]‘DD-MON-RR HH.MI.SSXFF AM TZR’]**\*\*\*\* PARAMETER,VALUE **from** nls\_session\_parameters **where** PARAMETER **in** (‘NLS\_NUMERIC\_CHARACTERS’,‘NLS\_DATE\_FORMAT’,‘NLS\_CURRENCY’)\*\*\*\*\*\*\*\* PARAMETER,VALUE **from** nls\_session\_parameters **where** PARAMETER **in** (‘NLS\_NUMERIC\_CHARACTERS’,‘NLS\_DATE\_FORMAT’,‘NLS\_CURRENCY’)\*\*\*\*\*\*\*\* PARAMETER,VALUE **from** nls\_session\_parameters **where** PARAMETER **in** (‘NLS\_NUMERIC\_CHARACTERS’,‘NLS\_DATE\_FORMAT’,‘NLS\_CURRENCY’)\*\*\*\*\*\*\*\* to\_char(9,‘9C’) **from** dual\*\*\*\*\*\*\*\* to\_char(9,‘9C’) **from** dual\*\*\*\*\*\*\*\* to\_char(9,‘9C’) **from** dual ---
**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:** [July 9, 2013, 7:29am UTC](https://forums.toadworld.com/t/ora-00740-datafile-size-of-53687041280-blocks-exceeds-maximum-file-size/19399/5 "2013-07-09T07:29:48Z")
Oh, I see, you are using the ‘calculate’ button followed by ‘shrink to minimum MB’. I didn’t realize that before. I can reproduce the problem and will fix it. In the meantime, they can double-click on a row and shrink it in the dialog that appears. -John **From:** alancounihan [[mailto:bounce-alancounihan@toadworld.com](mailto:bounce-alancounihan@toadworld.com)] **Sent:** Tuesday, July 09, 2013 9:20 AM **To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com) **Subject:** Re: [Toad for Oracle - Discussion Forum] ORA-00740: datafile size of (53687041280) blocks exceeds maximum file size **[ Re: ORA-00740: datafile size of (53687041280) blocks exceeds maximum file size](http://gyk.r.mailjet.com/redirect/rrpwhx1sf9353bj7f6dyxy/www.toadworld.com/products/toad-for-oracle/f/10/p/14940/39808.aspx#39808)** Reply by alancounihan Spooled SQL **--------------------------------------------------------------------------------** Timestamp: 09/07/2013 15:14:05 declare cursor NlsParamsCursor is **SELECT** \* **FROM** nls\_session\_parameters; **begin** **SELECT** Nvl(Lengthb(Chr(16777216)), Nvl(Lengthb(Chr(65536)), Nvl(Lengthb(Chr(256)), 1))), Nvl(Lengthb(Chr(1)), 1) **INTO** :MaxCharLength, :MinCharLength **FROM** dual; **for** NlsRecord **in** NlsParamsCursor loop **if** NlsRecord.parameter = ‘NLS\_DATE\_LANGUAGE’ then :NlsDateLanguage := NlsRecord.value; elsif NlsRecord.parameter = ‘NLS\_DATE\_FORMAT’ then :NlsDateFormat := NlsRecord.value; elsif NlsRecord.parameter = ‘NLS\_NUMERIC\_CHARACTERS’ then :NlsNumericCharacters := NlsRecord.value; elsif NlsRecord.parameter = ‘NLS\_TIMESTAMP\_FORMAT’ then :NlsTimeStampFormat := NlsRecord.value; elsif NlsRecord.parameter = ‘NLS\_TIMESTAMP\_TZ\_FORMAT’ then :NlsTimeStampTZFormat := NlsRecord.value; **end** **if** ; **end** loop; **end** ; MaxCharLength=[1] MinCharLength=[1] NlsDateLanguage=[ ‘AMERICAN’] NlsDateFormat=[ ‘DD-MON-RR’] NlsNumericCharacters=[ ‘.,’] NlsTimeStampFormat=[ ‘DD-MON-RR HH.MI.SSXFF AM’] NlsTimeStampTZFormat=[ ‘DD-MON-RR HH.MI.SSXFF AM TZR’] Elapsed time: 0.013 **--------------------------------------------------------------------------------** Timestamp: 09/07/2013 15:14:05 **select** PARAMETER,VALUE **from** nls\_session\_parameters **where** PARAMETER **in** (‘NLS\_NUMERIC\_CHARACTERS’,‘NLS\_DATE\_FORMAT’,‘NLS\_CURRENCY’) Describe Only **--------------------------------------------------------------------------------** Timestamp: 09/07/2013 15:14:06 **select** PARAMETER,VALUE **from** nls\_session\_parameters **where** PARAMETER **in** (‘NLS\_NUMERIC\_CHARACTERS’,‘NLS\_DATE\_FORMAT’,‘NLS\_CURRENCY’) Describe Only **--------------------------------------------------------------------------------** Timestamp: 09/07/2013 15:14:06 **select** PARAMETER,VALUE **from** nls\_session\_parameters **where** PARAMETER **in** (‘NLS\_NUMERIC\_CHARACTERS’,‘NLS\_DATE\_FORMAT’,‘NLS\_CURRENCY’) Elapsed time: 0.002 **--------------------------------------------------------------------------------** Timestamp: 09/07/2013 15:14:06 **select** to\_char(9,‘9C’) **from** dual Describe Only **--------------------------------------------------------------------------------** Timestamp: 09/07/2013 15:14:06 **select** to\_char(9,‘9C’) **from** dual Describe Only