Showing posts with label system tables. Show all posts
Showing posts with label system tables. Show all posts

Friday, February 8, 2013

Filter out all Oracle system schema from SqlDeveloper

http://www.adp-gmbh.ch/ora/misc/known_schemas.html

grep "<h2" known_schemas.html | cut -d '<' -f 2 | cut -d '>' -f 2
+ few schemas see at tail of list (link).

#!/usr/bin/env groovy

def stringList = [ "anonymous", "apex_public_user", "apex_030200", "appqossys", "bi", "ctxsys", "dbsnmp", "dip", "dmsys", "exfsys", "flows_XXXXXX", "hr", "ix", "lbacsys", "mddata", "mdsys", "mgmt_view", "odm", "odm_mtr", "oe", "olapsys", "oracle_ocm", "orddata", "ordplugins", "ordsys", "outln", "pm", "scott", "sh", "si_informtn_schema", "spatial_csw_admin_usr", "spatial_wfs_admin_usr", "sys", "sysman", "system", "tracesrv", "mtssys", "oaspublic", "olapsys", "owbsys", "owbsys_audit", "websys", "wk_proxy", "wksys", "wk_test", "wmsys", "xdb", "OSE\$HTTP\$ADMIN", "AURORA\$JIS\$UTILITY\$", "AURORA\$ORB\$UNAUTHENTICATED", "XS$NULL", "TRACESVR", "PERFSTAT" ];
stringList.each() { print """          <hash>
            <value n="ARG_CASE" v="false"/>
            <value n="ARG_NAME" v="USERNAME"/>
            <value n="ARG_PRED" v="NOT_LIKE"/>
            <list n="ARG_VALS">
               <string v="${it}"/>
            </list>
         </hash>
""" }; println "";

Result search in file:///home/USER/.sqldeveloper/system3.2.09.30/o.sqldeveloper.11.2.0.9.30/product-preferences.xml

and substitute block