Return
-
Title
Toad for Oracle 10.1.1.8. In Schema Browser | Tablespaces tab | Objects tab | Object Name Column -
Description
Toad for Oracle 10.1.1.8. In Schema Browser | Tablespaces tab | Objects tab | Object Name Column, the Object Name that reference a Table with Table Partitions are being truncated or cut-off. This problem does not happen in Toad 9.7.2.5.
-
Resolution
RESOLUTION:
Download and install the latest version of Toad for Oracle to fix the issue. The latest version of Toad for Oracle can be downloaded at:
https://support.quest.com/Search/SearchDownloads.aspx
Additional Information:
TESTS:
1)
Run script below to create a table with partitions.
ÃCREATE TABLE THIS_IS_A_TABLE_WITH_BIG_NAME
(
COL VARCHAR2(3 BYTE),
NAMES VARCHAR2(1 BYTE),
DONT VARCHAR2(1 BYTE),
MATTER VARCHAR2(1 BYTE)
)
PARTITION BY LIST (COL)
(
PARTITION THIS_IS_PART_ABC VALUES ('ABC')
LOGGING
NOCOMPRESS ,
PARTITION THIS_IS_PART_EFG VALUES ('EFG')
LOGGING
NOCOMPRESS ,
PARTITION THIS_IS_PART_DEF VALUES ('DEF')
LOGGING
NOCOMPRESS ,
PARTITION THIS_IS_PART_HIJ VALUES ('HIJ')
LOGGING
NOCOMPRESS
)
2)
Go to Schema Browser | Tablespaces tab | highlight the default Tablespace i.e. USERS | Objects tab | Objects Name column | scroll down to âââ€THIS_IS_A_TABLE_WITH_BIG_NAMEEEEâââ€
3)
You will notice that ittttâââ€s truncated.
ÃToad 10.1.1.8 shows:
THIS_IS_A_TABLE_WITH_BIG_NAME:
THIS_IS_A_TABLE_WITH_BIG_NAME:
THIS_IS_A_TABLE_WITH_BIG_NAME:
THIS_IS_A_TABLE_WITH_BIG_NAME:
ÃToad 9.7.2.5 shows:
THIS_IS_A_TABLE_WITH_BIG_NAME:THIS_IS_PART_ABC
THIS_IS_A_TABLE_WITH_BIG_NAME:THIS_IS_PART_DEF
THIS_IS_A_TABLE_WITH_BIG_NAME:THIS_IS_PART_EFG
THIS_IS_A_TABLE_WITH_BIG_NAME:THIS_IS_PART_HIJ
4)
Also, if you run query below (which is similar to what Toad runs per SQL Monitor), the results shows the full Object Name; it is not truncated.
ÃSelect DECODE (partition_name,
NULL, segment_name,
segment_name || ':' || partition_name
) segment_name,
owner, tablespace_name, segment_type
from dba_segments
where owner = 'MAUI' -
Defect ID
ST72663