6 Replies Latest reply on Aug 9, 2013 9:51 AM by Brian Maher

    EA 4.0 - Icon for partitioned tables changed

    MPf_dba&dataGmbH

      The icon in the tree list changed in the EA Version 4.0 to the normal table icon.

      Best will be to get an icon with a small "p" inside so that partitioned tables can be seen in the tree list.

        • 1. Re: EA 4.0 - Icon for partitioned tables changed
          Brian Maher

          Are they exactly the same?  Partitioned table icon should be like a split table icon.

          • 2. Re: EA 4.0 - Icon for partitioned tables changed
            MPf_dba&dataGmbH

            The insert image button doesn't work. Where can i send a scrennshot?

            • 3. Re: EA 4.0 - Icon for partitioned tables changed
              Brian Maher

              If they are identical  can you send me the SQL for the partitioned table  (or make a dummy one up of the same form).    The partitioned table I have has an icon that has like a white lightning strip through the middle of it.

              • 4. Re: EA 4.0 - Icon for partitioned tables changed
                MPf_dba&dataGmbH

                CREATE TABLE "ANPQUALITY"."PART_REPLICATION"

                  ( "UNIQUEPART_ID"   VARCHAR2(80 BYTE) NOT NULL ENABLE,

                    "IDENTIFIER_TYPE" VARCHAR2(10 BYTE) NOT NULL ENABLE,

                    "DATE_CHANGED"   TIMESTAMP (6) WITH TIME ZONE,

                    "TIME_STAMP"     TIMESTAMP (6) WITH TIME ZONE,

                    "V_DATE_CHANGED" DATE GENERATED ALWAYS AS (TO_DATE(TO_CHAR("DATE_CHANGED",'YYYYMMDD HH24:MI:SS'),'YYYYMMDD HH24:MI:SS')) VIRTUAL VISIBLE ,

                    CONSTRAINT "PART_REPLICATION_PK" PRIMARY KEY ("UNIQUEPART_ID", "IDENTIFIER_TYPE") USING INDEX PCTFREE 5 INITRANS 8 MAXTRANS 255

                       COMPUTE STATISTICS STORAGE(INITIAL 104857600 NEXT 104857600 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

                        BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE TRACE ENABLE)

                  PCTFREE 5 PCTUSED 40 INITRANS 8 MAXTRANS 255 COMPRESS FOR OLTP STORAGE

                  (BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

                  TABLESPACE "TRACE" LOB ("PART_DATA") STORE AS BASICFILE (

                    ENABLE STORAGE IN ROW CHUNK 32768 RETENTION NOCACHE LOGGING STORAGE( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

                  )

                  PARTITION BY RANGE ("V_DATE_CHANGED") INTERVAL (NUMTOYMINTERVAL(1,'MONTH')  )

                  (PARTITION "P_00" VALUES LESS THAN (TO_DATE(' 2012-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

                  PCTFREE 5 PCTUSED 40 INITRANS 8 MAXTRANS 255

                  STORAGE(INITIAL 104857600 NEXT 104857600 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

                  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

                  TABLESPACE "TRACE" LOB ("PART_DATA") STORE AS BASICFILE (

                   TABLESPACE "TRACE" ENABLE STORAGE IN ROW CHUNK 32768 RETENTION NOCACHE LOGGING

                     STORAGE(INITIAL 104857600 NEXT 104857600 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

                     BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))

                  COMPRESS FOR OLTP

                  ) ;

                • 5. Re: EA 4.0 - Icon for partitioned tables changed
                  Brian Maher

                  HI,  thanks for the DDL.   I removed the storage clauses and created a table with the same structure.  I still see the 'slightly' different icon indicating a 'split' table.   What DB version are you using and if you create a table like this are you still seeing identical table icon for this one?

                   

                  CREATE TABLE "TEST_REPLICATION"

                    (

                      "UNIQUEPART_ID"   VARCHAR2(80 BYTE) NOT NULL ENABLE,

                      "IDENTIFIER_TYPE" VARCHAR2(10 BYTE) NOT NULL ENABLE,

                      "DATE_CHANGED"    TIMESTAMP (6) WITH TIME ZONE,

                      "TIME_STAMP"      TIMESTAMP (6) WITH TIME ZONE,

                      "V_DATE_CHANGED"  DATE GENERATED ALWAYS AS (TO_DATE(TO_CHAR("DATE_CHANGED",'YYYYMMDD HH24:MI:SS'),'YYYYMMDD HH24:MI:SS')) VIRTUAL VISIBLE ,

                      CONSTRAINT "PART_REPLICATION_PK" PRIMARY KEY ("UNIQUEPART_ID", "IDENTIFIER_TYPE") USING INDEX PCTFREE 5 INITRANS 8 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 104857600 NEXT 104857600 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) ENABLE

                    )

                    PCTFREE 5 PCTUSED 40 INITRANS 8 MAXTRANS 255 COMPRESS FOR OLTP STORAGE

                    (

                      BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT

                    )

                    PARTITION BY RANGE

                    (

                      "V_DATE_CHANGED"

                    )

                    INTERVAL

                    (

                      NUMTOYMINTERVAL(1,'MONTH')

                    )

                    (

                      PARTITION "P_00" VALUES LESS THAN (TO_DATE(' 2012-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) PCTFREE 5 PCTUSED 40 INITRANS 8 MAXTRANS 255 STORAGE(INITIAL 104857600 NEXT 104857600 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

                    ) ;

                  • 6. Re: EA 4.0 - Icon for partitioned tables changed
                    Brian Maher

                    We tried different users and different database versions.  I can now reproduce.    It is something to do with system privs but will look further into it.