As requested
TABLE_NAME CNT
------------------ ----------
GEONORM_DTT_201206 331986
CREATE TABLE "GEONORM"."GEONORM_DTT_201208"
( "CODICEFISCALE" VARCHAR2(50),
"PROV_RESIDENZA" VARCHAR2(2),
"COMUNE_RESIDENZA" VARCHAR2(22),
"CAP_RESIDENZA" VARCHAR2(5),
"INDIRIZZO" VARCHAR2(34),
"NUMERO_CIVICO" VARCHAR2(4000)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
TABLE_NAME CNT
------------------ ----------
GEONORM_DTT_201207 287564
CREATE TABLE "GEONORM"."GEONORM_DTT_201207"
( "CODICEFISCALE" VARCHAR2(50),
"PROV_RESIDENZA" VARCHAR2(2),
"COMUNE_RESIDENZA" VARCHAR2(22),
"CAP_RESIDENZA" VARCHAR2(5),
"INDIRIZZO" VARCHAR2(34),
"NUMERO_CIVICO" VARCHAR2(4000)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
TABLE_NAME CNT
------------------ ----------
GEONORM_DTT_201208 194314
CREATE TABLE "GEONORM"."GEONORM_DTT_201208"
( "CODICEFISCALE" VARCHAR2(50),
"PROV_RESIDENZA" VARCHAR2(2),
"COMUNE_RESIDENZA" VARCHAR2(22),
"CAP_RESIDENZA" VARCHAR2(5),
"INDIRIZZO" VARCHAR2(34),
"NUMERO_CIVICO" VARCHAR2(4000)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
TABLE_NAME CNT
------------------ ----------
GEONORM_DTT_201209 783957
CREATE TABLE "GEONORM"."GEONORM_DTT_201209"
( "CODICEFISCALE" VARCHAR2(50),
"PROV_RESIDENZA" VARCHAR2(2),
"COMUNE_RESIDENZA" VARCHAR2(22),
"CAP_RESIDENZA" VARCHAR2(5),
"INDIRIZZO" VARCHAR2(34),
"NUMERO_CIVICO" VARCHAR2(4000)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
TABLE_NAME CNT
----------------- ----------
GEONORM_TA_201206 331986
CREATE TABLE "GEONORM"."GEONORM_TA_201206"
( "CODICEFISCALE" VARCHAR2(50),
"PROVINCIATA" VARCHAR2(255) NOT NULL ENABLE,
"COMUNETA" VARCHAR2(255) NOT NULL ENABLE,
"FRAZIONETA" VARCHAR2(255),
"CAPTA" VARCHAR2(50) NOT NULL ENABLE,
"INCIRIZZOTA" VARCHAR2(300),
"NUMEROCIVICOTA" VARCHAR2(50)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
TABLE_NAME CNT
----------------- ----------
GEONORM_TA_201207 287564
CREATE TABLE "GEONORM"."GEONORM_TA_201207"
( "CODICEFISCALE" VARCHAR2(50),
"PROVINCIATA" VARCHAR2(255) NOT NULL ENABLE,
"COMUNETA" VARCHAR2(255) NOT NULL ENABLE,
"FRAZIONETA" VARCHAR2(255),
"CAPTA" VARCHAR2(50) NOT NULL ENABLE,
"INCIRIZZOTA" VARCHAR2(300),
"NUMEROCIVICOTA" VARCHAR2(50)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
TABLE_NAME CNT
----------------- ----------
GEONORM_TA_201208 194314
CREATE TABLE "GEONORM"."GEONORM_TA_201208"
( "CODICEFISCALE" VARCHAR2(50),
"PROVINCIATA" VARCHAR2(255) NOT NULL ENABLE,
"COMUNETA" VARCHAR2(255) NOT NULL ENABLE,
"FRAZIONETA" VARCHAR2(255),
"CAPTA" VARCHAR2(50) NOT NULL ENABLE,
"INCIRIZZOTA" VARCHAR2(300),
"NUMEROCIVICOTA" VARCHAR2(50)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
TABLE_NAME CNT
----------------- ----------
GEONORM_TA_201209 783957
CREATE TABLE "GEONORM"."GEONORM_TA_201209"
( "CODICEFISCALE" VARCHAR2(50),
"PROVINCIATA" VARCHAR2(255) NOT NULL ENABLE,
"COMUNETA" VARCHAR2(255) NOT NULL ENABLE,
"FRAZIONETA" VARCHAR2(255),
"CAPTA" VARCHAR2(50) NOT NULL ENABLE,
"INCIRIZZOTA" VARCHAR2(300),
"NUMEROCIVICOTA" VARCHAR2(50)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
TABLE_NAME CNT
---------------------- ----------
GEONORM_DTT_201205_GEO 852425
CREATE TABLE "GEONORM"."GEONORM_DTT_201205_GEO"
( "OBJECTID" VARCHAR2(20),
"PGAX" BINARY_DOUBLE,
"PGAY" BINARY_DOUBLE,
"PGRX" BINARY_DOUBLE,
"PGRY" BINARY_DOUBLE,
"PUTX" BINARY_DOUBLE,
"PUTY" BINARY_DOUBLE,
"QUALITA" VARCHAR2(20),
"PROV_RESIDENZA" VARCHAR2(2),
"COMUNE_RESIDENZA" VARCHAR2(255),
"INDIRIZZO" VARCHAR2(255),
"NUMERO_CIVICO" VARCHAR2(255),
"CDXMATCOD" VARCHAR2(255),
"DSXCNY" VARCHAR2(255),
"DSXREG" VARCHAR2(255),
"DSXCNL" VARCHAR2(255),
"DSXDS1" VARCHAR2(255),
"DSXDUG" VARCHAR2(255),
"DSXVIA" VARCHAR2(255),
"NRPNUMCIV" VARCHAR2(20),
"DSXESP" VARCHAR2(255),
"CDXZIP" VARCHAR2(5),
"CDXISTAT" VARCHAR2(11),
"SGN_LOC" VARCHAR2(20),
"SGN_STR" VARCHAR2(20),
"SGN_MCZ" VARCHAR2(20),
"CODICEFISCALE" VARCHAR2(50),
"CAP_RESIDENZA" VARCHAR2(5)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
TABLE_NAME CNT
---------------------- ----------
GEONORM_DTT_201207_GEO 287390
CREATE TABLE "GEONORM"."GEONORM_DTT_201207_GEO"
( "FID" VARCHAR2(20),
"PGAX" BINARY_DOUBLE,
"PGAY" BINARY_DOUBLE,
"PGRX" BINARY_DOUBLE,
"PGRY" BINARY_DOUBLE,
"PUTX" BINARY_DOUBLE,
"PUTY" BINARY_DOUBLE,
"QUALITA" VARCHAR2(20),
"PROV_RESIDENZA" VARCHAR2(2),
"COMUNE_RESIDENZA" VARCHAR2(255),
"INDIRIZZO" VARCHAR2(255),
"NUMERO_CIVICO" VARCHAR2(255),
"CDXMATCOD" VARCHAR2(255),
"DSXCNY" VARCHAR2(255),
"DSXREG" VARCHAR2(255),
"DSXCNL" VARCHAR2(255),
"DSXDS1" VARCHAR2(255),
"DSXDUG" VARCHAR2(255),
"DSXVIA" VARCHAR2(255),
"NRPNUMCIV" VARCHAR2(20),
"DSXESP" VARCHAR2(255),
"CDXZIP" VARCHAR2(5),
"CDXISTAT" VARCHAR2(11),
"SGN_LOC" VARCHAR2(20),
"SGN_STR" VARCHAR2(20),
"SGN_MCZ" VARCHAR2(20),
"CODICEFISCALE" VARCHAR2(50),
"CAP_RESIDENZA" VARCHAR2(5)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
TABLE_NAME CNT
---------------------- ----------
GEONORM_DTT_201208_GEO 192767
CREATE TABLE "GEONORM"."GEONORM_DTT_201208_GEO"
( "FID" VARCHAR2(20),
"PGAX" BINARY_DOUBLE,
"PGAY" BINARY_DOUBLE,
"PGRX" BINARY_DOUBLE,
"PGRY" BINARY_DOUBLE,
"PUTX" BINARY_DOUBLE,
"PUTY" BINARY_DOUBLE,
"QUALITA" VARCHAR2(20),
"PROV_RESIDENZA" VARCHAR2(2),
"COMUNE_RESIDENZA" VARCHAR2(255),
"INDIRIZZO" VARCHAR2(255),
"NUMERO_CIVICO" VARCHAR2(255),
"DSXCNY" VARCHAR2(255),
"DSXREG" VARCHAR2(255),
"DSXCNL" VARCHAR2(255),
"DSXDS1" VARCHAR2(255),
"DSXDUG" VARCHAR2(255),
"DSXVIA" VARCHAR2(255),
"NRPNUMCIV" VARCHAR2(20),
"DSXESP" VARCHAR2(255),
"CDXZIP" VARCHAR2(5),
"CDXISTAT" VARCHAR2(11),
"SGN_LOC" VARCHAR2(20),
"SGN_STR" VARCHAR2(20),
"SGN_MCZ" VARCHAR2(20),
"CODICEFISCALE" VARCHAR2(50),
"CAP_RESIDENZA" VARCHAR2(5)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
TABLE_NAME CNT
---------------------- ----------
GEONORM_DTT_201209_GEO 777893
CREATE TABLE "GEONORM"."GEONORM_DTT_201209_GEO"
( "OBJECTID" VARCHAR2(20),
"PGAX" BINARY_DOUBLE,
"PGAY" BINARY_DOUBLE,
"PGRX" BINARY_DOUBLE,
"PGRY" BINARY_DOUBLE,
"PUTX" BINARY_DOUBLE,
"PUTY" BINARY_DOUBLE,
"QUALITA" VARCHAR2(20),
"PROV_RESIDENZA" VARCHAR2(2),
"COMUNE_RESIDENZA" VARCHAR2(255),
"INDIRIZZO" VARCHAR2(255),
"NUMERO_CIVICO" VARCHAR2(255),
"CDXMATCOD" VARCHAR2(255),
"DSXCNY" VARCHAR2(255),
"DSXREG" VARCHAR2(255),
"DSXCNL" VARCHAR2(255),
"DSXDS1" VARCHAR2(255),
"DSXDUG" VARCHAR2(255),
"DSXVIA" VARCHAR2(255),
"NRPNUMCIV" VARCHAR2(20),
"DSXESP" VARCHAR2(255),
"CDXZIP" VARCHAR2(5),
"CDXISTAT" VARCHAR2(11),
"SGN_LOC" VARCHAR2(20),
"SGN_STR" VARCHAR2(20),
"SGN_MCZ" VARCHAR2(20),
"CODICEFISCALE" VARCHAR2(50),
"CAP_RESIDENZA" VARCHAR2(5)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
TABLE_NAME CNT
--------------------- ----------
GEONORM_TA_201205_GEO 852037
CREATE TABLE "GEONORM"."GEONORM_TA_201205_GEO"
( "OBJECTID" VARCHAR2(20),
"PGAX" BINARY_DOUBLE,
"PGAY" BINARY_DOUBLE,
"PGRX" BINARY_DOUBLE,
"PGRY" BINARY_DOUBLE,
"PUTX" BINARY_DOUBLE,
"PUTY" BINARY_DOUBLE,
"QUALITA" VARCHAR2(20),
"PROVINCIATA" VARCHAR2(2),
"COMUNETA" VARCHAR2(255),
"INCIRIZZOTA" VARCHAR2(255),
"NUMEROCIVICOTA" VARCHAR2(255),
"CDXMATCOD" VARCHAR2(255),
"DSXCNY" VARCHAR2(255),
"DSXREG" VARCHAR2(255),
"DSXCNL" VARCHAR2(255),
"DSXDS1" VARCHAR2(255),
"DSXDUG" VARCHAR2(255),
"DSXVIA" VARCHAR2(255),
"NRPNUMCIV" VARCHAR2(20),
"DSXESP" VARCHAR2(255),
"CDXZIP" VARCHAR2(5),
"CDXISTAT" VARCHAR2(11),
"SGN_LOC" VARCHAR2(20),
"SGN_STR" VARCHAR2(20),
"SGN_MCZ" VARCHAR2(20),
"CODICEFISCALE" VARCHAR2(50),
"FRAZIONETA" VARCHAR2(255),
"CAPTA" VARCHAR2(50)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
TABLE_NAME CNT
--------------------- ----------
GEONORM_TA_201207_GEO 287293
CREATE TABLE "GEONORM"."GEONORM_TA_201207_GEO"
( "FID" VARCHAR2(20),
"PGAX" BINARY_DOUBLE,
"PGAY" BINARY_DOUBLE,
"PGRX" BINARY_DOUBLE,
"PGRY" BINARY_DOUBLE,
"PUTX" BINARY_DOUBLE,
"PUTY" BINARY_DOUBLE,
"QUALITA" VARCHAR2(20),
"PROVINCIATA" VARCHAR2(2),
"COMUNETA" VARCHAR2(255),
"INCIRIZZOTA" VARCHAR2(255),
"NUMEROCIVICOTA" VARCHAR2(255),
"CDXMATCOD" VARCHAR2(255),
"DSXCNY" VARCHAR2(255),
"DSXREG" VARCHAR2(255),
"DSXCNL" VARCHAR2(255),
"DSXDS1" VARCHAR2(255),
"DSXDUG" VARCHAR2(255),
"DSXVIA" VARCHAR2(255),
"NRPNUMCIV" VARCHAR2(20),
"DSXESP" VARCHAR2(255),
"CDXZIP" VARCHAR2(5),
"CDXISTAT" VARCHAR2(11),
"SGN_LOC" VARCHAR2(20),
"SGN_STR" VARCHAR2(20),
"SGN_MCZ" VARCHAR2(20),
"CODICEFISCALE" VARCHAR2(50),
"FRAZIONETA" VARCHAR2(255),
"CAPTA" VARCHAR2(50)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
TABLE_NAME CNT
--------------------- ----------
GEONORM_TA_201208_GEO 192416
CREATE TABLE "GEONORM"."GEONORM_TA_201208_GEO"
( "FID" VARCHAR2(20),
"PGAX" BINARY_DOUBLE,
"PGAY" BINARY_DOUBLE,
"PGRX" BINARY_DOUBLE,
"PGRY" BINARY_DOUBLE,
"PUTX" BINARY_DOUBLE,
"PUTY" BINARY_DOUBLE,
"QUALITA" VARCHAR2(20),
"PROVINCIATA" VARCHAR2(2),
"COMUNETA" VARCHAR2(255),
"INCIRIZZOTA" VARCHAR2(255),
"NUMEROCIVICOTA" VARCHAR2(255),
"DSXCNY" VARCHAR2(255),
"DSXREG" VARCHAR2(255),
"DSXCNL" VARCHAR2(255),
"DSXDS1" VARCHAR2(255),
"DSXDUG" VARCHAR2(255),
"DSXVIA" VARCHAR2(255),
"NRPNUMCIV" VARCHAR2(20),
"DSXESP" VARCHAR2(255),
"CDXZIP" VARCHAR2(5),
"CDXISTAT" VARCHAR2(11),
"SGN_LOC" VARCHAR2(20),
"SGN_STR" VARCHAR2(20),
"SGN_MCZ" VARCHAR2(20),
"CODICEFISCALE" VARCHAR2(50),
"FRAZIONETA" VARCHAR2(255),
"CAPTA" VARCHAR2(50)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"
TABLE_NAME CNT
--------------------- ----------
GEONORM_TA_201209_GEO 776655
CREATE TABLE "GEONORM"."GEONORM_TA_201209_GEO"
( "OBJECTID" VARCHAR2(20),
"PGAX" BINARY_DOUBLE,
"PGAY" BINARY_DOUBLE,
"PGRX" BINARY_DOUBLE,
"PGRY" BINARY_DOUBLE,
"PUTX" BINARY_DOUBLE,
"PUTY" BINARY_DOUBLE,
"QUALITA" VARCHAR2(20),
"PROVINCIATA" VARCHAR2(2),
"COMUNETA" VARCHAR2(255),
"INCIRIZZOTA" VARCHAR2(255),
"NUMEROCIVICOTA" VARCHAR2(255),
"CDXMATCOD" VARCHAR2(255),
"DSXCNY" VARCHAR2(255),
"DSXREG" VARCHAR2(255),
"DSXCNL" VARCHAR2(255),
"DSXDS1" VARCHAR2(255),
"DSXDUG" VARCHAR2(255),
"DSXVIA" VARCHAR2(255),
"NRPNUMCIV" VARCHAR2(20),
"DSXESP" VARCHAR2(255),
"CDXZIP" VARCHAR2(5),
"CDXISTAT" VARCHAR2(11),
"SGN_LOC" VARCHAR2(20),
"SGN_STR" VARCHAR2(20),
"SGN_MCZ" VARCHAR2(20),
"CODICEFISCALE" VARCHAR2(50),
"FRAZIONETA" VARCHAR2(255),
"CAPTA" VARCHAR2(50)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS"