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