Toad World® Forums

TOAD OBJECT SEARCH

Hi,

I’m using Toad 12.6.0.53 and I’m trying to use Object Search to find a certain package.

I enter the table name in Search Term, select Occurs anywhere and Object status - Both.

I select all Schemas and select Search object names.

When this runs it selects all table names, not just the table name I’m searching for.

Is there something I have to specify in Options to get Object search working correctly.

Chris Halliday

Hi Chris,

To clarify, are you trying to locate a table name in a package?

Thanks,

John

John,

Sorry for the delay replying to your post.

It just seems whatever I search for I get thousands of matches returned.

For instance I tried to search for any table with ERR in the table name as follows -

 Search Term - ERR

 Occurs Anywhere

 Object Status - Both

 Select All Schemas

 Search Object Names and  Select - Tables

When I run the search I get 94,238 matches with names such as AE_AG, wheras I know there are only 46 tables with ERR in the name.

Chris Halliday

I don’t know why you’re getting more results than you expect.

From the main menu, click Database -> Spool SQL -> Spool to screen. That will show you the queries that Toad is running. If it looks like Toad is running a query that is different for what you are asking for with your search window options, post both the spool sql output and a screen shot of your search window, and I’ll take a look at it.

Thanks.

John,

Sql output as follows -


Session: BANINST1@BANNER-DEV2.ISS.SOTON.AC.UK

Timestamp: 16:51:21.905

Select owner, object_type,

CASE

WHEN INSTR (object_type, ‘PARTITION’) <> 0

THEN object_name

ELSE ‘’

END result_type,

CASE

WHEN INSTR (object_type, ‘PARTITION’) <> 0

THEN subobject_name

ELSE object_name

END object_name

FROM SYS.DBA_OBJECTS

WHERE UPPER(object_name) LIKE :olike ESCAPE ‘’

AND owner IN (‘BANINST1’,‘AA’,‘AA1’,‘AA13X07’,‘AA1A09’,‘AA1E10’,‘AA1S07’,‘AA1W07’,‘AA2’,‘AA2L06’,‘AA2Y07’,‘AA3’,‘AA3U09’,‘AA8’,‘AAA’,‘AAA1’,‘AAB’,‘AAB1A11’,‘AAC’,‘AAC2’,‘AAD1E09’,‘AAEG’,‘AAF1U08’,‘AAH’,‘AAI1N09’,‘AAJ’,‘AAL1’,‘AAL1U09’,‘AALONSO’,‘AAM’,‘AAO1C06’,‘AAR1N09’,‘AAR1S07’,‘AAT2C10’,‘AAW’,‘AB1’,‘AB100’,‘AB11’,‘AB12’,‘AB13’,‘AB14’,‘AB15’,‘AB15G11’,‘AB16’,‘AB16G10’,‘AB17’,‘AB18’,‘AB1B06’,‘AB1D09’,‘AB1D14’,‘AB1E06’,‘AB1E08’,‘AB1M08’,‘AB1U06’,‘AB20G14’,‘AB21G09’,‘AB2A09’,‘AB2C08’,‘AB2D08’,‘AB2D09’,‘AB2E08’,‘AB2F11’,‘AB2M09’,‘AB2R08’,‘AB2U06’,‘AB2U08’,‘AB3’,‘AB3M09’,‘AB3R09’,‘AB43G10’,‘AB4D09’,‘AB4E10’,‘AB5U08’,‘AB666’,‘AB7’,‘AB7C13’,‘AB7E09’,‘AB9’,‘AB9C08’,‘ABDS1Y08’,‘ABG1A08’,‘ABH’,‘ABH1U07’,‘ABICLARK’,‘ABM1R10’,‘ABP’,‘ABP1C09’,‘ABR1E08’,‘ABZ1E14’,‘AC’,‘AC1’,‘AC10’,‘AC11’,‘AC14G08’,‘AC15’,‘AC1A09’,‘AC1C08’,‘AC1D06’,‘AC1M08’,‘AC1M11’,‘AC1R10’,‘AC1U06’,‘AC1U07’,‘AC1U10’,‘AC1Y07’,‘AC1Y09’,‘AC20’,‘AC20G11’,‘AC21’,‘AC22’,‘AC2F06’,‘AC2O07’,‘AC2P07’,‘AC2R08’,‘AC3D13’,‘AC3R11’,‘AC3V09’,‘AC4’,‘AC4N08’,‘AC4T07’,‘AC5’,‘AC5A09’,‘AC5F13’,‘AC6A09’,‘AC72’,‘ACB’,‘ACB1C08’,‘ACB1E10’,‘ACC1C09’,‘ACC1L06’,‘ACC2’,‘ACCU99’,‘ACD’,‘ACE’,‘ACG1M13’,‘ACG2B06’,‘ACH’,‘ACH1’,‘ACH1E14’,‘ACH1P07’,‘ACHASE’,‘ACHORTI’,‘ACJ’,‘ACK1’,‘ACL1’,‘ACLC1N12’,‘ACLM’,‘ACN1G09’,‘ACNG’,‘ACOC’,‘ACP’,‘ACP1V11’,‘ACR1’,‘ACS’,‘ACS1C08’,‘ACS1M13’,‘ACS1N09’,‘ACT’,‘ACT1’,‘ACT1F06’,‘ACT1U07’,‘ACT2’,‘ACWJ’,‘AD1’,‘AD13’,‘AD19G10’,‘AD1C09’,‘AD1D09’,‘AD1F06’,‘AD1N09’,‘AD1O07’,‘AD1U08’,‘AD1U13’,‘AD1V09’,‘AD2A09’,‘AD2A10’,‘AD2D09’,‘AD2E06’,‘AD2N09’,‘AD3’,‘AD3M09’,‘AD4N09’,‘AD5’,‘AD7’,‘AD9’,‘ADA1Y13’,‘ADAM’,‘ADB’,‘ADB1Y11’,‘ADC1O07’,‘ADC1R12’,‘ADEL’,‘ADF’,‘ADFT’,‘ADH’,‘ADH1M12’,‘ADI’,‘ADI1M08’,‘ADICKENS’,‘ADIEBALL’,‘ADISDAT’,‘ADISPRD’,‘ADISUSR’,‘ADM1Q07’,‘ADM1V07’,‘ADM2’,‘ADM5’,‘ADN1’,‘ADOIG’,‘ADOLBY’,‘ADP’,‘ADP1V09’,‘ADR1D12’,‘ADS’,‘ADS1C09’,‘ADS1D08’,‘ADS2E08’,‘ADS5’,‘ADW2’,‘ADY’,‘AE’,‘AE1P07’,‘AE1V08’,‘AE3’,‘AE5’,‘AE6’,‘AEA’,‘AEA2’,‘AEB’,‘AEB1C13’,‘AEC’,‘AEC1’,‘AED1N09’,‘AEE1’,‘AEG’,‘AEG1Y09’,‘AEH1’,‘AEH1A08’,‘AEH1B06’,‘AEM2’,‘AEN’,‘AEP1E10’,‘AER1’,‘AER1F11’,‘AES1U09’,‘AES1W07’,‘AESK’,‘AF05V’,‘AF12V07’,‘AF1D06’,‘AF1F06’,‘AF1L06’,‘AF1T07’,‘AF1V09’,‘AF1V14’,‘AF2D06’,‘AF2E10’,‘AF2K06’,‘AF2Y09’,‘AF3C10’,‘AF5G08’,‘AFA1C13’,‘AFB’,‘AFB1’,‘AFH1V09’,‘AFM’,‘AFP1R09’,‘AFR103’,‘AFR2’,‘AFR2M11’,‘AFW’,‘AFW1’,‘AG1N09’,‘AG1O07’,‘AG1R08’,‘AG1R13’,‘AG1U09’,‘AG1V08’,‘AG2C08’,‘AG2M09’,‘AG2U08’,‘AG2Y09’,‘AG3’,‘AG3Y08’,‘AG4M09’,‘AG4U07’,‘AG6’,‘AG8E08’,‘AGA2G10’,‘AGB’,‘AGB1U13’,‘AGB3G10’,‘AGC’,‘AGC1’,‘AGD1N11’,‘AGL’,‘AGMAYERS’,‘AGN’,‘AGORA’,‘AGPS’,‘AGR’,‘AGS1N09’,‘AGW1C06’,‘AGW1E10’,‘AH’,‘AH10’,‘AH10E10’,‘AH11’,‘AH1A08’,‘AH1D09’,‘AH1D10’,‘AH1F06’,‘AH1U07’,‘AH1U08’,‘AH1V08’,‘AH2A09’,‘AH2D09’,‘AH2E08’,‘AH2F09’,‘AH2R11’,‘AH3B06’,‘AH4’,‘AH4E10’,‘AH5’,‘AH6’,‘AH7E09’,‘AH9’,‘AHC’,‘AHEALY’,‘AHES’,‘AHJ’,‘AHM’,‘AHMEDE’,‘AHP1Z07’,‘AHQ’,‘AHQ1C09’,‘AHUNT’,‘AI1M09’,‘AIB’,‘AIB1’,‘AIDEN’,‘AIGBS1’,‘AIJ’,‘AIJF197’,‘AIM2G09’,‘AIR’,‘AJ1’,‘AJ10G10’,‘AJ11G10’,‘AJ1D08’,‘AJ1R07’,‘AJ1S07’,‘AJ2’,‘AJA’,‘AJA1’,‘AJA1F09’,‘AJA1F13’,‘AJB1’,‘AJB1C09’,‘AJB1C11’,‘AJB1O07’,‘AJB1S07’,‘AJB1U07’,‘AJB1Y07’,‘AJB4G08’,‘AJB6’,‘AJBIRD’,‘AJC’,‘AJC1A08’,‘AJC1F11’,‘AJC1K06’,‘AJC1T07’,‘AJC3’,‘AJC4’,‘AJC6’,‘AJCK’,‘AJD1’,‘AJD1E11’,‘AJD1U08’,‘AJD3G09’,‘AJD4’,‘AJDW’,‘AJE1’,‘AJF1C09’,‘AJF1E13’,‘AJF1M09’,‘AJF1U10’,‘AJF2’,‘AJF3’,‘AJF4’,‘AJF5’,‘AJGH’,‘AJH1’,‘AJH3’,‘AJH9’,‘AJIT’,‘AJK’,‘AJK1’,‘AJK1E08’,‘AJK1S07’,‘AJK2’,‘AJK3G14’,‘AJL’,‘AJL1’,‘AJL2’,‘AJL2Y08’,‘AJM’,‘AJM1B06’,‘AJM1M11’,‘AJM2’,‘AJMOFFAT’,‘AJOD1B06’,‘AJP’,‘AJP1R07’,‘AJP1Y09’,‘AJP2E08’,‘AJP3’,‘AJP6’,‘AJPH’,‘AJRB1F13’,‘AJS’,‘AJS1’,‘AJS502’,‘AJS6’,‘AJS8’,‘AJT1’,‘AJT1C08’,‘AJT1D09’,‘AJT1M11’,‘AJU1Y12’,‘AJVA’,‘AJW’,‘AJW1’,‘AJW3’,‘AJW4’,‘AJW7’,‘AJY5’,‘AK’,‘AK1’,‘AK11’,‘AK1A09’,‘AK1A12’,‘AK1A13’,‘AK1E08’,‘AK1F09’,‘AK1V11’,‘AK1Y11’,‘AK1Y13’,‘AK2A09’,‘AK2E08’,‘AK2F10’,‘AK2R07’,‘AK3W07’,‘AK4’,‘AK5’,‘AK5X07’,‘AK7’,‘AKB1R09’,‘AKC’,‘AKC1’,‘AKC2’,‘AKG’,‘AKH1’,‘AKJ1Y08’,‘AKL1C09’,‘AKM’,‘AKM1R09’,‘AKP’,‘AKP1’,‘AKP2’,‘AKR1D09’,‘AKS1’,‘AKS1V09’,‘AKS2G09’,‘AKT1E09’,‘AL1’,‘AL10’,‘AL10G09’,‘AL1C08’,‘AL1E06’,‘AL1F06’,‘AL1Q07’,‘AL1R09’,‘AL1R11’,‘AL1V09’,‘AL1Y09’,‘AL2’,‘AL4’,‘AL6’,‘AL7’,‘AL9’,‘ALA’,‘ALB’,‘ALB2’,‘ALC’,‘ALC1’,‘ALC196’,‘ALC1U06’,‘ALD1R09’,‘ALEX’,‘ALEX8’,‘ALEXEY’,‘ALEXFURR’,‘ALEXMEN’,‘ALF’,‘ALF1R09’,‘ALG1’,‘ALG1F09’,‘ALG1W07’,‘ALH102’,‘ALH1A08’,‘ALH1X07’,‘ALH3’,‘ALI1’,‘ALIG’,‘ALISON’,‘ALISONMD’,‘ALIT’,‘ALIX’,‘ALJE’,‘ALK’,‘ALK1V12’,‘ALL1U08’,‘ALLENC’,‘ALLYDILW’,‘ALM1’,‘ALN1’,‘ALN1B06’,‘ALRIDDOC’,‘ALS’,‘ALS1’,‘ALSH’,‘ALT’,‘ALT1’,‘ALT2’,‘ALT3’,‘ALUMNI’,‘ALW’,‘ALW1E10’,‘ALW1R10’,‘ALW2’,‘ALYSOUN’,‘AM1’,‘AM10’,‘AM11’,‘AM12’,‘AM14’,‘AM15’,‘AM1A06’,‘AM1C06’,‘AM1D09’,‘AM1M09’,‘AM1N08’,‘AM1T07’,‘AM1U09’,‘AM2’,‘AM23G09’,‘AM24G09’,‘AM29V07’,‘AM2A08’,‘AM2A09’,‘AM2A11’,‘AM2C08’,‘AM2D09’,‘AM2E08’,‘AM2M11’,‘AM2N09’,‘AM2R10’,‘AM2U08’,‘AM2V10’,‘AM2X07’,‘AM2Y12’,‘AM3’,‘AM3C08’,‘AM3M09’,‘AM3R09’,‘AM3U10’,‘AM4’,‘AM43G09’,‘AM4V12’,‘AM4X07’,‘AM5M09’,‘AM6M09’,‘AM6T07’,‘AM7’,‘AM8’,‘AM9’,‘AMA1’,‘AMA2’,‘AMANDA’,‘AMANDER’,‘AMASON’,‘AMB’,‘AMB1’,‘AMB1V13’,‘AMB2’,‘AMB3G11’,‘AMB6’,‘AMC’,‘AMC1’,‘AMC1A08’,‘AMCA’,‘AMCB’,‘AMD’,‘AMD3’,‘AMF’,‘AMF1C11’,‘AMF1E10’,‘AMF1Z07’,‘AMG’,‘AMG1A12’,‘AMG3’,‘AMHD’,‘AMJ’,‘AMK1E10’,‘AMK1O07’,‘AML1E10’,‘AMM1’,‘AMM1M08’,‘AMM1V09’,‘AMM1V12’,‘AMM2M08’,‘AMM3’,‘AMM4’,‘AMM5’,‘AMN1’,‘AMN1O07’,‘AMN3’,‘AMNHEN’,‘AMO105’,‘AMP1D13’,‘AMPS’,‘AMR’,‘AMR2D09’,‘AMR3’,‘AMRAE’,‘AMRE’,‘AMRH1X07’,‘AMRIT’,‘AMS’,‘AMS05’,‘AMS1E09’,‘AMS3’,‘AMS7’,‘AMSF’,‘AMT1’,‘AMT100’,‘AMT4’,‘AMTM’,‘AMUL’,‘AMV2G13’,‘AMW1’,‘AMW1T07’,‘AMW1Y07’,‘AMW6’,‘AN’,‘AN1R09’,‘AN1U09’,‘AN1X07’,‘AN2A09’,‘AN2C08’,‘AN2E09’,‘AN3P07’,‘AN3U08’,‘AN7’,‘AN7G10’,‘ANA’,‘ANB’,‘ANB1’,‘ANC’,‘ANDRESA’,‘ANDREW’,‘ANDREWC’,‘ANDRIY’,‘ANDY’,‘ANDY1’,‘ANDY14’,‘ANDYBUSH’,‘ANG’,‘ANG1J06’,‘ANGELA’,‘ANGERS’,‘ANGI’,‘ANH’,‘ANILAKIN’,‘ANN’,‘ANNA’,‘ANNAM’,‘ANNEKEL’,‘ANONYMOUS’,‘ANP1C09’,‘ANS1E06’,‘ANW’,‘AO1’,‘AO1C08’,‘AOC1V07’,‘AP’,‘AP1’,‘AP16G10’,‘AP1D09’,‘AP1E06’,‘AP1F09’,‘AP1P07’,‘AP1S07’,‘AP1V09’,‘AP1W07’,‘AP1X07’,‘AP1Y09’,‘AP2’,‘AP26G10’,‘AP2B06’,‘AP2C06’,‘AP2D10’,‘AP2K06’,‘AP2R10’,‘AP2R11’,‘AP2X07’,‘AP3C08’,‘AP5’,‘AP6E12’,‘AP6G13’,‘AP7’,‘APA’,‘APA1’,‘APA1E10’,‘APAGE’,‘APB’,‘APB1’,‘APB100’,‘APB2’,‘APG’,‘APG1K06’,‘APH1’,‘APH1C09’,‘APH2’,‘APH3’,‘APJ’,‘APL’,‘APM3’,‘APMARTIN’,‘APN’,‘APN2’,‘APP1V07’,‘APPQOSSYS’,‘APR1C13’,‘APS’,‘APS1Y09’,‘APW’,‘APW1’,‘APW1A06’,‘APW2’,‘AR’,‘AR1C08’,‘AR1R08’,‘AR1V13’,‘AR1V14’,‘AR1Y07’,‘AR1Y08’,‘AR2’,‘AR2D09’,‘AR2E09’,‘AR2R07’,‘AR2Y08’,‘AR4’,‘AR4C09’,‘AR4K06’,‘AR4X07’,‘AR5’,‘AR5E10’,‘AR5ISS’,‘AR7’,‘AR97R’,‘ARAN1C09’,‘ARB’,‘ARB1’,‘ARB202’,‘ARBS1F09’,‘ARC’,‘ARC1’,‘ARC102’,‘ARC3’,‘ARC4G09’,‘ARDT’,‘ARE’,‘ARE1E11’,‘ARF1A09’,‘ARG’,‘ARG1V07’,‘ARG1Y12’,‘ARG2’,‘ARG4’,‘ARH1’,‘ARK’,‘ARK1’,‘ARKRAA’,‘ARM1E11’,‘ARM2E11’,‘ARMIN’,‘ARMSWTH’,‘ARN1’,‘ARNE’,‘ARNI’,‘ARP’,‘ARP1A10’,‘ARS1A06’,‘ARS1D09’,‘ART4’,‘ARWW’,‘AS10’,‘AS14V07’,‘AS15’,‘AS1D09’,‘AS1E09’,‘AS1G09’,‘AS1R09’,‘AS1R10’,‘AS1U09’,‘AS1U10’,‘AS1X07’,‘AS1Z07’,‘AS27G08’,‘AS2C10’,‘AS2E10’,‘AS2M10’,‘AS2U11’,‘AS38G12’,‘AS3R07’,‘AS3V09’,‘AS40G08’,‘AS45G13’,‘AS48G10’,‘AS49G10’,‘AS4C06’,‘AS4X07’,‘AS5’,‘AS5V12’,‘AS7’,‘AS7E08’,‘AS7V09’,‘AS8’,‘AS9’,‘ASA’,‘ASA1J06’,‘ASC2E10’,‘ASD1Y07’,‘ASD202’,‘ASDO$’,‘ASF1G08’,‘ASG’,‘ASHM2G08’,‘ASHWIN’,‘ASJ’,‘ASK1E09’,‘ASK2G08’,‘ASM1B06’,‘ASM3G10’,‘ASOPAS’,‘ASR1B06’,‘ASTEPHEN’,‘ASV’,‘ASV104’,‘ASV1A09’,‘ASV1M10’,‘ASW’,‘ASW1V07’,‘ASW1V08’,‘AT11G09’,‘AT1A09’,‘AT1D09’,‘AT1O07’,‘AT1T07’,‘AT1U06’,‘AT1Y09’,‘AT2’,‘AT2D09’,‘AT2M08’,‘AT2O07’,‘AT2R09’,‘AT3’,‘AT6G08’,‘ATAUSSIK’,‘ATB1Y07’,‘ATH1M09’,‘ATL1’,‘ATL1U09’,‘ATW1A06’,‘AV1’,‘AV1E09’,‘AV1W07’,‘AV1Y07’,‘AV2E08’,‘AV2F12’,‘AV2X07’,‘AV3’,‘AV4’,‘AVE1M13’,‘AVG1D09’,‘AVH’,‘AVH1F09’,‘AVL1D09’,‘AVM1D09’,‘AW’,‘AW1’,‘AW10E10’,‘AW10G11’,‘AW12’,‘AW13’,‘AW14’,‘AW17G09’,‘AW1A06’,‘AW1D06’,‘AW1F09’,‘AW1S07’,‘AW1V08’,‘AW2’,‘AW2A08’,‘AW2C08’,‘AW2E08’,‘AW3A08’,‘AW4’,‘AW4M09’,‘AW5’,‘AW5C09’,‘AW7’,‘AW8’,‘AW9’,‘AWB2’,‘AWEBB’,‘AWF’,‘AWF1D08’,‘AWG1D09’,‘AWG2D09’,‘AWP1Y11’,‘AWT2V07’,‘AWW’,‘AWW1’,‘AX1S07’,‘AXS96’,‘AXY’,‘AY1M09’,‘AYG’,‘AYMEN’,‘AZ’,‘AZ1N10’,‘AZ1Y11’,‘AZ2X07’,‘AZB’,‘AZD’,‘AZO’,‘AZP’,‘BA105’,‘BA1V13’,‘BAB’,‘BAB1’,‘BAC’,‘BAD’,‘BADC1’,‘BAF1K06’,‘BAG’,‘BAGGIEPR’,‘BAHAJ’,‘BAISAKHI’,‘BAJ1B06’,‘BAK2W07’,‘BAKG’,‘BALAVOIE’,‘BAM’,‘BAM1O07’,‘BAN_SS_USER’,‘BAN_UP_DOWNLOAD$’,‘BANADMIN’,‘BANIMGR’,‘BANNER_CMS’,‘BANPROXY’,‘BANSECR’,‘BANSECR_AC6R13’,‘BANSECR_ADMIN’,‘BANSECR_AKN1D11’,‘BANSECR_BAZ1B06’,‘BANSECR_CC6’,‘BANSECR_CH2R07’,‘BANSECR_CP1U10’,‘BANSECR_DB2V13’,‘BANSECR_DJWITTS’,‘BANSECR_DLG1Y11’,‘BANSECR_DPC’,‘BANSECR_EFN’,‘BANSECR_FML1’,‘BANSECR_GR1D13’,‘BANSECR_JDE1D12’,‘BANSECR_JEE1V11’,‘BANSECR_JJE1’,‘BANSECR_NLG1D13’,‘BANSECR_PAY1Y11’,‘BANSECR_PS1R11’,‘BANSECR_PSS’,‘BANSECR_RHIANNON’,‘BANSECR_SG4R10’,‘BANSECR_SKP1’,‘BANSECR_SUPPORT’) OR owner IN (‘BANSECR_TRAIN01’,‘BANSECR_TW’,‘BANSECR_TW3’,‘BANSECR_VT5G09’,‘BANSSO’,‘BART’,‘BARTJH’,‘BAS’,‘BAS3’,‘BASELINE’,‘BASHIR’,‘BASP’,‘BAT2’,‘BAZ1B06’,‘BAZ1F09’,‘BB’,‘BB1304’,‘BB1R09’,‘BB2E06’,‘BB2R09’,‘BB5’,‘BBA1Y07’,‘BBB’,‘BBLLOYD’,‘BBP’,‘BC’,‘BC1D11’,‘BC1F09’,‘BC1R07’,‘BC1U06’,‘BC2V09’,‘BC3’,‘BCB1Y13’,‘BCD1N09’,‘BCF’,‘BCI1A09’,‘BCO’,‘BCW’,‘BCW1R08’,‘BD’,‘BD1C09’,‘BD1F11’,‘BD2A08’,‘BD2E08’,‘BD6’,‘BDC1D08’,‘BDD’,‘BDD1N10’,‘BDM’,‘BDR’,‘BDW1X07’,‘BE1’,‘BEA’,‘BEALES’,‘BEANHEAD’,‘BEH’,‘BEH1X07’,‘BENB’,‘BENJUBY’,‘BESHR’,‘BF’,‘BF2P07’,‘BFB’,‘BFH’,‘BFL’,‘BFM1C09’,‘BFS’,‘BFS1V07’,‘BG’,‘BG1’,‘BG1A06’,‘BGDT1J06’,‘BGM’,‘BGN’,‘BGPH1C10’,‘BGS1N09’,‘BGW1M08’,‘BH1A09’,‘BH1E06’,‘BH1M09’,‘BH1M10’,‘BH1T07’,‘BH1V08’,‘BH2’,‘BH2C14’,‘BH2N08’,‘BH4’,‘BH6’,‘BHANDARI’,‘BHAVNA’,‘BHE’,‘BHEH’,‘BHMJ’,‘BHS1N10’,‘BI’,‘BI1B06’,‘BIGMAC’,‘BIM’,‘BIM1’,‘BIN1Y07’,‘BISCARI’,‘BIZTALK’,‘BJ1R07’,‘BJ1Y09’,‘BJA199’,‘BJB2’,‘BJC’,‘BJC2’,‘BJD1F08’,‘BJG1D06’,‘BJH’,‘BJH1Y13’,‘BJK1’,‘BJKL2V10’,‘BJL1Y12’,‘BJM’,‘BJM1’,‘BJMD’,‘BJN1V08’,‘BJO’,‘BJO2’,‘BJOD’,‘BJON’,‘BJT’,‘BJW2’,‘BJW3’,‘BK1’,‘BK1D09’,‘BK2’,‘BKSD’,‘BL1’,‘BL1E06’,‘BL1N09’,‘BL2’,‘BL3’,‘BL4’,‘BLEECK’,‘BLG1Y13’,‘BLN1’,‘BLS1’,‘BLUEDORN’,‘BLY’,‘BM’,‘BM1E09’,‘BM1M09’,‘BM1N09’,‘BM1Y07’,‘BM4’,‘BM6’,‘BM602’,‘BMAH’,‘BMARSH’,‘BMB1B06’,‘BMC’,‘BMG1V09’,‘BMGDS’,‘BMH’,‘BMM’,‘BMP’,‘BMR1A06’,‘BMS1N13’,‘BMT1Y07’,‘BMW’,‘BMW2’,‘BN1’,‘BN1L06’,‘BN4’,‘BNM1R08’,‘BO’,‘BO1C10’,‘BONEILL’,‘BP’,‘BP1’,‘BP1A06’,‘BP1D06’,‘BP1E06’,‘BP1F08’,‘BP1S07’,‘BP2S07’,‘BPB’,‘BPC1G09’,‘BPC1U08’,‘BPH’,‘BPISMGR’,‘BPISPRD’,‘BPISUSR’,‘BPN’,‘BPS’,‘BPW’,‘BPW4’,‘BR’,‘BR1P07’,‘BR1U09’,‘BR1X07’,‘BR2A06’,‘BR3’,‘BRAMSENG’,‘BRIGNELL’,‘BRILLAN’,‘BRINDLEY’,‘BRIONY’,‘BRM’,‘BRONWEN’,‘BS’,‘BS1’,‘BS1B06’,‘BS1C06’,‘BS1K06’,‘BS1Q07’,‘BS3’,‘BS3A06’,‘BS3E10’,‘BS7’,‘BS99’,‘BSG’,‘BSL’,‘BSS1P07’,‘BT’,‘BT1’,‘BT1C09’,‘BT1N08’,‘BT1O07’,‘BT1S07’,‘BT1U08’,‘BT4’,‘BTD1Y09’,‘BTHOMSON’,‘BTK’,‘BTL1C08’,‘BULL’,‘BURKE’,‘BV1C09’,‘BV1M09’,‘BVM1V12’,‘BVR1G12’,‘BW’,‘BW1E09’,‘BW3’,‘BW4’,‘BWGMGR’,‘BWL’,‘BWLMGR’,‘BWRMGR’,‘BWSMGR’,‘BX1C14’,‘BXD’,‘BYRNEMJ’,‘BZ1A06’,‘CA’,‘CA1’,‘CA1C09’,‘CA1M08’,‘CA4’,‘CAA’,‘CAA1M10’,‘CAB1’,‘CAB1Y’,‘CAB2’,‘CAB6’,‘CAC1R11’,‘CAC3’,‘CACM’,‘CAD’,‘CAE1F09’,‘CAE2E14’,‘CAG1’,‘CAG103’,‘CAG1G11’,‘CAH1’,‘CAH1B06’,‘CALF1Y08’,‘CALVO’,‘CAM2C08’,‘CAM30660’,‘CAP3’,‘CAPLA’,‘CAR1Y13’,‘CARGNELL’,‘CARINA’,‘CARY’,‘CAS2F09’,‘CAS3’,‘CASCADEU’,‘CAT1E08’,‘CAT2’,‘CAV’,‘CAV2’,‘CAVB’,‘CAW18’,‘CB’,‘CB10’,‘CB10E08’,‘CB11’,‘CB15’,‘CB19G10’,‘CB1F06’,‘CB1F08’,‘CB1F09’,‘CB1V09’,‘CB1Y11’,‘CB1Y12’,‘CB2C09’,‘CB2M09’,‘CB2N08’,‘CB2O07’,‘CB2Q07’,‘CB2U08’,‘CB3’,‘CB31G09’,‘CB34G08’,‘CB3C09’,‘CB3D08’,‘CB3Q07’,‘CB3T07’,‘CB3U08’,‘CB4A06’,‘CB4D13’,‘CB4E09’,‘CB4L06’,‘CB4M09’,‘CB4Q07’,‘CB5’,‘CB5F08’,‘CB6’,‘CB6F08’,‘CB6G10’,‘CB7’,‘CB7F08’,‘CB9’,‘CB9G09’,‘CBB’,‘CBC’,‘CBC1D06’,‘CBEG1’,‘CBERNDT’,‘CC’,‘CC10E09’,‘CC11’,‘CC15’,‘CC16’,‘CC1C06’,‘CC1C09’,‘CC1D09’,‘CC1R09’,‘CC1S07’,‘CC1V08’,‘CC1Y09’,‘CC2’,‘CC20G09’,‘CC2A09’,‘CC2D09’,‘CC2M09’,‘CC2R09’,‘CC2R11’,‘CC2V08’,‘CC3’,‘CC3R09’,‘CC3W07’,‘CC4X07’,‘CC5’,‘CCC’,‘CCH’,‘CCHAM’,‘CCJ1F13’,‘CCS1U09’,‘CCT’,‘CCT1M08’,‘CCURRIE’,‘CCW1’,‘CCW1M10’,‘CD1’,‘CD1D09’,‘CD1R09’,‘CD1S07’,‘CD2’,‘CD2C08’,‘CD2F06’,‘CD2R08’,‘CD2R09’,‘CD2U09’,‘CD6’,‘CD8’,‘CDA1W07’,‘CDB’,‘CDB1A06’,‘CDB1A08’,‘CDB1A13’,‘CDB1E10’,‘CDD1B06’,‘CDD1E11’,‘CDG1D08’,‘CDG1R08’,‘CDJ’,‘CDL1R09’,‘CDM’,‘CDM1G08’,‘CDM2N09’,‘CDOWNEY’,‘CDP’,‘CDS’,‘CDS1A09’,‘CDS1R09’,‘CDT1C13’,‘CDTB’,‘CDW3G08’,‘CE1D08’,‘CE2’,‘CE4G09’,‘CEB’,‘CEB1E09’,‘CEB2’,‘CEB2G09’,‘CEC’,‘CEC1’,‘CEC1A09’,‘CEC1Y10’,‘CECARR’,‘CECC’,‘CED1’,‘CED1U06’,‘CEDWARDS’,‘CEE’,‘CEF26’,‘CEG’,‘CEH’,‘CEI096’,‘CEJ1’,‘CEJ1G08’,‘CEK1R13’,‘CEK1V07’,‘CEL1G09’,‘CELIA’,‘CELT2’,‘CEM’,‘CEM1U09’,‘CEN1’,‘CEN1M13’,‘CEOS’,‘CEP1G09’,‘CER2V09’,‘CERIS’,‘CES’,‘CES1L06’,‘CET1V12’,‘CEU’,‘CEW1’,‘CF’,‘CF1K06’,‘CF1M13’,‘CF1R07’,‘CF1U08’,‘CF1X07’,‘CF1Y07’,‘CF3’,‘CF4’,‘CF4V07’,‘CF5E11’,‘CF5W07’,‘CFB1D13’,‘CFC’,‘CFCP’,‘CFF’,‘CFS’,‘CG’,‘CG1’,‘CG11’,‘CG1C09’,‘CG1O07’,‘CG1V09’,‘CG2’,‘CG204’,‘CG21G10’,‘CG2E08’,‘CG2M10’,‘CG3’,‘CG3C09’,‘CG3O07’,‘CG4’,‘CG6G11’,‘CG7’,‘CG9’,‘CGB101’,‘CGE’,‘CGH1Y07’,‘CGO1J06’,‘CGW1C13’,‘CH’,‘CH1’,‘CH10’,‘CH11’,‘CH12’,‘CH13’,‘CH14’,‘CH15’,‘CH17G09’,‘CH1A09’,‘CH1D06’,‘CH1J06’,‘CH1N09’,‘CH1O07’,‘CH1V08’,‘CH1W07’,‘CH1Y07’,‘CH1Y12’,‘CH2’,‘CH2C08’,‘CH2C09’,‘CH2R07’,‘CH2V08’,‘CH2Y09’,‘CH3’,‘CH31G10’,‘CH3G08’,‘CH3R07’,‘CH4’,‘CH4E11’,‘CH4R09’,‘CH5C09’,‘CH5T07’,‘CH8’,‘CH9’,‘CHA2’,‘CHADS39’,‘CHANGL’,‘CHARLIEG’,‘CHB’,‘CHCKIN01’,‘CHCKIN02’,‘CHCKIN03’,‘CHCKIN04’,‘CHCKIN05’,‘CHCKIN06’,‘CHCKIN07’,‘CHCKIN08’,‘CHCKIN09’,‘CHCKIN10’,‘CHCKIN11’,‘CHCKIN12’,‘CHCKIN13’,‘CHCKIN14’,‘CHCKIN15’,‘CHCKIN16’,‘CHCKIN17’,‘CHCKIN18’,‘CHCKIN19’,‘CHCKIN20’,‘CHCKIN21’,‘CHCKIN22’,‘CHCKIN23’,‘CHCKIN24’,‘CHCKIN25’,‘CHCKIN26’,‘CHCKIN27’,‘CHCKIN28’,‘CHCKIN29’,‘CHCKIN30’,‘CHCKIN31’,‘CHCKIN32’,‘CHCKIN33’,‘CHCKIN34’,‘CHCKIN35’,‘CHCKIN36’,‘CHCKIN37’,‘CHCKIN38’,‘CHCKIN39’,‘CHCKIN40’,‘CHCKIN41’,‘CHCKIN42’,‘CHCKIN43’,‘CHCKIN44’,‘CHCKIN45’,‘CHCKIN46’,‘CHCKIN47’,‘CHCKIN48’,‘CHCKIN49’,‘CHCKIN50’,‘CHCKIN51’,‘CHCKIN52’,‘CHCKIN53’,‘CHCKIN54’,‘CHCKIN55’,‘CHCKIN56’,‘CHCKIN57’,‘CHCKIN58’,‘CHCKIN59’,‘CHCKIN60’,‘CHDG’,‘CHE’,‘CHENGY’,‘CHF’,‘CHIKATE8’,‘CHJG’,‘CHL1’,‘CHL2’,‘CHO’,‘CHR’,‘CHRIS1’,‘CHRISG12’,‘CHRISP’,‘CHRISTEL’,‘CHRISTOS’,‘CHS1G14’,‘CHS2’,‘CHS2M08’,‘CHUNHUA’,‘CHW1F12’,‘CI’,‘CI1N09’,‘CIDS1G09’,‘CIG1W07’,‘CIM’,‘CIM1S07’,‘CIMSMGR’,‘CIMSPRD’,‘CIMSUSR’,‘CIPO’,‘CJ’,‘CJ1A09’,‘CJ1N09’,‘CJ1R11’,‘CJ2E09’,‘CJ2G13’,‘CJ5’,‘CJANAWAY’,‘CJB’,‘CJB1G09’,‘CJB1O07’,‘CJB1R10’,‘CJB1U08’,‘CJB40’,‘CJB5’,‘CJB6’,‘CJC1’,‘CJC1E12’,‘CJC1Y08’,‘CJC2’,‘CJC5V07’,‘CJCJ’,‘CJD1D10’,‘CJD1E09’,‘CJD1V08’,‘CJDS’,‘CJF1’,‘CJG’,‘CJG1’,‘CJG1D09’,‘CJG1O07’,‘CJG1U13’,‘CJG4’,‘CJH’,‘CJH1’,‘CJH2’,‘CJH2E06’,‘CJH7’,‘CJHG’,‘CJL1’,‘CJLG’,‘CJM’,‘CJM1D10’,‘CJM1F08’,‘CJM2’,‘CJM5G09’,‘CJO1R07’,‘CJP’,‘CJP1’,‘CJP1R10’,‘CJR1A08’,‘CJS’,‘CJS2V09’,‘CJS5’,‘CJSC’,‘CJT’,‘CJW’,‘CJW1A11’,‘CJW2’,‘CJWA’,‘CJWE1N09’,‘CK’,‘CK1’,‘CK1B06’,‘CK1F09’,‘CK1L06’,‘CK1N12’,‘CK2’,‘CK2C09’,‘CK2N09’,‘CK6’,‘CK6G08’,‘CK7’,‘CKB’,‘CKB1E09’,‘CKBC’,‘CKS’,‘CKS1A10’,‘CL’,‘CL1’,‘CL18G09’,‘CL1C12’,‘CL1F08’,‘CL1U08’,‘CL2O07’,‘CL2U07’,‘CL2V09’,‘CL5U13’,‘CL6M08’,‘CL6U07’,‘CL9U07’,‘CLA8’,‘CLAIRE’,‘CLAIRE1’,‘CLAIREB9’,‘CLARENCE’,‘CLB1A09’,‘CLB1R07’,‘CLB1R13’,‘CLB3’,‘CLB7’,‘CLC’,‘CLC2’,‘CLD1E06’,‘CLD1N09’,‘CLF1’,‘CLF1G10’,‘CLG3’,‘CLH1A08’,‘CLIONA1’,‘CLIOSSI’,‘CLJ’,‘CLJ1’,‘CLJ1A06’,‘CLK1’,‘CLK1V07’,‘CLL’,‘CLM’,‘CLM1N08’,‘CLM1U13’,‘CLM2’,‘CLOPES’,‘CLP2’,‘CLS1’,‘CLS1F09’,‘CLS1M08’,‘CLS5’,‘CLV’,‘CLV1P07’,‘CLW1D11’,‘CLW1R09’,‘CM’,‘CM1’,‘CM10G11’,‘CM1D08’,‘CM1E11’,‘CM1G09’,‘CM1M09’,‘CM1O07’,‘CM1P07’,‘CM1U07’,‘CM1U10’,‘CM2’,‘CM24G10’,‘CM27’,‘CM28V07’,‘CM2A06’,‘CM2E10’,‘CM2E11’,‘CM2F08’,‘CM2R07’,‘CM2U08’,‘CM2X07’,‘CM3A06’,‘CM3R08’,‘CM4R11’,‘CM4V12’,‘CM5C08’,‘CM6’,‘CM7’,‘CMB’,‘CMB1X07’,‘CMC’,‘CMC2’,‘CMC2W07’,‘CMD’,‘CMD22’,‘CMDL1F11’,‘CMEV’,‘CMF1P07’,‘CMF3’,‘CMG’,‘CMH2’,‘CMH297’,‘CMH3’,‘CMH3G11’,‘CMJ’,‘CMK1R07’,‘CML1E14’,‘CMM’,‘CMM1G06’,‘CMM1O07’,‘CMM1R13’,‘CMM4’,‘CMORONEY’,‘CMP1N08’,‘CMP1V07’,‘CMR1M11’,‘CMR3’,‘CMS1D09’,‘CMS1U08’,‘CMS4’,‘CMSAUNDE’,‘CMSP’,‘CMT’,‘CMT1’,‘CMT1E11’,‘CMT1G08’,‘CMW’,‘CMW2’,‘CN1A09’,‘CN1R10’,‘CN1U08’,‘CN2’,‘CNB1V07’,‘CNB2G10’,‘CNM’,‘CNP1’,‘CNR’,‘CNS’,‘CO’,‘CO1’,‘CO1N09’,‘CO1R07’,‘CO1V07’,‘CO1Y09’,‘CO3’,‘COD1C08’,‘COF’,‘COG1C09’,‘COH’,‘COK1E10’,‘COLACUBE’,‘COLETTI’,‘COLIN’,‘COLL1’,‘COLLINS1’,‘COMRRPP’,‘CONNELL’,‘CONNELLP’,‘CORINA’,‘CORINNE’,‘CORIRON’,‘COWERN’,‘CP1’,‘CP10’,‘CP11’,‘CP12’,‘CP14’,‘CP16V07’,‘CP18’,‘CP1D09’,‘CP1G09’,‘CP1Y09’,‘CP21G08’,‘CP2M08’,‘CP3A09’,‘CP3F11’,‘CP3M11’,‘CP3U08’,‘CP4’,‘CP5’,‘CP6’,‘CP8G12’,‘CPB’,‘CPB1’,‘CPD’,‘CPH1’,‘CPL1U09’,‘CPOPPER’,‘CPP’,‘CPS’,‘CPS1V09’,‘CPY’,‘CQ1’,‘CR1’,‘CR1C09’,‘CR1F09’,‘CR1F10’,‘CR1Y09’,‘CR3’,‘CR3M08’,‘CR5M08’,‘CR6’,‘CRAGUSA’,‘CRB’,‘CRC1V08’,‘CRC3G13’,‘CRG’,‘CRG1B06’,‘CRIC’,‘CRIMP1G’,‘CRK1’,‘CRLSWS’,‘CRM20’,‘CRP’,‘CRS1’,‘CRS3’,‘CRW’,‘CRW1’,‘CRYRNR’,‘CS10’,‘CS14G08’,‘CS15’,‘CS18G09’,‘CS1D09’,‘CS1G09’,‘CS1M09’,‘CS1N08’,‘CS1T07’,‘CS1U09’,‘CS1Y07’,‘CS2’,'CS2A0

John,

Screen shot as follows -

Screen shot didn’t come through but that’s OK. I see what’s going on.

We need an additional set of parens around all of these

owner IN (…) or owner in (…) or owner in (…)

I am guessing that you right-click in “Schemas to search” and chose “all except SYS & System”). As a workaround, just right-click and choose “Check all”, then we won’t make that giant list.

I’ll fix it.

Thanks.

Screen shot attached
TOAD_SCREEN_SHOT.docx (89.7 KB)

So…I went to fix it, and it was already fixed. I see now that you are using Toad version 12.6…it was fixed in 12.8.

-John

John,

It now seems to work if I check “all except SYS & System” and “Check all”.

I’m not sure why it’s suddenly started working.

Regards

Chris Halliday

Ah, yes, you are right…if “all except” is checked, the query just specifies to exclude those two rather than include everything else.

Maybe something else got unchecked the first time, or extra schemas got added since the action was created, so you weren’t really asking for all except those two.

In any case, I’m glad you’re able to get the result you’re looking for.

John,

Thanks for your help.

Chris Halliday