p27870645_112040_Linux-x86-64

Rem Rem $Header: rdbms/admin/catexp.sql /st_rdbms_11.2.0.4.0dbpsu/2 2016/05/26 21:07:35 mjangir Exp $ expvew.sql Rem Rem Copyright (c) 1987, 2016, Oracle and/or its affiliates. Rem All rights reserved. Rem NAME Rem CATEXP81.SQL - CATalog EXPort/import sql script Rem FUNCTION Rem Creates internal views for Export/Import utility Rem NOTES Rem Must be run when connected to SYS or INTERNAL. Rem Rem This file is organized into 3 sections: Rem Section 1: Views needed by BOTH export and import Rem Section 2: Views required by import ONLY Rem Section 3: Views required by export ONLY Rem Rem Import does not currently require any views of its own. The views Rem used by both tools are moved to the top so that a user doing an import Rem only has to run part of this file. Since there are common views Rem a separate file called catimp.sql was not created for now for Rem maintenance reasons. Rem Rem No views depend on catalog.sql. This script can be run standalone. Rem Rem Rem MODIFIED Rem mjangir 04/30/16 - Backport mjangir_bug-22380919 from main Rem mjangir 01/06/16 - bug 22380919 Rem mjangir 02/02/12 - bug 13482990 Rem apfwkr 07/02/12 - Backport jibyun_bug-9524209 from main Rem tbhukya 19/04/10 - Bug 9595499: Get fragflags for sub partiton Rem lob columns Rem mjangir 11/12/09 - do not export the jobs owns by sys if exporting Rem by other than sys user Rem mjangir 10/28/09 - bug 8982033: restrict password access Rem EXP_FULL_DATABASE Rem tbhukya 08/25/09 - Bug 8833245: remove deferred storage segment Rem check from view exu10tabs Rem tbhukya 07/13/09 - Bug 8679246: use to_char for password_date Rem in exu8phs Rem tbhukya 05/08/09 - Bug 8467693: use col# also Rem ebatbout 04/09/09 - bug 8397778: Prefix session_roles with SYS Rem adalee 03/06/09 - new cachehint Rem mjangir 12/10/08 - bug 7632440: add support for VPD policies with Rem sstatement_type of "INDEX Rem mjangir 11/20/08 - bug 7568350: Policy type changed Rem tbhukya 10/06/08 - Bug 7422758 : Add imp9synu Rem mjangir 07/28/08 - bug 6936881: ORA-01436: CONNECT BY loop Rem msakayed 05/12/08 - Lrg #3390108: fix exu8dir view Rem dsemler 02/29/08 - update to exclude APPQOSSYS user Rem mjangir 02/04/08 - 6119138: grant to exp_full_db instead of Rem select_catalog_role for exu8phs Rem mjangir 09/11/07 - XbranchMerge mjangir_bug-5872788_10.2.0.4 from Rem st_rdbms_10.2 Rem mjangir 06/07/07 - bug 5872788 operator dependency ordering Rem weizhang 03/08/07 - lrg 2884728: support tablespace MAXSIZE Rem hosu 02/27/07 - add administer sql management object to Rem exp_full_database and imp_full_database roles Rem kamble 11/02/06 - add IDR_DIR to noexp$ Rem slynn 10/12/06 - smartfile->securefile Rem yhu 09/14/06 - export with system managed statistics Rem mhho 09/10/06 - add XS$NULL to be excluded from all views Rem kamble 09/07/06 - exu11xml view for getting opqtype$ flags Rem kamble 08/10/06 - encrypted tablespace Rem ataracha 07/13/06 - add user anonymous to be excluded from all views Rem mjangir 07/10/06 - 5176017: Adding ifreepool column in exu9lob view Rem dkapoor 07/03/06 - don't export ORACLE_OCM Rem weizhang 06/06/06 - proj 18567: support LOBRETENTION and MAXSIZE Rem xbarr 06/06/06 - remove DMSYS schema - obsolete in 11g Rem sramakri 05/15/06 - define exu11ind similar to exu9ind Rem sramakri 04/12/06 - index changes for mvs Rem wesmith 04/05/06 - add snapshot views for v11 Rem kamble 03/13/06 - 4711857: comment$ problem(long column involved) Rem dgagne 01/26/06 - add replace for apos in exu10asc view for Rem columns with apos in them Rem jgalanes 12/20/05 - Add expxsldelim for 4656020 Rem sdavidso 11/30/05 - Fix 4087161 - MDAPI for nested tables w/XMLtype Rem jgalanes 08/04/05 - Fix 4526056 - exu81ixsp - get compression Rem jgalanes 07/13/05 - 4375555 IOT w/mapping table in TRANSPORTABLE Rem mode Rem cdilling 05/11/05 - Fix 4347949 - ignore java classes owned by SYS Rem jgalanes 05/09/05 - Fix 4046842 - exclude types not related to Rem subject table Rem cdilling 05/02/05 - ignore WMSYS Rem kneel 11/11/04 - fix lrg 1795214: unique constraint error on Rem import Rem jgalanes 10/27/04 - Fix 3906846 - add exu102xtyp view Rem araghava 10/25/04 - 3448802: don't partobj$ to get blocksize in Rem *_LOBS Rem jgalanes 10/15/04 - 3651756 switch from SELECT_CATALOG_ROLE Rem to ExP_FULL_DATABASE on exu?lnk Rem jgalanes 09/28/04 - PLSQL_CCFLAGS Rem rburns 09/13/04 - check for SYS user Rem jgalanes 08/31/04 - Column encryption Rem jgalanes 07/21/04 - Fix 3047454 TTS with unused ADT columns Rem cdilling 07/01/04 - Do not export EXFSYS schema or HELP table Rem jgalanes 06/10/04 - 3617574 add HAKAN factor to exu81tts Rem rvissapr 06/09/04 - proj 5523 dblink pswd encode Rem jgalanes 04/23/04 - Fix 3447083 - IOT degree lost Rem mxiao 03/25/03 - add EXU10SNAP* Rem jgalanes 03/05/04 - Adding new views for 3467567 imp_tab_trig & Rem imp_lob_notnull Rem jgalanes 02/25/04 - Fix 2654811 exu81tabs trigflag with row movement Rem bmccarth 02/03/04 - check tables making use of template part. Rem jgalanes 12/18/03 - Fix 2734632 - PRESERVE SPECIFICATION TIMESTAMP Rem jgalanes 12/18/03 - Fix 3107208 - replacing missing view Rem jgalanes 01/26/04 - Fix 2539145 EXEMPT ACCESS POLICY - EXPExEMPT Rem hikimura 11/11/03 - 3159568: add type to exu8ref Rem jgalanes 11/10/03 - lrg1566954 dataobj# ordering Rem jgalanes 11/06/03 - new views for 3230116 - compression Rem kamble 09/08/03 - 3071475: return attr name if lob is user defined Rem hikimura 08/01/03 - 2977202: add view imp9con Rem jgalanes 08/20/03 - Fix lrg1336525 - table stats for IOTs Rem clei 07/15/03 - synonym polices no longer attached to base object Rem kamble 06/25/03 - 2803911: add view exu8col_tts_unused_col Rem mramache 06/23/03 - sql profiles Rem bmccarth 06/27/03 - 10i version of exu9coe that includes column Rem with default values for object tables Rem jgalanes 05/21/03 - PLSQL_COMPILER_FLAGS changes Rem cdilling 05/19/03 - Do not export DBSNMP user Rem aramarao 04/24/03 - 2900891 fix ora-904 on spolicy exporting from 817 Rem jgalanes 05/20/03 - create exu10doso for 2946068 Rem krajaman 05/20/03 - Remove d_owner# from dependency$ Rem jgalanes 05/02/03 - 2859106 more supplemental log stuff Rem jgalanes 04/01/03 - Fix 2869900 by fixing DECODE in imp_lob_info view Rem bmccarth 03/18/03 - ignore DMSYS Rem bmccarth 03/20/03 - exclude recycle bin object from transportable Rem and domain index secondary object views Rem kamble 02/27/03 - imp9tvoid - get latest tvoid Rem bmccarth 01/22/03 - binary float/double values incorrect Rem wfisher 01/27/03 - Granting RESUMABLE priv to *_FULL_DATABASE roles Rem jgalanes 01/29/03 - PL/SQL compiler optimize switch changes Rem mxiao 01/13/03 - retrieve COMMENT in exu9snap Rem bmccarth 01/13/03 - return opqtype$ out-of-line flag Rem atsukerm 12/27/02 - grant pro