EXPORT:V10.02.01 UMLS RUSERS 2048 0 20 0  Wed Feb 2 12:41:47 2011mls_new.dmpd`$     #G###A#d`$     #G###A#+00:00BYTEUNUSED2 INTERPRETED DISABLE:ALL METRICSU METRICSUpre-schema procedural objects and actions PROCACTION BEGIN sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'XE', inst_scn=>'12258563'); COMMIT; END; METRICEU 11 METRICSUforeign function library names for user METRICEU 11 METRICSUPUBLIC type synonyms METRICEU 11 METRICSUprivate type synonyms METRICEU 11 METRICSUobject type definitions for user METRICEU 11 METRICSUpre-schema procedural objects and actions METRICEU 11 METRICSUdatabase links METRICEU 11 METRICSUsequence numbers CREATE SEQUENCE "PS_TXN_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 50 START WITH 14101 CACHE 20 NOORDER NOCYCLE METRICEU 12 METRICSUcluster definitions METRICEU 12 METRICSUXDB Schemas by user METRICEU 12 TABLE "CITIES" CREATE TABLE "CITIES" ("CITY" VARCHAR2(20) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS INSERT INTO "CITIES" ("CITY") VALUES (:1) Belmont Burlingame Foster City Redwood City CREATE UNIQUE INDEX "CITIES_PK" ON "CITIES" ("CITY" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ANALSTATS IS "CITIES" ZBEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"CITIES_PK"',NULL,NULL,NULL,4,1,4,1,1,1,0,6); END; ALTER TABLE "CITIES" ADD CONSTRAINT "CITIES_PK" PRIMARY KEY ("CITY") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE ANALSTATS TS "CITIES" PBEGIN DBMS_STATS.SET_TABLE_STATS(NULL,'"CITIES"',NULL,NULL,NULL,4,1,11,6); END; ANALSTATS TS "CITIES" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '42656C6D6F6E74'; SREC.MAXVAL := '526564776F6F642043697479'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I344748706543397000000000000000000000,427824825549509000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1p); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"CITIES"','"CITY"', NULL ,NULL,NULL,4,.25,0,srec,11,6); END; TABLE "HOUSES" CREATE TABLE "HOUSES" ("ID" NUMBER(5, 0) NOT NULL ENABLE, "ZIP" NUMBER(5, 0), "CITY" VARCHAR2(30), "STREET" VARCHAR2(50), "PRICE" NUMBER(9, 0), "ROOMS" NUMBER(3, 0), "SF" NUMBER(5, 0), "AGE" VARCHAR2(3), "SHORTTEXT" VARCHAR2(1000), "BATHS" NUMBER, "PICTURE" VARCHAR2(120), "LONGITUDE" NUMBER, "LATITUDE" NUMBER, "AGENT_PHONE" VARCHAR2(15), "AGENT_EMAIL" VARCHAR2(30), "FIRST_OFFERED" DATE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS INSERT INTO "HOUSES" ("ID", "ZIP", "CITY", "STREET", "PRICE", "ROOMS", "SF", "AGE", "SHORTTEXT", "BATHS", "PICTURE", "LONGITUDE", "LATITUDE", "AGENT_PHONE", "AGENT_EMAIL", "FIRST_OFFERED") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16) 2x > )> Redwood City3808 VINEYARD DRdQ 40_DON'T MISS THIS EXCELLENT INVESTMENT OPPORTUNITY.GREAT NEIGHBORHOOD. WALK TO COMMERCIAL CENTERShouseimg/b0061.jpg=dOL8M)f&.5V) 650-506-5000Larry@oracle.comxl ? )> Redwood City 175 POPLAR AVR340UNIQUE AND GREAT INVESTMENT PROPERTY. WOW! PRICE INCLUDES 1 HOUSE WITH 3 BEDROOM/2 BATHS AND 7 UNIT APARTMENT BUILDING WITH 2 BEDROOM/1BATH EACH UNIT. FULLY RENTED. CLOSE TO ALL COMMERCIAL ESTABLISHMENTShouseimg/b0062.jpg=dOOA )f&0/A 650-506-5000Larry@oracle.comxl @ )> Redwood City1050 CONNECTICUT DRQ40westside locationhouseimg/b0063.jpg=dOME0f&/(BH 650-506-5000Larry@oracle.comxl A )> Redwood City515 WOODSIDE RDQ40UNIQUE AND GREAT INVESTMENT PROPERTY. WOW! PRICE INCLUDES 1 HOUSE WITH 3 BEDROOM/2 BATHS AND 7 UNIT APARTMENT BUILDING WITH 2 BEDROOM/1BATH EACH UNIT. FULLY RENTED. CLOSE TO ALL COMMERCIAL ESTABLISHMENTShouseimg/b0064.jpg=dOOD=f&0= 650-506-5000Larry@oracle.comxl B )> Redwood City1418 ALAMEDA DE LAS PULGASQ 340great rental area-all offers subject to interior inspections contingency-owner will carry 1st mortgage-all units have garages-rent increase potential-use chicago title (ruthe smith)houseimg/b0065.jpg=dOM^cf&.SX 650-506-5000Larry@oracle.comxl C )> Redwood City415 RUTHERFORD AV[40CHECK OUT THE NEW PRICE $1houseimg/b0066.jpg=dOOXMGf&./ 650-506-5000Larry@oracle.comxl D )> Redwood City 325 NIMITZ AVQ340Beautiful home in very desirable neighborhood. 5BR 3BA N 1BR 1BA downstairs. Formal entry with hardwood floors throughout. High ceiling in living room. Crown moldinghouseimg/b0067.jpg=dOOQ[f&.C1: 650-506-5000Larry@oracle.comxl E - Foster City100 FLYING CLOUD IS40dFabulous WIDE Water Location! This home has been extensively remodeled. Gourmet Kitchen with SubZerohouseimg/b0068.jpg=dOK4)f&94[ 650-506-5000Larry@oracle.comxl F - Foster City231 STAYSAIL CTO40SPECTACULAR LUXURY CONDO WITH PANORAMIC WATER VIEWS! THIS MARVELOUS PROPERTY HAS A MULTITUDE OF AMENITIES FROM THE LUXURIOUS CARPETING TO THE CUSTOM CROWN MOULDING THRUOUT. THE DREAM KITCHEN INCLUDES QUALITY CHERRY CABINETShouseimg/b0069.jpg=dOL[f&8'c 650-506-5000Larry@oracle.comxl G - Foster City211 FORESAIL CT340NEW PRICE!! STUNNING HOME IN HIGHLY DESIRED NEIGHBORHOOD DRAMATIC VAULTED CEILINGS UPDATED EAT IN KITCHEN FORMAL DINING- SUNDRENCHEDhouseimg/b0070.jpg=dOK[f&8&M 650-506-5000Larry@oracle.comxl H - Foster City1032 FLYING FISH STLQ40ZAttention To Detail.5/3 2 Levels.Built'67.2540 Sq.Ft.1/1 1st Level.Gourmet Kitchen w/Break.Area.10x10 Formal DR. Fam. Rm.w/Gas Log Frplc.LR w/Bay Window.Recessed Lighting Thru-Out.Hdwd.Floors Thru-Out 1st Level.Inside Lndry.Rm.2 Car Gar.20x18.Beautiful Beach Entry Pool w/Oversized Spa.Professionally Appointed Landscapping.In 8 Yrs. Approx. $322houseimg/b0071.jpg=dOL0f&9  650-506-5000Larry@oracle.comxl I - Foster City602 PORTSMOUTH LN408Waterfront property 2340 sq ft lot 8122 sq ft. 4 bedroomhouseimg/b0072.jpg=dOK 03f&7 W 650-506-5000Larry@oracle.comxl J - Foster City109 BEACH PARK BLW340Popular Grant IV model on one of Foster City's best streets! This spacious home features 5 bedrooms and 2.5 remodeled baths. Ideal family home with family roomhouseimg/b0073.jpg=dOJ >f&7]8 650-506-5000Larry@oracle.comxl K - Foster City710 SOMERSET LN40CFANTASTIC WIDE WATER LOCATION UPDATED KITCHEN WITH GRANITE COUNTERShouseimg/b0074.jpg=dOKRGf&7A 650-506-5000Larry@oracle.comxl L - Foster City704 SAN MIGUEL LNc40-4BR/3BA, Lovely garden, great school near by.houseimg/b0075.jpg=dOKb%f&7$ 650-506-5000Larry@oracle.comxl M - Foster City127 FLYING MIST IS 40Large 2 story home with 4 bedrooms and 3 full baths. One bedroom and full bath on ground floor level. Large eating area in kitchen. Also adjacent family room with fireplace and wet bar. Master suite has separate dressing areas.houseimg/b0076.jpg=dOL=f&9B# 650-506-5000Larry@oracle.comxl N - Foster City740 PROMONTORY POINT LN #330340Beautifully updated & remodeled plan with one bedroom/one bath downstairs.Carpeting upstairs & plantation window coverings throughout.Kitchen beautifully redonehouseimg/b0077.jpg=dOIB f&8 650-506-5000Larry@oracle.comxl O - Foster City1128 BLYTHE STO40gGorgeous corner-lot home. $175K upgrades & remodeling. Walking to Brewer Island elementary.4beds/3bathshouseimg/b0078.jpg=dOK6f&7: 650-506-5000Larry@oracle.comxl P - Foster City1320 SWORDFISH ST40CFANTASTIC WIDE WATER LOCATION UPDATED KITCHEN WITH GRANITE COUNTERShouseimg/b0079.jpg=dOLZ =f&8NbB 650-506-5000Larry@oracle.comxl Q - Foster City852 ARCTURUS CIc3404BR/3BAhouseimg/b0080.jpg=dOJ'Y=f&7H 650-506-5000Larry@oracle.comxl R - Foster City112 BARKENTINE ST40New price!! Beautiful waterfront property in quiet location. Remodeled gourmet kitchen with granite counter tops & new cabinets. Hardwood flooring thru most of 1st level. Boat can be docked at waters edge.houseimg/b0081.jpg=dOKeFQf&808 650-506-5000Larry@oracle.comxl S - Foster City 1194 ESSEX LNK40"Granite counters Granite fireplacehouseimg/b0082.jpg=dOK1*f&7+ 650-506-5000Larry@oracle.comxl T )> Redwood City 450 VERA AVL40,Beautiful Mediterranean style craftsman homehouseimg/b0083.jpg=dON`c=f&0RV 650-506-5000Larry@oracle.comxl U )> Redwood City630 CASTLE HILL RDQ40WThis lower Farm Hill Estates home on a quiet cul de sac has amazing Bay Views!! Vaulted ceilings in living rm & family rm; kitchen & breakfast nook open to family rm; huge master suite; generous sized bedrooms; updated baths; newer stainless steel appliances; fabulous lot w/ private patios & grassy play area; laundry rm & storage/wine cellarhouseimg/b0084.jpg=dOLF53f&/)< 650-506-5000Larry@oracle.comxl V )> Redwood City 1440 HESS RD40REDUCED! Spacious 5 Bedroomhouseimg/b0085.jpg=dOO+Hf&0J 650-506-5000Larry@oracle.comxl W )> Redwood City 6 GOODWIN CTQ40REDUCED! Spacious 5 Bedroomhouseimg/b0086.jpg=dOM-=f&.;`Q 650-506-5000Larry@oracle.comxl X )@ Redwood City2040 EL PRADO STQ40HUGE PRICE DROPPED $ 138houseimg/b0087.jpg=dOOGf&-G08 650-506-5000Larry@oracle.comxl Y )> Redwood City3749 FARM HILL BLQ40,Beautiful Mediterranean style craftsman homehouseimg/b0088.jpg=dOLc f&.?%P 650-506-5000Larry@oracle.comxl Z )> Redwood City1541 MADDUX DRQ40_DON'T MISS THIS EXCELLENT INVESTMENT OPPORTUNITY.GREAT NEIGHBORHOOD. WALK TO COMMERCIAL CENTERShouseimg/b0089.jpg=dON# f&.Q: 650-506-5000Larry@oracle.comxl [ )> Redwood City678 EMERALD HILL RD340REDUCED! Spacious 5 Bedroomhouseimg/b0090.jpg=dOL&f&.Sd 650-506-5000Larry@oracle.comxl \ )> Redwood City 925 ROUND HILL RDO340WThis lower Farm Hill Estates home on a quiet cul de sac has amazing Bay Views!! Vaulted ceilings in living rm & family rm; kitchen & breakfast nook open to family rm; huge master suite; generous sized bedrooms; updated baths; newer stainless steel appliances; fabulous lot w/ private patios & grassy play area; laundry rm & storage/wine cellarhouseimg/b0091.jpg=dOL:f&.N4? 650-506-5000Larry@oracle.comxl ] )> Redwood City373 BERESFORD AVQ40WThis lower Farm Hill Estates home on a quiet cul de sac has amazing Bay Views!! Vaulted ceilings in living rm & family rm; kitchen & breakfast nook open to family rm; huge master suite; generous sized bedrooms; updated baths; newer stainless steel appliances; fabulous lot w/ private patios & grassy play area; laundry rm & storage/wine cellarhouseimg/b0092.jpg=dOOD[f&.%> 650-506-5000Larry@oracle.comxl ^ )> Redwood City1455 GORDON STQ40Spacious 5 Bedroomhouseimg/b0093.jpg=dOO &/N` 650-506-5000Larry@oracle.comxl _ )> Redwood City 620 VERA AVQ40HUGE PRICE DROPPED $ 138houseimg/b0094.jpg=dONM5Gf&0C Z 650-506-5000Larry@oracle.comxl ` )> Redwood City541 MADISON AVQ40Gorgeous hm in the Sterling Heights neighborhood near Farm Hill Estates rebuilt 6 years ago. This home is the perfect blend of elegancehouseimg/b0095.jpg=dONKb3f&0Q&M 650-506-5000Larry@oracle.comxl a )> Redwood City322 SANTA CLARA AVQ40iA truly special home located on one of the most desirable streets in the sought after Farm Hills Estates of Redwood City. Completely renovated with quality and a new sophisticated chef's kitchen with top tier appliances. Attractive floor plan with all four bedrooms conveniently located on the same level. A quiet setting with spectacular bay and mountain viewshouseimg/b0096.jpg=dOO) f&. B+ 650-506-5000Larry@oracle.comxl b )> Redwood City 912 OAK AV*40Main House 3BDhouseimg/b0097.jpg=dONZ)f&0^J 650-506-5000Larry@oracle.comxl c )> Redwood City439 SANTA CLARA AVL=40Built new in 2001houseimg/b0098.jpg=dOO;!3f&-baD 650-506-5000Larry@oracle.comxl d )> Redwood City250 ALEXANDER AVQ40^Excellent Redwood City location!!; Great 4-plex; all 1 bedroom 1 bathroom units; Newer roof; stamped concrete driveways; patios & walkways; all new landscape work; unit #916 has been completely remodeled with new granite counter tops in kitchen; new stainless steel appliances; tiled floors; new bath; new paint w/ old world plaster; crown moldings; houseimg/b0099.jpg=dOO@f&.F( 650-506-5000Larry@oracle.comxl  CREATE UNIQUE INDEX "HOUSES_PK" ON "HOUSES" ("ID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ANALSTATS IS "HOUSES" \BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"HOUSES_PK"',NULL,NULL,NULL,40,1,40,1,1,2,0,6); END; ALTER TABLE "HOUSES" ADD CONSTRAINT "HOUSES_PK" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE ANALSTATS TS "HOUSES" RBEGIN DBMS_STATS.SET_TABLE_STATS(NULL,'"HOUSES"',NULL,NULL,NULL,40,2,256,6); END; ANALSTATS TS "HOUSES" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C13E'; SREC.MAXVAL := 'C202'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(61,100&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1o); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"HOUSES"','"ID"', NULL ,NULL,NULL,40,.025,0,srec,3,6); END; ANALSTATS TS "HOUSES" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C30A293E'; SREC.MAXVAL := 'C30A2D05'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY( 94061,94404&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1{); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"HOUSES"','"ZIP"', NULL ,NULL,NULL,3,.333333333333333,0,srec,5,6); END; ANALSTATS TS "HOUSES" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '466F737465722043697479'; SREC.MAXVAL := '526564776F6F642043697479'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I365721274825034000000000000000000000,427824825549509000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(15,40r); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"HOUSES"','"CITY"', NULL ,NULL,NULL,2,.0125,0,srec,13,6); END; ANALSTATS TS "HOUSES" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '2020092031373520504F504C4152204156'; SREC.MAXVAL := '393132204F414B204156'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I166803259596912000000000000000000000,296958730414524000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1t); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"HOUSES"','"STREET"', NULL ,NULL,NULL,40,.025,0,srec,18,6); END; ANALSTATS TS "HOUSES" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C32A'; SREC.MAXVAL := 'C4021E5B'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY({410000,740000,750000,756000,758000,780000,785000,800000,865000,980000,985000,998003,1100000,1200000,1240000,1275000,1299000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(+1,2,3,4,5,7,8,24,25,27,28,29,30,37,38,39,40t); SREC.EPC := 17; DBMS_STATS.SET_COLUMN_STATS(NULL,'"HOUSES"','"PRICE"', NULL ,NULL,NULL,17,.0125,0,srec,4,6); END; ANALSTATS TS "HOUSES" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C102'; SREC.MAXVAL := 'C107'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY( 1,2,3,4,5,6&); SREC.BKVALS := DBMS_STATS.NUMARRAY(1,7,28,35,38,40r); SREC.EPC := 6; DBMS_STATS.SET_COLUMN_STATS(NULL,'"HOUSES"','"ROOMS"', NULL ,NULL,NULL,6,.0125,0,srec,3,6); END; ANALSTATS TS "HOUSES" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C20D'; SREC.MAXVAL := 'C21A'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY( 1200,2500&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1}); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"HOUSES"','"SF"', NULL ,NULL,NULL,11,.0909090909090909,29,srec,2,6); END; ANALSTATS TS "HOUSES" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '3430'; SREC.MAXVAL := '3430'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I270972992304786000000000000000000000,270972992304786000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1l); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"HOUSES"','"AGE"', NULL ,NULL,NULL,1,1,0,srec,3,6); END; ANALSTATS TS "HOUSES" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '3442522F334241'; SREC.MAXVAL := '7765737473696465206C6F636174696F6E'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I271344586994742000000000000000000000,619940996814088000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"HOUSES"','"SHORTTEXT"', NULL ,NULL,NULL,31,.032258064516129,0,srec,133,6); END; ANALSTATS TS "HOUSES" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C102'; SREC.MAXVAL := 'C104'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(1,3&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1}); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"HOUSES"','"BATHS"', NULL ,NULL,NULL,3,.333333333333333,0,srec,3,6); END; ANALSTATS TS "HOUSES" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '686F757365696D672F6230303130302E6A7067'; SREC.MAXVAL := '686F757365696D672F62303039392E6A7067'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I542259526162017000000000000000000000,542259526162017000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1u); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"HOUSES"','"PICTURE"', NULL ,NULL,NULL,40,.025,0,srec,20,6); END; ANALSTATS TS "HOUSES" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '3D644F49420C0B66'; SREC.MAXVAL := '3D644F4F584D4766'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(-122.2835899,-122.2213243&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1v); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"HOUSES"','"LONGITUDE"', NULL ,NULL,NULL,40,.025,0,srec,9,6); END; ANALSTATS TS "HOUSES" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C1262D473038'; SREC.MAXVAL := 'C12639345B'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(37.44704755,37.56519&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1u); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"HOUSES"','"LATITUDE"', NULL ,NULL,NULL,40,.025,0,srec,7,6); END; ANALSTATS TS "HOUSES" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '3635302D3530362D35303030'; SREC.MAXVAL := '3635302D3530362D35303030'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I281462815012801000000000000000000000,281462815012801000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1u); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"HOUSES"','"AGENT_PHONE"', NULL ,NULL,NULL,1,1,0,srec,13,6); END; ANALSTATS TS "HOUSES" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4C61727279406F7261636C652E636F6D'; SREC.MAXVAL := '4C61727279406F7261636C652E636F6D'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I396591022418603000000000000000000000,396591022418603000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1u); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"HOUSES"','"AGENT_EMAIL"', NULL ,NULL,NULL,1,1,0,srec,17,6); END; ANALSTATS TS "HOUSES" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '786C080C010101'; SREC.MAXVAL := '786C0A0C010101'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(2454691,2454752&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"HOUSES"','"FIRST_OFFERED"', NULL ,NULL,NULL,3,.333333333333333,0,srec,8,6); END; TABLE "PASTSALES" CREATE TABLE "PASTSALES" ("PERIOD" DATE NOT NULL ENABLE, "AVG_PRICE" NUMBER, "TOTAL_SALES" NUMBER, "MEDIAN_PRICE" NUMBER) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS INSERT INTO "PASTSALES" ("PERIOD", "AVG_PRICE", "TOTAL_SALES", "MEDIAN_PRICE") VALUES (:1, :2, :3, :4)  xl IMxlBQGxl=GExlLLxlII CREATE UNIQUE INDEX "PASTSALES_PK" ON "PASTSALES" ("PERIOD" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ANALSTATS IS "PASTSALES" ]BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PASTSALES_PK"',NULL,NULL,NULL,5,1,5,1,1,1,0,6); END; ALTER TABLE "PASTSALES" ADD CONSTRAINT "PASTSALES_PK" PRIMARY KEY ("PERIOD") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE ANALSTATS TS "PASTSALES" SBEGIN DBMS_STATS.SET_TABLE_STATS(NULL,'"PASTSALES"',NULL,NULL,NULL,5,1,17,6); END; ANALSTATS TS "PASTSALES" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '786C0513010101'; SREC.MAXVAL := '786C0913010101'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(2454606,2454729&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1s); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"PASTSALES"','"PERIOD"', NULL ,NULL,NULL,5,.2,0,srec,8,6); END; ANALSTATS TS "PASTSALES" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C33D'; SREC.MAXVAL := 'C34C'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY( 600000,750000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1w); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"PASTSALES"','"AVG_PRICE"', NULL ,NULL,NULL,4,.25,0,srec,3,6); END; ANALSTATS TS "PASTSALES" }DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C147'; SREC.MAXVAL := 'C2021F'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(70,130&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1x); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"PASTSALES"','"TOTAL_SALES"', NULL ,NULL,NULL,5,.2,0,srec,4,6); END; ANALSTATS TS "PASTSALES" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C345'; SREC.MAXVAL := 'C34D'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY( 680000,760000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1y); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"PASTSALES"','"MEDIAN_PRICE"', NULL ,NULL,NULL,5,.2,0,srec,3,6); END; TABLE "PICTURES" CREATE TABLE "PICTURES" ("HOUSE_ID" NUMBER(6, 0), "IMAGE" VARCHAR2(30), "IMAGE_ID" NUMBER(4, 0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS INSERT INTO "PICTURES" ("HOUSE_ID", "IMAGE", "IMAGE_ID") VALUES (:1, :2, :3) >/intimages/1.jpg ?/intimages/9.jpg@/intimages/10.jpg A/intimages/11.jpg*B/intimages/1.jpg4C/intimages/1.jpg>D/intimages/1.jpgHE/intimages/1.jpgRF/intimages/1.jpg\G/intimages/1.jpgH/intimages/1.jpg I/intimages/1.jpgJ/intimages/1.jpg K/intimages/1.jpg*L/intimages/1.jpg4M/intimages/1.jpg>N/intimages/1.jpgHO/intimages/1.jpgRP/intimages/1.jpg\Q/intimages/1.jpg R/intimages/1.jpg S/intimages/1.jpg T/intimages/1.jpg U/intimages/1.jpg *V/intimages/1.jpg 4W/intimages/1.jpg >X/intimages/1.jpg HY/intimages/1.jpg RZ/intimages/1.jpg \[/intimages/1.jpg \/intimages/1.jpg ]/intimages/1.jpg ^/intimages/1.jpg _/intimages/1.jpg *`/intimages/1.jpg 4a/intimages/1.jpg >b/intimages/1.jpg Hc/intimages/1.jpg Rd/intimages/1.jpg \>/intimages/9.jpg ?/intimages/2.jpg@/intimages/13.jpg!A/intimages/12.jpg+B/intimages/2.jpg5C/intimages/2.jpg?D/intimages/2.jpgIE/intimages/2.jpgSF/intimages/2.jpg]G/intimages/2.jpgH/intimages/2.jpg I/intimages/2.jpgJ/intimages/2.jpg!K/intimages/2.jpg+L/intimages/2.jpg5M/intimages/2.jpg?N/intimages/2.jpgIO/intimages/2.jpgSP/intimages/2.jpg]Q/intimages/2.jpg R/intimages/2.jpg S/intimages/2.jpg T/intimages/2.jpg !U/intimages/2.jpg +V/intimages/2.jpg 5W/intimages/2.jpg ?X/intimages/2.jpg IY/intimages/2.jpg SZ/intimages/2.jpg ][/intimages/2.jpg \/intimages/2.jpg ]/intimages/2.jpg ^/intimages/2.jpg !_/intimages/2.jpg +`/intimages/2.jpg 5a/intimages/2.jpg ?b/intimages/2.jpg Ic/intimages/2.jpg Sd/intimages/2.jpg ]>/intimages/13.jpg?/intimages/3.jpg@/intimages/14.jpg"A/intimages/15.jpg,B/intimages/11.jpg6C/intimages/3.jpg@D/intimages/3.jpgJE/intimages/3.jpgTF/intimages/3.jpg^G/intimages/3.jpgH/intimages/3.jpgI/intimages/3.jpgJ/intimages/3.jpg"K/intimages/3.jpg,L/intimages/3.jpg6M/intimages/3.jpg@N/intimages/3.jpgJO/intimages/3.jpgTP/intimages/3.jpg^Q/intimages/3.jpg R/intimages/3.jpg S/intimages/3.jpg T/intimages/3.jpg "U/intimages/3.jpg ,V/intimages/3.jpg 6W/intimages/3.jpg @X/intimages/3.jpg JY/intimages/3.jpg TZ/intimages/3.jpg ^[/intimages/3.jpg \/intimages/3.jpg ]/intimages/3.jpg ^/intimages/3.jpg "_/intimages/3.jpg ,`/intimages/3.jpg 6a/intimages/3.jpg @b/intimages/3.jpg Jc/intimages/3.jpg Td/intimages/3.jpg ^>/intimages/4.jpg?/intimages/4.jpg@/intimages/4.jpg#A/intimages/4.jpg-B/intimages/4.jpg7C/intimages/4.jpgAD/intimages/4.jpgKE/intimages/4.jpgUF/intimages/4.jpg_G/intimages/4.jpgH/intimages/4.jpgI/intimages/4.jpgJ/intimages/4.jpg#K/intimages/4.jpg-L/intimages/4.jpg7M/intimages/4.jpgAN/intimages/4.jpgKO/intimages/4.jpgUP/intimages/4.jpg_Q/intimages/4.jpg R/intimages/4.jpg S/intimages/4.jpg T/intimages/4.jpg #U/intimages/4.jpg -V/intimages/4.jpg 7W/intimages/4.jpg AX/intimages/4.jpg KY/intimages/4.jpg UZ/intimages/4.jpg _[/intimages/4.jpg \/intimages/4.jpg ]/intimages/4.jpg ^/intimages/4.jpg #_/intimages/4.jpg -`/intimages/4.jpg 7a/intimages/4.jpg Ab/intimages/4.jpg Kc/intimages/4.jpg Ud/intimages/4.jpg _>/intimages/5.jpg?/intimages/5.jpg@/intimages/5.jpg$A/intimages/5.jpg.B/intimages/5.jpg8C/intimages/5.jpgBD/intimages/5.jpgLE/intimages/5.jpgVF/intimages/5.jpg`G/intimages/5.jpgH/intimages/5.jpgI/intimages/5.jpgJ/intimages/5.jpg$K/intimages/5.jpg.L/intimages/5.jpg8M/intimages/5.jpgBN/intimages/5.jpgLO/intimages/5.jpgVP/intimages/5.jpg`Q/intimages/5.jpg R/intimages/5.jpg S/intimages/5.jpg T/intimages/5.jpg $U/intimages/5.jpg .V/intimages/5.jpg 8W/intimages/5.jpg BX/intimages/5.jpg LY/intimages/5.jpg VZ/intimages/5.jpg `[/intimages/5.jpg \/intimages/5.jpg ]/intimages/5.jpg ^/intimages/5.jpg $_/intimages/5.jpg .`/intimages/5.jpg 8a/intimages/5.jpg Bb/intimages/5.jpg Lc/intimages/5.jpg Vd/intimages/5.jpg `>/intimages/6.jpg?/intimages/6.jpg@/intimages/6.jpg%A/intimages/6.jpg/B/intimages/6.jpg9C/intimages/6.jpgCD/intimages/6.jpgME/intimages/6.jpgWF/intimages/6.jpgaG/intimages/6.jpgH/intimages/6.jpgI/intimages/6.jpgJ/intimages/6.jpg%K/intimages/6.jpg/L/intimages/6.jpg9M/intimages/6.jpgCN/intimages/6.jpgMO/intimages/6.jpgWP/intimages/6.jpgaQ/intimages/6.jpg R/intimages/6.jpg S/intimages/6.jpg T/intimages/6.jpg %U/intimages/6.jpg /V/intimages/6.jpg 9W/intimages/6.jpg CX/intimages/6.jpg MY/intimages/6.jpg WZ/intimages/6.jpg a[/intimages/6.jpg \/intimages/6.jpg ]/intimages/6.jpg ^/intimages/6.jpg %_/intimages/6.jpg /`/intimages/6.jpg 9a/intimages/6.jpg Cb/intimages/6.jpg Mc/intimages/6.jpg Wd/intimages/6.jpg a>/intimages/7.jpg?/intimages/7.jpg@/intimages/7.jpg&A/intimages/7.jpg0B/intimages/7.jpg:C/intimages/7.jpgDD/intimages/7.jpgNE/intimages/7.jpgXF/intimages/7.jpgbG/intimages/7.jpgH/intimages/7.jpgI/intimages/7.jpgJ/intimages/7.jpg&K/intimages/7.jpg0L/intimages/7.jpg:M/intimages/7.jpgDN/intimages/7.jpgNO/intimages/7.jpgXP/intimages/7.jpgbQ/intimages/7.jpg R/intimages/7.jpg S/intimages/7.jpg T/intimages/7.jpg &U/intimages/7.jpg 0V/intimages/7.jpg :W/intimages/7.jpg DX/intimages/7.jpg NY/intimages/7.jpg XZ/intimages/7.jpg b[/intimages/7.jpg \/intimages/7.jpg ]/intimages/7.jpg ^/intimages/7.jpg &_/intimages/7.jpg 0`/intimages/7.jpg :a/intimages/7.jpg Db/intimages/7.jpg Nc/intimages/7.jpg Xd/intimages/7.jpg b>/intimages/8.jpg?/intimages/8.jpg@/intimages/8.jpg'A/intimages/8.jpg1B/intimages/8.jpg;C/intimages/8.jpgED/intimages/8.jpgOE/intimages/8.jpgYF/intimages/8.jpgcG/intimages/8.jpg H/intimages/8.jpgI/intimages/8.jpgJ/intimages/8.jpg'K/intimages/8.jpg1L/intimages/8.jpg;M/intimages/8.jpgEN/intimages/8.jpgOO/intimages/8.jpgYP/intimages/8.jpgcQ/intimages/8.jpg R/intimages/8.jpg S/intimages/8.jpg T/intimages/8.jpg 'U/intimages/8.jpg 1V/intimages/8.jpg ;W/intimages/8.jpg EX/intimages/8.jpg OY/intimages/8.jpg YZ/intimages/8.jpg c[/intimages/8.jpg \/intimages/8.jpg ]/intimages/8.jpg ^/intimages/8.jpg '_/intimages/8.jpg 1`/intimages/8.jpg ;a/intimages/8.jpg Eb/intimages/8.jpg Oc/intimages/8.jpg Yd/intimages/8.jpg c CREATE UNIQUE INDEX "PICTURES_PK" ON "PICTURES" ("IMAGE_ID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING ANALSTATS IS "PICTURES" aBEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PICTURES_PK"',NULL,NULL,NULL,320,1,320,1,1,80,0,6); END; ALTER TABLE "PICTURES" ADD CONSTRAINT "PICTURES_PK" PRIMARY KEY ("IMAGE_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING ENABLE ANALSTATS TS "PICTURES" TBEGIN DBMS_STATS.SET_TABLE_STATS(NULL,'"PICTURES"',NULL,NULL,NULL,320,5,24,6); END; ANALSTATS TS "PICTURES" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C13E'; SREC.MAXVAL := 'C202'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(x61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100&); SREC.BKVALS := DBMS_STATS.NUMARRAY(8,16,24,32,40,48,56,64,72,80,88,96,104,112,120,128,136,144,152,160,168,176,184,192,200,208,216,224,232,240,248,256,264,272,280,288,296,304,312,320|); SREC.EPC := 40; DBMS_STATS.SET_COLUMN_STATS(NULL,'"PICTURES"','"HOUSE_ID"', NULL ,NULL,NULL,40,.0015625,0,srec,3,6); END; ANALSTATS TS "PICTURES" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '2F696E74696D616765732F312E6A7067'; SREC.MAXVAL := '2F696E74696D616765732F382E6A7067'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I246176356485112000000000000000000000,246176356485112000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1t); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"PICTURES"','"IMAGE"', NULL ,NULL,NULL,8,.125,0,srec,17,6); END; ANALSTATS TS "PICTURES" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C2070C'; SREC.MAXVAL := 'C20B09'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(611,1008&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1{); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"PICTURES"','"IMAGE_ID"', NULL ,NULL,NULL,320,.003125,0,srec,4,6); END; TABLE "PS_TXN" CREATE TABLE "PS_TXN" ("ID" NUMBER(20, 0), "PARENTID" NUMBER(20, 0), "COLLID" NUMBER(10, 0), "CONTENT" BLOB, "CREATION_DATE" DATE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS LOB ("CONTENT") STORE AS (TABLESPACE "SYSTEM" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 CACHE STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) ALTER TABLE "PS_TXN" MODIFY DEFAULT =ALTER TABLE "PS_TXN" MODIFY ("CREATION_DATE" DEFAULT sysdate) INSERT INTO "PS_TXN" ("ID", "PARENTID", "COLLID", "CONTENT", "CREATION_DATE") VALUES (:1, :2, :3, :4, :5) q CONTENT>df-+ 55sr$orac 5@  sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz 3808 VINEYARD DR 450 VERA AV 998000 750000 1200 ""DON'T MISS THIS EXCELLENT INVESTMENT OPPORTUNITY.GREAT NEIGHBORHOOD. WALK TO COMMERCIAL CENTERS ""Beautiful Mediterranean style craftsman home xxl "sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz 3808 VINEYARD DR 450 VERA AV 998000 750000 1200 ""DON'T MISS THIS EXCELLENT INVESTMENT OPPORTUNITY.GREAT NEIGHBORHOOD. WALK TO COMMERCIAL CENTERS ""Beautiful Mediterranean style craftsman home x>df 4 55sr$orac 5@ h Xsr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz xxl Xsr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz x>dfjh 55@sr$orac 5@ @xm <0sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz

z z

x>df+jh 55@sr$orac 5@ &@xn &#&sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpzc-122.255-122.254524637.45537.4552854REDUCED! Spacious 5 <font color="#3BAC0E">Bedroom</font>REDUCED! Spacious 5 Bedroom-122.256-122.256371837.45837.458299092010-04-152008-08-12&quot;&quot;Beautifully updated &amp; remodeled plan with one bedroom/one bath downstairs.Carpetzing upstairs &amp; plantation window coverings throughout.Kitchen beautifully redone""Beautifully updated & remodeled plan with one bedroom/one bath downstairs.Carpeting upstairs & plantation window coverings throughout.Kitchen beautifully redone-122.221-122.221324337.45537.45461714-122.224-122.223688637.47537.47461664

x>df54jh 55@sr$orac 5@ @xn :sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpzDON'T MISS THIS <font color="#0BAF9E">EXCELLENT </font>INVESTMENT OPPORTUNITY.GREAT NEIGHBORHOOD. WALK TO COMMERCIAL CENTERSDON'T MISS THIS EXCELLENT INVESTMENT OPPORTUNITY.GREAT NEIGHBORHOOD. WALK TO COMMERCIAL CENTERS-122.255-122.254524637.45537.45528542010-04-072008-09-12&quot;&quot;UNIQUE AND GREAT INVESTMENT PROPERTY. WOW! PRICE INCLUDES 1 HOUSE WITH 3 BEDROOM/2 BATHS AND 7 UNIT APARTMENT BUILDING WITH 2 BEDROOM/1BATH EACH UNIT. FULLY RENTED. CLOSE TO ALL COMMERCIAL ESTABLISHMENTS""UNIQUE AND GREAT INVESTMENT PROPERTY. WOW! PRICE INCLUDES 1 HOUSE WITH 3 BEDROOM/2 BATHS AND 7 UNIT APARTMENT BUILDING WITH 2 BEDROOM/1BATH EACH UNIT. FULLY RENTED. CLOSE TO ALL COMMERCIAL ESTABLISHMENTS-122.224-122.223688637.47537.47461664&quot;&quot;westside location""westside location-122.243-122.243253737.46437.46396571

x>df@jh 55@sr$orac 5@ @xn 7,sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz%&quot;&quot;Granite counters Granite fireplace""Granite counters Granite fireplace&quot;&quot;NEW PRICE!! STUNNING HOME IN HIGHLY DESIRED NEIGHBORHOOD DRAMATIC VAULTED CEILINGS UPDATED EAT IN KITCHEN FORMAL DINING- SUNDRENCHED""NEW PRICE!! STUNNING HOME IN HIGHLY DESIRED NEIGHBORHOOD DRAMATIC VAULTED CEILINGS UPDATED EAT IN KITCHEN FORMAL DINING- SUNDRENCHEDNew price!! Beautiful waterfront property in quiet location. Remodeled gourmet kitchen with granite counter tops &amp; new cabinets. Hardwood floorizng thru most of 1st level. Boat can be docked at waters edge.New price!! Beautiful waterfront property in quiet location. Remodeled gourmet kitchen with granite counter tops & new cabinets. Hardwood flooring thru most of 1st level. Boat can be docked at waters edge.12341240000""Beautifully updated &amp; remodeled plan with <font color="#AF4F0B">one </font>bedroom/one bath downstairs.Carpeting upstairs &amp; plantation window coverings throughout.Kitchen beautifully redone""Beautifully updated & remodeled plan with one bedroom/one bath downstairs.Carpeting upstairs & plantation window coverings throughout.Kitchen beautifully redone2010-04-092008-09-12

x>dfJ4 55sr$orac 5@  sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz xxn #sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz x>dfK4 55sr$orac 5@  sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz&quot;&quot;Beautiful Mediterranean style craftsman home""Beautiful Mediterranean style craftsman home&quot;&quot;Granite counters Granite fireplace""Granite counters Granite fireplace&quot;&quot;4BR/3BA""4BR/3BA&quot;&quot;Beautifully updated &amp; remodeled plan with one bedroom/one bath downstairs.Carpeting upstairs &amp; pzlantation window coverings throughout.Kitchen beautifully redone""Beautifully updated & remodeled plan with one bedroom/one bath downstairs.Carpeting upstairs & plantation window coverings throughout.Kitchen beautifully redonexxn ;sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz&quot;&quot;Beautiful Mediterranean style craftsman home""Beautiful Mediterranean style craftsman home&quot;&quot;Granite counters Granite fireplace""Granite counters Granite fireplace&quot;&quot;4BR/3BA""4BR/3BA&quot;&quot;Beautifully updated &amp; remodeled plan with one bedroom/one bath downstairs.Carpeting upstairs &amp; pzlantation window coverings throughout.Kitchen beautifully redone""Beautifully updated & remodeled plan with one bedroom/one bath downstairs.Carpeting upstairs & plantation window coverings throughout.Kitchen beautifully redonex>df \Z 55sr$orac 5@  sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpzPDxxn'sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpzPDx>df 4 55sr$orac 5@  vsr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz

z z z xxn0vsr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz

z z z x>dfL4 55sr$orac 5@  sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpzBeautifully updated &amp; remodeled plan with one bedroom/one bath downstairs.Carpeting upstairs &amp; plantation window coverings throughout.Kitchen beautifully redoneBeautifully updated & remodeled plan with one bedroom/one bath downstairs.Carpeting upstairs & plantation window coverings throughout.Kitchen beautifully redoneBeautifully updated &amp; remodeled plan with one bedroom/one bath downstairs.Carpeting upstairs &amp; plantation window coverings throughout.Kitchen beautifully redonePopular Grant IV model on one of Foster City's best streets! This spacious home features 5 bedrooms and 2.5 remodeled baths. Ideal family home with famiwly roomxxn "sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpzBeautifully updated &amp; remodeled plan with one bedroom/one bath downstairs.Carpeting upstairs &amp; plantation window coverings throughout.Kitchen beautifully redoneBeautifully updated & remodeled plan with one bedroom/one bath downstairs.Carpeting upstairs & plantation window coverings throughout.Kitchen beautifully redoneBeautifully updated &amp; remodeled plan with one bedroom/one bath downstairs.Carpeting upstairs &amp; plantation window coverings throughout.Kitchen beautifully redonePopular Grant IV model on one of Foster City's best streets! This spacious home features 5 bedrooms and 2.5 remodeled baths. Ideal family home with famiwly roomx>dfW&$ 55sr$orac 5@  sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz

ACED0005770200000001FFFFFFFF1xxn ,;sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz

ACED0005770200000001FFFFFFFF1x>dfa4 55sr$orac 5@  sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz

xxn '7sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz

x>dfa5  55sr$orac 5@  sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz

xxn '7sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz

x>dfb4  55sr$orac 5@  sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz

xxn (sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz

x>df  55sr$orac 5@  sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpzxxn'sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpzx>df ! 55sr$orac 5@  sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz xxn sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz x>df4  W55sr$orac 5@  usr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz

zxxou sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz

zx>df  /}55sr$orac 5@  l \sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz

zxxo\ sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz

zx>df jh /55@sr$orac 5@ @xo*sr$oracle.jbo.server.DBSerializer$AMRowJ mPersistIdLthis$0t Loracle/jbo/server/DBSerializer;LxmlDoct"Loracle/xml/parser/v2/XMLDocument;xpz-122.255-122.254524637.45537.4552854-122.224-122.223688637.47537.47461664503000800000-122.223-122.2233437.4737.470268090008000z0090000800000-122.243-122.243253737.46437.46396571

zx CREATE UNIQUE INDEX "PS_TXN_PK" ON "PS_TXN" ("COLLID" , "ID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ANALSTATS IS "PS_TXN" \BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"PS_TXN_PK"',NULL,NULL,NULL,17,1,17,1,1,4,0,6); END; ALTER TABLE "PS_TXN" ADD CONSTRAINT "PS_TXN_PK" PRIMARY KEY ("COLLID", "ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ENABLE ANALSTATS TS "PS_TXN" RBEGIN DBMS_STATS.SET_TABLE_STATS(NULL,'"PS_TXN"',NULL,NULL,NULL,17,4,106,6); END; ANALSTATS TS "PS_TXN" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C102'; SREC.MAXVAL := 'C102'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(1&); SREC.BKVALS := DBMS_STATS.NUMARRAY(17{); SREC.EPC := 1; DBMS_STATS.SET_COLUMN_STATS(NULL,'"PS_TXN"','"ID"', NULL ,NULL,NULL,1,.0294117647058824,0,srec,3,6); END; ANALSTATS TS "PS_TXN" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '3E6466'; SREC.MAXVAL := '3E6466'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(-1,-1&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"PS_TXN"','"PARENTID"', NULL ,NULL,NULL,1,1,0,srec,4,6); END; ANALSTATS TS "PS_TXN" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C102'; SREC.MAXVAL := 'C3020A02'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(1,10901&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"PS_TXN"','"COLLID"', NULL ,NULL,NULL,17,.0588235294117647,0,srec,5,6); END; ANALSTATS TS "PS_TXN" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"PS_TXN"','"CONTENT"', NULL ,NULL,NULL,0,0,0,srec,87,6); END; ANALSTATS TS "PS_TXN" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '786C0A0A11221D'; SREC.MAXVAL := '786E070E120420'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(!2454750.68990741,2455392.71077546&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"PS_TXN"','"CREATION_DATE"', NULL ,NULL,NULL,15,.0666666666666667,0,srec,8,6); END; TABLE "TOURS" CREATE TABLE "TOURS" ("USERID" VARCHAR2(20), "HOUSE_ID" NUMBER, "WHEN" DATE, "EMAIL_ADDRESS" VARCHAR2(20), "TOUR_TYPE" VARCHAR2(20)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" LOGGING NOCOMPRESS INSERT INTO "TOURS" ("USERID", "HOUSE_ID", "WHEN", "EMAIL_ADDRESS", "TOUR_TYPE") VALUES (:1, :2, :3, :4, :5)  aMxma2aNxm a2aBxmmoo1 ANALSTATS TS "TOURS" OBEGIN DBMS_STATS.SET_TABLE_STATS(NULL,'"TOURS"',NULL,NULL,NULL,3,5,17,6); END; ANALSTATS TS "TOURS" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '61'; SREC.MAXVAL := '61'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I503652795277878000000000000000000000,503652795277878000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"TOURS"','"USERID"', NULL ,NULL,NULL,1,1,0,srec,2,6); END; ANALSTATS TS "TOURS" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C142'; SREC.MAXVAL := 'C14E'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(65,77&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"TOURS"','"HOUSE_ID"', NULL ,NULL,NULL,3,.333333333333333,0,srec,3,6); END; ANALSTATS TS "TOURS" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '786D0203010101'; SREC.MAXVAL := '786D020D010101'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(2454866,2454876&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1{); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"TOURS"','"WHEN"', NULL ,NULL,NULL,3,.333333333333333,0,srec,8,6); END; ANALSTATS TS "TOURS" {DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '61'; SREC.MAXVAL := '6D6F6F'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I503652795277878000000000000000000000,568220499372341000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1v); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"TOURS"','"EMAIL_ADDRESS"', NULL ,NULL,NULL,2,.5,0,srec,3,6); END; ANALSTATS TS "TOURS" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '31'; SREC.MAXVAL := '32'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I254422546068207000000000000000000000,259614842926741000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1r); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"TOURS"','"TOUR_TYPE"', NULL ,NULL,NULL,2,.5,0,srec,2,6); END; ENDTABLE METRICSUsynonyms METRICEU 3 METRICSUviews METRICEU 3 METRICSUstored procedures METRICEU 3 METRICSUoperators METRICEU 3 METRICSUAnalyze cluster statements METRICEU 3 METRICSUreferential integrity constraints TABLE "TOURS" ALTER TABLE "TOURS" ADD CONSTRAINT "TOURS_HOUSES_FK" FOREIGN KEY ("HOUSE_ID") REFERENCES "HOUSES" ("ID") ENABLE NOVALIDATE ENDTABLE TABLE "HOUSES" ALTER TABLE "HOUSES" ADD CONSTRAINT "HOUSES_CITIES_FK" FOREIGN KEY ("CITY") REFERENCES "CITIES" ("CITY") ENABLE NOVALIDATE ENDTABLE TABLE "PICTURES" ALTER TABLE "PICTURES" ADD CONSTRAINT "PICTURES_OF_HOUSES" FOREIGN KEY ("HOUSE_ID") REFERENCES "HOUSES" ("ID") ENABLE NOVALIDATE ENDTABLE METRICEU 6 METRICSUtriggers TABLE "HOUSES" CREATE FORMAT92TRIG TRIGGER "MLS"."HOUSES_ID_TRG" BEFORE INSERT ON HOUSES FOR EACH ROW BEGIN 7 SELECT HOUSES_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL; END; ALTER TRIGGER "HOUSES_ID_TRG" DISABLE ENDTABLE METRICEU 7 METRICSUindextypes METRICEU 7 METRICSUbitmap, functional and extensible indexes METRICEU 7 METRICSUposttables actions METRICEU 7 METRICSUmaterialized views METRICEU 7 METRICSUsnapshot logs METRICEU 7 METRICSUjob queues METRICEU 7 METRICSUrefresh groups and children METRICEU 7 METRICSUdimensions METRICEU 7 METRICSUPost-inst procedural actions METRICEU 7 METRICSUpost-schema procedural objects and actions METRICEU 18 METRICSUstatistics TABLE "CITIES" ANALCOMPUTE TS "CITIES" ANALYZE TABLE "CITIES" ESTIMATE STATISTICS TABLE "HOUSES" ANALCOMPUTE TS "HOUSES" ANALYZE TABLE "HOUSES" ESTIMATE STATISTICS TABLE "PASTSALES" ANALCOMPUTE TS "PASTSALES" ANALYZE TABLE "PASTSALES" ESTIMATE STATISTICS TABLE "PICTURES" ANALCOMPUTE TS "PICTURES" ANALYZE TABLE "PICTURES" ESTIMATE STATISTICS TABLE "PS_TXN" ANALCOMPUTE TS "PS_TXN" ANALYZE TABLE "PS_TXN" ESTIMATE STATISTICS TABLE "TOURS" ANALCOMPUTE TS "TOURS" ANALYZE TABLE "TOURS" ESTIMATE STATISTICS ENDTABLE METRICEU 24 METRICSUEnable enforce constraints TABLE "TOURS" ALTER TABLE "TOURS" ENABLE CONSTRAINT "TOURS_HOUSES_FK" ENDTABLE TABLE "HOUSES" ALTER TABLE "HOUSES" ENABLE CONSTRAINT "HOUSES_CITIES_FK" ENDTABLE TABLE "PICTURES" ALTER TABLE "PICTURES" ENABLE CONSTRAINT "PICTURES_OF_HOUSES" ENDTABLE METRICEU 27 METRICEUG0 EXIT EXIT