thomasliju
asked on
application schema
I want sort out only the application schema from the database..
Do you find any mistakes in this..
SYS@sprefuat1> l
1 select distinct
2 owner
3 from
4 dba_segments
5 where
6 owner not in (
7* 'SYSTEM', 'XDB', 'SYS', 'TSMSYS', 'MDSYS', 'EXFSYS', 'WMSYS', 'ORDSYS', 'OUTLN', 'DBSNMP')
SYS@sprefuat1> a order by 1
7* 'SYSTEM', 'XDB', 'SYS', 'TSMSYS', 'MDSYS', 'EXFSYS', 'WMSYS', 'ORDSYS', 'OUTLN', 'DBSNMP') order by 1
SYS@sprefuat1> /
OWNER
-------------------------- ----
AUGEAS
BLS
CAPIQ
CAPIQ_INCR
CGS_ETL_USER
COMPUSTAT
COMUTIL
COMUTIL_ARCHIVE
COMUTIL_CDC
COMUTIL_USER
CREDITSCOPE
OWNER
-------------------------- ----
CTXSYS
DCT
DMSYS
DROOLS_REPO
DSP_CACHE
EMMA
EXCEPTION_REP
EXPERIAN
FDIC
FINMASTER
FINMASTER_ETL_USER
OWNER
-------------------------- ----
FIN_MASTER
FIN_METADATA
FTIDC
GLOBALINSIGHT
GLPMETA
GLP_ADMIN
KLCA
LDAP
MARKIT
NCUA
PERFSTAT
OWNER
-------------------------- ----
PFAD
PRECISEG
PRECISEH
QUANT
REF_ETL_USER
REUTERS
SPAINBANKS_AEB
SPAINBANKS_CECA
SPINDEXSERVICES
SYSMAN
TOYOKEIZAI
OWNER
-------------------------- ----
TULLETT
WKSYS
WK_TEST
47 rows selected.
Please give me more clear script if this is wrong
Do you find any mistakes in this..
SYS@sprefuat1> l
1 select distinct
2 owner
3 from
4 dba_segments
5 where
6 owner not in (
7* 'SYSTEM', 'XDB', 'SYS', 'TSMSYS', 'MDSYS', 'EXFSYS', 'WMSYS', 'ORDSYS', 'OUTLN', 'DBSNMP')
SYS@sprefuat1> a order by 1
7* 'SYSTEM', 'XDB', 'SYS', 'TSMSYS', 'MDSYS', 'EXFSYS', 'WMSYS', 'ORDSYS', 'OUTLN', 'DBSNMP') order by 1
SYS@sprefuat1> /
OWNER
--------------------------
AUGEAS
BLS
CAPIQ
CAPIQ_INCR
CGS_ETL_USER
COMPUSTAT
COMUTIL
COMUTIL_ARCHIVE
COMUTIL_CDC
COMUTIL_USER
CREDITSCOPE
OWNER
--------------------------
CTXSYS
DCT
DMSYS
DROOLS_REPO
DSP_CACHE
EMMA
EXCEPTION_REP
EXPERIAN
FDIC
FINMASTER
FINMASTER_ETL_USER
OWNER
--------------------------
FIN_MASTER
FIN_METADATA
FTIDC
GLOBALINSIGHT
GLPMETA
GLP_ADMIN
KLCA
LDAP
MARKIT
NCUA
PERFSTAT
OWNER
--------------------------
PFAD
PRECISEG
PRECISEH
QUANT
REF_ETL_USER
REUTERS
SPAINBANKS_AEB
SPAINBANKS_CECA
SPINDEXSERVICES
SYSMAN
TOYOKEIZAI
OWNER
--------------------------
TULLETT
WKSYS
WK_TEST
47 rows selected.
Please give me more clear script if this is wrong
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.