rem ----------------------------------------------------------------------------
rem File:        $RCSfile: ckexpres.sql $
rem Author:      $Author: aobhrai $
rem Date:        $Date: 1998/03/16 15:26:14 $
rem Version:     $Revision: 1.4 $
rem Status:      $State: Exp $
rem Locked_by:   $Locker:  $
rem Description: <Enter global description here>
rem Notes:       <Global notes>
rem RealAuth:    <Full real name of code author>
rem IncepDate:   <nnth Xxxember 1994>
rem Copyright:   (c) Oracle Corporation 1994.  All Rights Reserved.
rem ----------------------------------------------------------------------------
rem Log of Changes from RCS
rem ----------------------------------------------------------------------------
rem $Log: ckexpres.sql $
rem Revision 1.4  1998/03/16  15:26:14  aobhrai
rem *** empty log message ***
rem
rem Revision 1.3  1995/09/15  14:33:18  dedwards
rem Remove control Z from end of file
rem
rem Revision 1.2  1995/07/14  13:51:33  dedwards
rem rem added to end of file
rem
rem Revision 1.1  1995/06/12  13:09:58  dedwards
rem Initial revision
rem
rem ----------------------------------------------------------------------------
rem  
rem
rem $Header: \\ukst76\rcsroot.4_0\model\repadm40\utl\RCS\ckexpres.sql 1.4 1998/03/16 15:26:14 aobhrai Exp $ ckexpres.sql Copyr (c) 1992, 1989 Oracle
rem
REM This file dynamically creates a parameter file to export a 
REM Dictionary owner 
REM The parameter file produced is called ckexport.tmp 
REM Export of GRANTS and INDEXES is disabled as the user can
REM nominate at import time what addition scripts need to be run


set termout on
PROMPT
PROMPT ***********************************************************************
PROMPT * Designer/2000 Repository Administration Utilities:
PROMPT * Export Repository Tables.
PROMPT *
PROMPT ***********************************************************************^
PROMPT
PROMPT Creating Export Parameter File...
PROMPT

set heading off
set pages 0
set feedback off
set termout off
set lines 33
column nl newline
spool ckexport.exp


PROMPT GRANTS=N
PROMPT INDEXES=N
PROMPT FULL=N
PROMPT TABLES=(

SELECT DECODE(ROWNUM,1,'',',')||UT.TABLE_NAME nl 
FROM USER_TABLES UT
,    SDD_RESERVED_NAMES RN
WHERE RN.RN_TYPE = 'TABLE'
AND   RN.RN_RES_NAME = UT.TABLE_NAME
;

PROMPT )

spool off

EXIT

rem  
rem ----------------------------------------------------------------------------
rem $$Header_is_done
rem  End of file $RCSfile: ckexpres.sql $
rem ----------------------------------------------------------------------------
rem

