Toad World® Forums

Partition script problem

Toad 12.9.0.38b x64

Trying to get table script for partition (run as owner of the table).

Access violation at address 0000000008500657 in module 'Froggy_129b.exe'. Read of address 000000000000001D
Tried refresh, restart Toad and nothing ... all the time same error
Froggy is mine rename of toad.exe to prevent some "DBA" task on killing session...just renamed Toad.exe to that name-done that in last one year all the time with no problems.

This was in previous release...

12.9.0.39 has the same problem.

Damir - I haven’t been able to replicate yet, but partitioning can get kind of complex and use different types, so there might be something specific to that specific setup. Do you get that AV on all partitioned tables? If not, maybe that’ll help narrow down the differences. If you can send the DDL for the table that would help, or specify the type of partitioning being used (Range, List, Hash, System, Supartions, etc.) maybe I’d have better luck trying to replicate. Thanks.

Hi, in attachment are table as well all index that belong to that table

Brg,


Damir Vadas
http://damir-vadas.blogspot.com

It does not matter what you have in your life, but who!

Razmislite o čuvanju okoliša prije nego odštampate ovaj e-mail
Please consider the environment before printing this email

On Tue, Mar 15, 2016 at 3:11 PM, Dennis Paulus bounce-Dennis_Paulus@toadworld.com wrote:

RE: Partition script problem

Reply by Dennis Paulus
Damir - I haven’t been able to replicate yet, but partitioning can get kind of complex and use different types, so there might be something specific to that specific setup. Do you get that AV on all partitioned tables? If not, maybe that’ll help narrow down the differences. If you can send the DDL for the table that would help, or specify the type of partitioning being used (Range, List, Hash, System, Supartions, etc.) maybe I’d have better luck trying to replicate. Thanks.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - Beta notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.

Thanks Damir. I setup your table locally, but unfortunately, I haven’t been able to replicate the problem, and nothing stands out on why it might be getting an AV. What Oracle db and client version are you using?

OC 11.2.0.3 x64, db 11.2.0.3 x64 hpux 64

This cone on previous version…will look and try to understand why on some partitions doesn’t make problems

On Mar 15, 2016 17:55, “Dennis Paulus” bounce-Dennis_Paulus@toadworld.com wrote:

RE: Partition script problem

Reply by Dennis Paulus
Thanks Damir. I setup your table locally, but unfortunately, I haven’t been able to replicate the problem, and nothing stands out on why it might be getting an AV. What Oracle db and client version are you using?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - Beta notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.

Assembler Information:


; Base Address: $4200000, Allocation Base: $4190000, Region Size: 125128704

; Allocation Protect: PAGE_EXECUTE_WRITECOPY, Protect: PAGE_EXECUTE_READWRITE

; State: MEM_COMMIT, Type: MEM_IMAGE

;

;

; System.AnsiCompareText (Line=5572 - Offset=0)

; ---------------------------------------------

00000000042008C0 4155 PUSH R13

00000000042008C2 57 PUSH RDI

00000000042008C3 56 PUSH RSI

00000000042008C4 53 PUSH RBX

00000000042008C5 4883EC38 SUB RSP, $38

00000000042008C9 4889D3 MOV RBX, RDX

;

; Line=5573 - Offset=12

; ---------------------

00000000042008CC 4833F6 XOR RSI, RSI

00000000042008CF 4885C9 TEST RCX, RCX

00000000042008D2 7403 JZ +3 ; ($00000000042008D7) System.AnsiCompareText (Line=5573)

00000000042008D4 8B71FC MOV ESI, [RCX-4]

00000000042008D7 4833FF XOR RDI, RDI

00000000042008DA 4885DB TEST RBX, RBX

00000000042008DD 7403 JZ +3 ; ($00000000042008E2) System.AnsiCompareText (Line=5573)

;

; Line=5573 - Offset=31

; ---------------------

00000000042008DF 8B7BFC MOV EDI, [RBX-4] ; <-- EXCEPTION

00000000042008E2 E8F913FAFF CALL -$05EC07 ; ($00000000041A1CE0) System._UStrToPWChar

00000000042008E7 4989C5 MOV R13, RAX

00000000042008EA 4889D9 MOV RCX, RBX

00000000042008ED E8EE13FAFF CALL -$05EC12 ; ($00000000041A1CE0) System._UStrToPWChar

00000000042008F2 C7C100040000 MOV ECX, $00000400

00000000042008F8 C7C201000000 MOV EDX, 1

00000000042008FE 4D89E8 MOV R8, R13

0000000004200901 4189F1 MOV R9D, ESI

0000000004200904 4889442420 MOV [RSP+$20], RAX

0000000004200909 897C2428 MOV [RSP+$28], EDI

000000000420090D E82E13FBFF CALL -$04ECD2 ; ($00000000041B1C40->0000000076FF4F30) kernel32.CompareStringW

0000000004200912 83E802 SUB EAX, 2

;

; Line=5575 - Offset=85

; ---------------------

0000000004200915 4883C438 ADD RSP, $38

0000000004200919 5B POP RBX

000000000420091A 5E POP RSI

000000000420091B 5F POP RDI

EurekaLog 7.3.1.0

Application:


1.1 Start Date : Wed, 16 Mar 2016 09:05:59 +0100

1.2 Name/Description: Froggy_129b.exe - (Toad™ for Oracle®)

1.3 Version Number : 12.9.0.39

1.4 Parameters :

1.6 Up Time : 12 minute(s), 34 second(s)

Exception:


2.1 Date : Wed, 16 Mar 2016 09:18:33 +0100

2.2 Address : 00000000042008DF

2.3 Module Name: Froggy_129b.exe - (Toad™ for Oracle®)

2.5 Type : EAccessViolation

2.6 Message : Access violation at address 00000000042008DF in module ‘Froggy_129b.exe’. Read of address FFFFFFFFFFFFFFFD.

2.7 ID : 5BEC0000

2.8 Count : 1

2.11 Sent : 0

User:


3.2 Name : A1 Telekom Austria AG

3.3 Email:

Active Controls:


4.1 Form Class : TJumpDropdownForm

4.2 Form Text :

4.3 Control Class: TEdit

4.4 Control Text :

Computer:


5.2 Total Memory : 8520146944 (7,94 Gb)

5.3 Free Memory : 4002652160 (3,73 Gb)

5.4 Total Disk : 161755426816 (150,65 Gb)

5.5 Free Disk : 43258408960 (40,29 Gb)

5.6 System Up Time : 19 hour(s), 31 minute(s), 51 second(s)

5.7 Processor : Intel® Core™ i7-3520M CPU @ 2.90GHz

5.12 Virtual Machine:

Operating System:


6.1 Type : Microsoft Windows 7 (64 bit)

6.2 Build #: 7601 (6.1.7601.17965)

Steps to reproduce:


8.1 Text:

Call Stack Information:


|Methods |Details|Stack |Address |Module |Offset |Unit |Class |Procedure/Method |Line |


|*Exception Thread: ID=2580; Parent=0; Priority=-2 |

|Class=; Name=MAIN |

|DeadLock=0; Wait Chain= |

|Comment= |

|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------|

|7FFFFFFE|04 |0000000000000000|00000000042008DF|Froggy_129b.exe|00000000000708DF|System.SysUtils | |AnsiCompareText |5573[1] |

|00000040|04 |000000000042E848|000000000425750D|Froggy_129b.exe|00000000000C750D|System.Classes |TStringList |CompareStrings |6404[4] |

|00000040|03 |000000000042E878|000000000478AFBD|Froggy_129b.exe|00000000005FAFBD|tdClasses |TtdStringList |CompareStrings | |

|00000040|04 |000000000042E8A8|0000000004256EBB|Froggy_129b.exe|00000000000C6EBB|System.Classes |TStringList |Find |6222[7] |

|00000040|04 |000000000042E908|0000000004256A3F|Froggy_129b.exe|00000000000C6A3F|System.Classes |TStringList |AddObject |6099[4] |

|00000040|04 |000000000042E968|0000000004256A01|Froggy_129b.exe|00000000000C6A01|System.Classes |TStringList |Add |6091[1] |

|00000040|03 |000000000042E998|000000000885E79D|Froggy_129b.exe|00000000046CE79D|tjFileIndex |TtjFileIndex |BuildActionFilenames | |

|00000040|03 |000000000042EA48|000000000885F39E|Froggy_129b.exe|00000000046CF39E|tjFileIndex |TtjFileIndex |Build | |

|00000040|03 |000000000042EA88|0000000008884738|Froggy_129b.exe|00000000046F4738|tjManager |TToadJump |StartFileIndexing | |

|00000040|03 |000000000042EAB8|000000000697BA06|Froggy_129b.exe|00000000027EBA06|frmJumpDropdown |TJumpDropdownForm |FormActivate | |

|00000040|03 |000000000042EAE8|00000000045F4CC6|Froggy_129b.exe|0000000000464CC6|Vcl.Forms |TCustomForm |Activate | |

|00000040|03 |000000000042EB28|00000000045F6547|Froggy_129b.exe|0000000000466547|Vcl.Forms |TCustomForm |CMActivate | |

|00000040|04 |000000000042EB68|000000000419CE6E|Froggy_129b.exe|000000000000CE6E|System |TObject |Dispatch |13705[10] |

|00000040|04 |000000000042EBB8|00000000044780C3|Froggy_129b.exe|00000000002E80C3|Vcl.Controls |TControl |WndProc |7204[91] |

|00000040|04 |000000000042ED28|000000000447F4A3|Froggy_129b.exe|00000000002EF4A3|Vcl.Controls |TWinControl |WndProc |9976[152] |

|00000040|03 |000000000042EDF8|00000000045F0D0B|Froggy_129b.exe|0000000000460D0B|Vcl.Forms |TCustomForm |WndProc | |

|00000040|04 |000000000042EEB8|000000000447E717|Froggy_129b.exe|00000000002EE717|Vcl.Controls |TWinControl |MainWndProc |9689[3] |

|00000040|04 |000000000042EF08|000000000426E144|Froggy_129b.exe|00000000000DE144|System.Classes | |StdWndProc |13895[8] |

|00000040|03 |000000000042EF58|0000000076E79BCA|user32.dll |0000000000019BCA|USER32 | | (possible TranslateMessageEx+666) | |

|00000040|03 |000000000042F018|0000000076E772C6|user32.dll |00000000000172C6|USER32 | | (possible SetWindowTextW+626) | |

|00000040|03 |000000000042F078|0000000076E76826|user32.dll |0000000000016826|USER32 | | (possible IsDialogMessageW+358) | |

|00000040|03 |000000000042F0D8|000000007736D8F2|ntdll.dll |000000000004D8F2|ntdll | |KiUserCallbackDispatcher | |

|00000040|03 |000000000042F160|0000000076E7685A|user32.dll |000000000001685A|USER32 | | (possible IsDialogMessageW+410) | |

|00000040|03 |000000000042F168|0000000076E7383E|user32.dll |000000000001383E|USER32 | | (possible GetWindowLongPtrA+126) | |

|00000040|03 |000000000042F1F8|0000000076E76BA8|user32.dll |0000000000016BA8|USER32 | |SendMessageW | |

|00000040|03 |000000000042F248|00000000045EBD84|Froggy_129b.exe|000000000045BD84|Vcl.Forms | |SendFocusMessage | |

|00000040|03 |000000000042F278|00000000045F46B0|Froggy_129b.exe|00000000004646B0|Vcl.Forms |TCustomForm |SetFocusedControl | |

|00000040|04 |000000000042F318|000000000447EECF|Froggy_129b.exe|00000000002EEECF|Vcl.Controls |TWinControl |WndProc |9850[26] |

|00000040|04 |000000000042F3E8|000000000447E717|Froggy_129b.exe|00000000002EE717|Vcl.Controls |TWinControl |MainWndProc |9689[3] |

|00000040|04 |000000000042F438|000000000426E144|Froggy_129b.exe|00000000000DE144|System.Classes | |StdWndProc |13895[8] |

|00000040|03 |000000000042F488|0000000076E79BCA|user32.dll |0000000000019BCA|USER32 | | (possible TranslateMessageEx+666) | |

|00000040|03 |000000000042F548|0000000076E772C6|user32.dll |00000000000172C6|USER32 | | (possible SetWindowTextW+626) | |

|00000040|03 |000000000042F5A8|0000000076E76826|user32.dll |0000000000016826|USER32 | | (possible IsDialogMessageW+358) | |

|00000040|03 |000000000042F608|000000007736D8F2|ntdll.dll |000000000004D8F2|ntdll | |KiUserCallbackDispatcher | |

|00000040|03 |000000000042F690|0000000076E6D22A|user32.dll |000000000000D22A|USER32 | |SetFocus | |

|00000040|03 |000000000042F698|00000000045F4A08|Froggy_129b.exe|0000000000464A08|Vcl.Forms |TCustomForm |SetWindowFocus | |

|00000040|03 |000000000042F6D8|00000000045F4ABF|Froggy_129b.exe|0000000000464ABF|Vcl.Forms |TCustomForm |SetActive | |

|00000040|03 |000000000042F718|00000000045F5A74|Froggy_129b.exe|0000000000465A74|Vcl.Forms |TCustomForm |WMActivate | |

|00000040|04 |000000000042F758|000000000419CE6E|Froggy_129b.exe|000000000000CE6E|System |TObject |Dispatch |13705[10] |

|00000040|04 |000000000042F7A8|00000000044780C3|Froggy_129b.exe|00000000002E80C3|Vcl.Controls |TControl |WndProc |7204[91] |

|00000040|04 |000000000042F918|000000000447F4A3|Froggy_129b.exe|00000000002EF4A3|Vcl.Controls |TWinControl |WndProc |9976[152] |

|00000040|03 |000000000042F9E8|00000000045F0D0B|Froggy_129b.exe|0000000000460D0B|Vcl.Forms |TCustomForm |WndProc | |

|00000040|04 |000000000042FAA8|000000000447E717|Froggy_129b.exe|00000000002EE717|Vcl.Controls |TWinControl |MainWndProc |9689[3] |

|00000040|04 |000000000042FAF8|000000000426E144|Froggy_129b.exe|00000000000DE144|System.Classes | |StdWndProc |13895[8] |

|00000040|03 |000000000042FB48|0000000076E79BCA|user32.dll |0000000000019BCA|USER32 | | (possible TranslateMessageEx+666) | |

|00000040|03 |000000000042FC08|0000000076E772C6|user32.dll |00000000000172C6|USER32 | | (possible SetWindowTextW+626) | |

|00000040|03 |000000000042FC68|0000000076E76826|user32.dll |0000000000016826|USER32 | | (possible IsDialogMessageW+358) | |

|00000040|03 |000000000042FCC8|000000007736D8F2|ntdll.dll |000000000004D8F2|ntdll | |KiUserCallbackDispatcher | |

|00000040|03 |000000000042FD50|0000000076E7908A|user32.dll |000000000001908A|USER32 | | (possible PeekMessageW+186) | |

|00000040|03 |000000000042FD58|0000000076E79050|user32.dll |0000000000019050|USER32 | |PeekMessageW | |

|00000040|03 |000000000042FDA8|00000000045FEB4C|Froggy_129b.exe|000000000046EB4C|Vcl.Forms |TApplication |ProcessMessage | |

|00000040|03 |000000000042FE28|00000000045FECC3|Froggy_129b.exe|000000000046ECC3|Vcl.Forms |TApplication |HandleMessage | |

|00000040|03 |000000000042FE98|00000000045FF1BF|Froggy_129b.exe|000000000046F1BF|Vcl.Forms |TApplication |Run | |

|00000040|03 |000000000042FED8|0000000009743319|Froggy_129b.exe|00000000055B3319|Toad | |Initialization | |

|00000040|03 |000000000042FF58|0000000076FF5A4B|kernel32.dll |0000000000015A4B|kernel32 | |BaseThreadInitThunk | |

|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------|

| |

|Running Thread: ID=6860; Parent=2580; Priority=0 |

Registers:


RAX: 0000000004788F98 RDI: 0000000000000000

RBX: 0000000000000001 RSI: 0000000000000033

RCX: 00000000275EB4C0 RBP: 000000000042E910

RDX: 0000000000000001 RSP: 000000000042E7F0

R8 : 0000000000000001 R9 : 0000000000000001

R10: 00000000E7FFFFFF R11: 00000000006342A0

R12: 0000000000000000 R13: 0000000000000011

R14: 0000000000000008 R15: 00000000000A0EBE

RIP: 00000000042008DF FLG: 0000000000010202

EXP: 00000000042008DF STK: 000000000042E7F0

Stack: Memory Dump:


0000000029B03578: 000000000000001C 00000000042008DF: 8B 7B FC E8 F9 13 FA FF 49 89 C5 48 89 D9 E8 EE .{…I…H…

0000000029B03570: 0000000000000001 00000000042008EF: 13 FA FF C7 C1 00 04 00 00 C7 C2 01 00 00 00 4D …M

0000000029B03568: 00000000041A03D6 00000000042008FF: 89 E8 41 89 F1 48 89 44 24 20 89 7C 24 28 E8 2E …A…H.D$ .|$(…

0000000029B03560: 0000000027546050 000000000420090F: 13 FB FF 83 E8 02 48 83 C4 38 5B 5E 5F 41 5D C3 …H…8[^_A].

0000000029B03558: 0000000004257512 000000000420091F: CC 48 83 EC 28 E8 97 FF FF FF 85 C0 0F 94 C0 48 .H…(…H

0000000029B03550: 0000000000000011 000000000420092F: 83 C4 28 C3 CC CC CC CC CC CC CC CC CC CC CC CC …(…

0000000029B03548: 0000000000000000 000000000420093F: CC 48 83 EC 38 C7 C0 00 04 00 00 4D 33 C0 49 89 .H…8…M3.I.

0000000029B03540: 0000000000000000 000000000420094F: C9 41 83 CA FF 48 89 54 24 20 C7 44 24 28 FF FF .A…H.T$ .D$(…

0000000029B03538: 0000000000000001 000000000420095F: FF FF 89 C1 44 89 C2 4D 89 C8 45 89 D1 E8 EF 12 …D…M…E…

0000000029B03530: 0000000000000000 000000000420096F: FB FF 83 E8 02 48 83 C4 38 C3 CC CC CC CC CC CC …H…8…

0000000029B03528: 0000000000000000 000000000420097F: CC 48 83 EC 38 C7 C0 00 04 00 00 41 C7 C1 01 00 .H…8…A…

0000000029B03520: 00000000041A0FEC 000000000420098F: 00 00 49 89 CA 45 89 C3 48 89 54 24 20 44 89 44 …I…E…H.T$ D.D

0000000029B03518: 0000000004788F98 000000000420099F: 24 28 89 C1 44 89 CA 4D 89 D0 45 89 D9 E8 AF 12 $(…D…M…E…

0000000029B03510: 0000000000000000 00000000042009AF: FB FF 83 E8 02 48 83 C4 38 C3 CC CC CC CC CC CC …H…8…

0000000029B03508: 000000002747FDB0 00000000042009BF: CC 56 53 48 83 EC 28 48 89 CB 48 33 F6 48 85 D2 .VSH…(H…H3.H…

0000000029B03500: 000000000000001C 00000000042009CF: 74 06 8B 72 FC C1 EE 01 48 89 D1 E8 51 0B FA FF t…r…H…Q…

The matter of fact I have problems even with normal tables…what to reset (that in some upgrade) went “crazy”?

Post the log file, Damir.

I have posted 4 logs from Exception handler, send table and index scripts by mail (do not know now to whom…delete history) and now you asking me for a log…could you be more specific?

:slight_smile:

The Toad.el file. Anytime you have an error, post it. The posting of the call stack above is helpful, but it’s helpful to see the entire log file as it may contain other exceptions preceding this one.

Is this “toad.el” …which I didn’t find on mine whole disk!


** APPLICATION INFORMATION - BETA VERSION (64-bit)


Support Bundle for Toad for Oracle 12.9.0.39

This copy of Toad for Oracle registered to VADAS SAVJETOVANJE DOO

Bundle: Toad for Oracle Xpert (64-bit), Add-Ons: DB Admin Module

Edition: Toad DBA Suite for Oracle

Toad for Oracle Executable Location: C:\oracle\Dell\Toad for Oracle 12.9 Beta\Froggy_129b.exe

User Profile Directory: C:\Users\Q383211\AppData\Roaming\Dell\Toad for Oracle\12.9 beta\

QSEServer DLL Location: C:\oracle\Dell\Toad for Oracle 12.9 Beta\qse.dll

QSEServer DLL Version: 12.9.0.39

QP5 DLL Location: C:\oracle\Dell\Toad for Oracle 12.9 Beta\QP5.dll

QP5 DLL Version: 5.292.16046.31748

QP5CA DLL Location: C:\oracle\Dell\Toad for Oracle 12.9 Beta\QP5CA.dll

QP5CA DLL Version: 5.292.16046.31970

SciLexer DLL Location: C:\oracle\Dell\Toad for Oracle 12.9 Beta\SciLexer.dll

SciLexer DLL Version: 3.6.1.1

TOAD Policy Location: C:\oracle\Dell\Toad for Oracle 12.9 Beta\Toad.pdl


** TEAM CODING


Connection: Q383211@SMOBCST1

Team Coding Status Checks

Team Coding is not installed

Team Coding@SMOBCST1

Team Coding not installed

Team Coding Session Messages

15:39:57: Team Coding is not installed


** MANAGED ITEMS


Not a managed environment.


** ORACLE CLIENT INFORMATION


Oracle Client Version : 11.2.0.3

Oracle Client DLL : c:\oracle\product\11.2.0\dbhome_1\BIN\oci.dll

TNSNAMES.ora Location : u:\oracle\network\admin\tnsnames.ora

NLS_LANG : AMERICAN_AMERICA.WE8MSWIN1252

SQLPATH : u:\sql

LOCAL :


** ORACLE SERVER INFORMATION


Connection 1 : Q383211@SMOBCST1 ** Active Session **

Oracle Server Version : Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

Oracle Server NLS_CHARACTERSET : WE8ISO8859P1

Oracle Server NLS_NCHAR_CHARACTERSET : AL16UTF16

Oracle Session User : Q383211 (Normal)


** SYSTEM INFORMATION


Operating System: Windows 7 (Build 7601)Service Pack 1

Is Terminal Server: No

Using XP Theme: Yes

Language: German

Country: Austria

Input Language: German

Physical Memory Load: 54,55 %

Physical Memory (Total): 8125 MB

Physical Memory (Free): 3693 MB

Virtual Memory (Total): 8388607 MB

Virtual Memory (Free): 8387889 MB

Swap Space (Total): 16249 MB

Swap Space (Free): 11700 MB

Toad Page File Usage (Virtual Memory): 324 MB

Toad Working Set Usage (RAM): 321 MB

Environment Variable (PATH):

C:\Windows\system32

C:\Windows

C:\Windows\System32\Wbem

C:\Windows\System32\WindowsPowerShell\v1.0\

C:\Program Files\Microsoft Application Virtualization Client

C:\Program Files\WIDCOMM\Bluetooth Software\

C:\Program Files\WIDCOMM\Bluetooth Software\syswow64

c:\oracle\product\11.2.0\dbhome_1\bin

c:\Users\Q383211\AppData\Local\WinTools

Environment Variable (TNS_ADMIN): u:\oracle\network\admin


** ORACLE HOMES DATA


(Oracle Root)

inst_loc = C:\Program Files\Oracle\Inventory

NLS_LANG = GERMAN_GERMANY.WE8MSWIN1252

KEY_OraClient12Home2

ORACLE_HOME = C:\Programme\Oracle\product\12.1.0\client_1

ORACLE_HOME_NAME = OraClient12Home2

ORACLE_GROUP_NAME = Oracle - OraClient12Home2

NLS_LANG = GERMAN_GERMANY.WE8MSWIN1252

ORACLE_BUNDLE_NAME = Enterprise

OLEDB = C:\Programme\Oracle\product\12.1.0\client_1\oledb\mesg

ORACLE_HOME_TYPE = 2

ORACLE_SVCUSER = NT-AUTORITÄT\LOKALER DIENST

ORACLE_SVCUSER_PWDREQ = 0

SQLPATH = C:\Programme\Oracle\product\12.1.0\client_1\dbs

ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient12Home2

MSHELP_TOOLS = C:\Programme\Oracle\product\12.1.0\client_1\MSHELP

KEY_OraDb11g_home1 ***** This is the home currently used by Toad *****

ORACLE_HOME = c:\oracle\product\11.2.0\dbhome_1

ORACLE_HOME_NAME = OraDb11g_home1

ORACLE_GROUP_NAME = Oracle - OraDb11g_home1

ORACLE_BUNDLE_NAME = Enterprise

OLEDB = c:\oracle\product\11.2.0\dbhome_1\oledb\mesg

ORAMTS_CP_TRACE_LEVEL = 0

ORAMTS_CP_TRACE_DIR = c:\oracle\product\11.2.0\dbhome_1\oramts\Trace

ORAMTS_CONN_POOL_TIMEOUT = 120

ORAMTS_SESS_TXNTIMETOLIVE = 120

ORAMTS_NET_CACHE_MAXFREE = 5

ORAMTS_NET_CACHE_TIMEOUT = 120000

ORAMTS_OSCREDS_MATCH_LEVEL = OS_AUTH_LOGIN

MSHELP_TOOLS = c:\oracle\product\11.2.0\dbhome_1\MSHELP

SQLPATH = c:\oracle\product\11.2.0\dbhome_1\dbs

ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraDb11g_home1

ORACLE_BASE = c:\oracle

RDBMS_CONTROL = c:\oracle\product\11.2.0\dbhome_1\DATABASE

RDBMS_ARCHIVE = c:\oracle\product\11.2.0\dbhome_1\DATABASE\ARCHIVE

NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252

ORA_XESSD_AUTOSTART = TRUE

ORA_XESSD_SHUTDOWN = TRUE

ORA_XESSD_SHUTDOWNTYPE = immediate

ORA_XESSD_SHUTDOWN_TIMEOUT = 90

ORACLE_SID = XESSD

_NLS_LANG = GERMAN_GERMANY.WE8MSWIN1252

OraClient12Home2

C:\Programme\Oracle\product\12.1.0\client_1\bin exists

C:\Programme\Oracle\product\12.1.0\client_1\bin is not in PATH

Home is not valid

OraDb11g_home1

c:\oracle\product\11.2.0\dbhome_1\bin exists

c:\oracle\product\11.2.0\dbhome_1\bin is in PATH

Home is valid


** FORMATTER OPTIONS: C:\Users\Q383211\AppData\Roaming\Dell\Toad for Oracle\12.9 beta\User Files\FmtPlus_Vadas.opt


[Qp5FormatterOptions]

Version=252

OutputTabs=2

IndentSize=2

IndentTHENonSameLine=1

IndentLOOPonSameLine=1

RightMargin=140

Tagline=0


** WINDOW USAGE


TfrmObjects - 4824

TFormToadEditor - 4227

TF4HolderForm - 3095

TADDMReportForm - 243

TProjectManagerForm - 163

TTableForm - 155

TTableForm - 155

TfrmAnalyze - 154

TFormToadAppDesigner - 126

TTraceFileBrowserForm - 118

TExportWatchForm - 92

TIndexForm - 92

TTriggerForm - 82

TFmQueryBuilder - 64

TFormSQLOptimizer - 53

TSessionBrowserForm - 51

TAPEXExportForm - 51

TFormExportDDL - 46

TViewForm - 45

TFormWrap - 40

TDataPumpExportForm - 39

TfrmNLSParams - 38

TDataImportForm - 35

TFormObjectSearch - 35

TDiffHolderForm - 28

TfrmRebuildTable - 28

TfrmSchemaDoc - 24

TExportWizardForm - 18

TCreateDataForm - 18

TTablespaceForm - 18

TfrmIndRbld - 15

TImportWizardForm - 14

TExportBrowserForm - 13

TFormERD - 12

TSQLLoader - 12

TSegmentAdvisorForm - 11

TfrmTopSess - 11

TDataPumpImportForm - 10

TAWRBrowserForm - 10

TtdProfileAnalysisForm - 9

TEstimateIndSizeForm - 8

TDirectoryForm - 7

TSchemaScriptForm - 7

TCXMainForm - 6

TSnapshotForm - 5

TSnapshotLogForm - 5

TRedoLogManagerForm - 5

TAlertLogForm - 5

TDataCompareForm - 4

TDBrowserForm - 4

TfrmLogSwitch - 4

TfrmOraInit - 4

TfrmComp1Obj - 4

TfrmTableSpaces - 4

TSchedulerJobForm - 4

TEstimateTabSizeForm - 3

TDBProbeForm - 3

TThreadedQueryViewerForm - 3

TIMonitor - 3

TDBHealthCheckForm - 3

TToadOnlineForm - 3

TCompareSchemasForm - 3

TfrmDbmsMDI - 3

TInstanceManagerForm - 2

TTOADFTP - 2

TCompareMultipleSchemasForm - 2

TfrmTrace - 2

TTablespaceMapForm - 2

TfrmLogMiner - 2

TDBMS_SQLTuneForm - 1

TUndoAdvisorForm - 1

TToadAdvisorForm - 1

TFormSupportBundle - 1

TAuditForm - 1

TActionRecallMoreForm - 1

TfrmExPlan - 1

TProjectLucyForm - 1

TUserViewerForm - 0

TDBDocForm - 0

TCredentialForm - 0

TMediaViewerForm - 0

TWikiPageViewerForm - 0

TThreadViewerForm - 0

TTelligentSearchForm - 0

TBlogPostViewerForm - 0

TCXRuleBuilder - 0

TUnifiedAuditPolicyForm - 0

TFlashbackForm - 0

TTCDockForm - 0

TZoneMapForm - 0

TASHBrowserForm - 0

TContextForm - 0

TTCSummaryForm - 0

TStatsPackBrowserForm - 0

TFlashbackArchiveForm - 0

TFormLegend - 0

TCopyTableDataForm - 0

TMDIDescribeForm - 0

TAuditPolicyForm - 0

TEditionForm - 0

TTransformationForm - 0

TQuickDescribeForm - 0

TDBDocForm - 0

TSearchInFilesForm - 0

TQueryConditionForm - 0

TfrmJava2PLSqlUI - 0

TTelligentForumPostForm - 0

TTelligentForumPostForm - 0

TFormGridSaveAs - 0

TSBLegendForm - 0

TQBForm - 0

TCXMetricsHistory - 0

TRedactionPolicyForm - 0

TFormExecuteScript - 0

TfrmSynonyms - 0

TfrmCreateUser - 0

TScriptManagerForm - 0

TProfileForm - 0

TRBSForm - 0

TfrmMakeSeq - 0

TfrmTKProf - 0

TfrmJavaManager - 0

TDimensionForm - 0

TDatabaseScriptForm - 0

TTNSNamesEditorForm - 0

TSchedulerForm - 0

TOutputFrm - 0

TfrmChainedRows - 0

TfrmTblFilter - 0

TfrmTabDupes - 0

TfrmMain - 0

TOSMonitorForm - 0

TPinnedPackageForm - 0

TMasterDetailForm - 0

TfrmConsDef - 0

TfrmDbLinks - 0

TLibraryForm - 0

TDataSubsetWizardForm - 0

TSecurityForm - 0

TfrmImportExport - 0

TCompareDatabasesForm - 0

TAuditSQLForm - 0

TMultiObjectPrivForm - 0

TIndexMonitoringForm - 0

TWindowForm - 0

TWindowGroupForm - 0

TTaskSchedulerForm - 0

TDataPumpManagerForm - 0

TASMForm - 0

TDiskGroupForm - 0

TDBMSRedefForm - 0

TFormRefCursorResults - 0

TReportsForm - 0

TExplainPlanCompareForm - 0

TClusterForm - 0

TFormRPlanSchedule - 0

TFormModRGroup - 0

TfrmComp1DBObj - 0

TFormCRM - 0

TServiceMgrForm - 0

TFormModRPlan - 0

TScheduleForm - 0

TChainForm - 0

TJobClassForm - 0

TRefreshGroupForm - 0

TQueueForm - 0

TProgramForm - 0

Look for froggy.el (or whatever your exe name is) then. :slight_smile: What you just posted is your Support Bundle. Your prior posting from yesterday is a single call stack from the log file.

uf … I see now…

Sent to mail (toadoraclebeta) .zippy file.

Thx

toadoraclebeta@toadworld.com is a no-reply address used for sending out mail. I have no idea where mail sent to it ends up. You can just post it as an attachment to your forum posts or send it to one of us directly. My email is michael.staszewski@quest.com

attached .el file…

Brg,


Damir Vadas
http://damir-vadas.blogspot.com

It does not matter what you have in your life, but who!

Razmislite o čuvanju okoliša prije nego odštampate ovaj e-mail
Please consider the environment before printing this email

On Thu, Mar 17, 2016 at 3:47 PM, Michael Staszewski bounce-mstaszew@toadworld.com wrote:

RE: Partition script problem

Reply by Michael Staszewski
Look for froggy.el (or whatever your exe name is) then. :slight_smile: What you just posted is your Support Bundle. Your prior posting from yesterday is a single call stack from the log file.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - Beta notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.

Try again, but just send it to me if you don’t mind (michael.staszewski@quest.com). Toad World’s mail gateway has some room for improvement to say the least. Several on here have problems with attachments. It looks like yours was stripped as well.

This may be related:

In .39 and .40, I’ve been getting “Access violation at address 0000000008505727 in module ‘Toad.exe’. Read of address 000000000000001D” while attempting to script one non-partitioned table. This is the last SQL spooled before that AV:

Select CONSTRAINT_NAME, OWNER, TABLE_NAME, CONSTRAINT_TYPE, SUBSTRB(STATUS, 1, 1) STATUS

, SEARCH_CONDITION

, SUBSTRB(DEFERRABLE, 1, 1) deferrable, SUBSTRB(DEFERRED, 1, 1) deferred, SUBSTRB(GENERATED, 1, 1) generated

, VALIDATED

, RELY

, VIEW_RELATED

FROM SYS.DBA_CONSTRAINTS

WHERE OWNER = :pOwner

AND CONSTRAINT_TYPE in (:ct, ‘?’, ‘F’)

AND Constraint_name in (‘SYS_C0015371’,‘SYS_C0015372’)

and not ((length(CONSTRAINT_NAME) = 30) and

(substr(CONSTRAINT_NAME, 1, 4) = ‘BIN$’) and

(substr(CONSTRAINT_NAME, 27, 4) = ‘==$0’))

order by table_name, constraint_name

The above query returns 2 rows corresponding to the 2 NOT NULL constraints on the table’s columns.

This works fine in 12.8GA…

Thanks!

Rich