set head off
set pagesize 0
set trimspool on
set linesize 256
set verify off
set feedback off
set define on
set serveroutput on size 100000

spool design_tables.par

prompt ROWS=Y
prompt COMPRESS=N
prompt FILE=des_data.dmp
prompt LOG=des_data.log
prompt FEEDBACK=1000

declare

	i number := 0;

	cursor table_list is
		select table_name
		from user_tables
		where table_name not in (
			'SF_EVENT_ALERT_PROPERTY_VALUE',
			'SF_EVENT_ALERT',
			'SF_WORKITEM_QUEUE_VISIT',
			'SF_WORKITEM_PROPERTY_VALUE',
			'SF_EVENT_OCCURRENCE',
			'SF_WORKITEM_TRANSITION',
			'SF_TRIGGERED_RULE',
			'SF_WORKITEM_INSTANCE',
			'SF_EVENT_PROPERTY_VALUE',
			'SF_FILTER_RESULT',
			'SF_SESSION_LOG',
			'MVT_DATA_LOAD_HISTORY',
			'MVT_COVER_PAGE_INSTANCE',
			'MVT_COVER_PAGE_PROPERTY_VALUE',
			'MV_DOCUMENT',
			'MV_BATCH',
			'MV_FAX_REQUEST_HISTORY',
			'MV_FAX_REQUEST_VIEW_HISTORY',
			'MV_FORM_CONTROL_VALUE',
			'MV_IMAGE',
			'MV_MARKUP_OBJECT',
			'MV_PAGE',
			'MV_PAGE_MARKUPS_VIEW',
			'MV_PRINT_REQUEST',
			'MV_PRINT_REQUEST_VIEW',
			'MV_SESSION_LOG',
			'MV_FOLDER',
			'MV_FOLDER_DOCUMENT',
			'MV_MESSAGE_ATTRIBUTE_HISTORY',
			'MV_FAX_REQUEST',
			'MV_EXPORT_REQUEST',
			'MV_EXPORT_REQUEST_DOC',
			'MV_EXPORT_REQUEST_HISTORY',
			'MV_EXPORT_REQUEST_VIEW',
			'MV_EXPORT_REQUEST_VIEW_HISTORY',
			'MV_PRINT_REQUEST',
			'MVT_DOCUMENT_WORKITEM_INSTANCE',
			'MV_OBJECT_ACCESS_LOG',
			'MV_OBJECT_LOCK',
			'MV_MESSGE_HISTORY',
			'MVT_BUSINESS_CONTROL_INSTANCE',
			'MVERP_USER_SETUP_LOG',
			'MVT_BUSINESS_CKPT_ATTR_VALUE',
			'MVT_BUSINESS_CKPT_INSTANCE',
			'MVT_BUSINESS_CONTROLL_INSTANCE',
			'MVX_USER_SETUP_ERROR',
			'MVX_USER_SETUP_ERROR_SV',
			'MV_EXPORT_FILE_REQUEST',
			'MV_EXPORT_FILE_REQUEST_HISTORY',
			'MV_EXPORT_MAIL_REQUEST',
			'MV_EXPORT_MAIL_REQUEST_HISTORY',
			'MV_EXPORT_PRINT_REQUEST',
			'MV_EXPORT_PRINT_REQ_HISTORY',
			'MV_FAX_REQUEST_VIEW',
			'MV_MESSAGE_HISTORY',
			'MVT_RETURNED_INVOICE',
			'MV_EXPORT_REQUEST_DOC_HISTORY',
			'MVOA_DFM_MARKUP_OBJECT'

			)
		order by table_name;

begin

	dbms_output.put_line('tables=(');

	for each_table in table_list loop

		if i = 0 then
			dbms_output.put_line(each_table.table_name);
		else
			dbms_output.put_line(',' || each_table.table_name);
		end if;

		i := i + 1;

	end loop;

	dbms_output.put_line(')');

end;
/

spool off

set head on
set pagesize 2000
set trimspool off
set linesize 100
set verify on
set feedback on
set define on