CREATE TABLE [dbo].[fun_ora]
(
[fun_id] [int] NOT NULL,
[multi_out] [int] NOT NULL,
[output_file] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[write_scheme] [int] NOT NULL,
[rrobin_count] [int] NOT NULL,
[rrobin_output] [int] NOT NULL,
[filename_pattern] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[listing_filename] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[lob_file] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[varray_file] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[nested_file] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[directory_scheme] [int] NOT NULL,
[use_nfs] [int] NOT NULL,
[max_output_size] [int] NOT NULL,
[max_output_units] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[format_type] [int] NOT NULL,
[column_delimiter] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[row_delimiter] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[enclosure_char] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[enclosure_check] [int] NOT NULL,
[decimal_point] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[fixed_decimal] [int] NOT NULL,
[float_format] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[sql_loader_type] [int] NOT NULL,
[direct_path] [int] NOT NULL,
[ins_rep_app] [int] NOT NULL,
[byte_count_length] [int] NOT NULL,
[date_format] [int] NOT NULL,
[format_file] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[fixed_null_date] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[unrecoverable] [int] NOT NULL,
[parallel] [int] NOT NULL,
[version] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[binary_mode] [int] NOT NULL,
[col_byte_count] [int] NOT NULL,
[row_byte_count] [int] NOT NULL,
[sample] [int] NOT NULL,
[num_rows] [int] NOT NULL,
[max_varray_elem] [int] NOT NULL,
[max_open_files] [int] NOT NULL,
[max_sort_mem] [int] NOT NULL,
[odometer] [int] NOT NULL,
[log_file] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[dest_table_name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[loader_ctl_file] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[loader_sql_file] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sql_file] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sql_query] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sql_type] [int] NOT NULL,
[delimiter_check] [int] NOT NULL,
[all_rows] [int] NOT NULL,
[quiesce_retry] [int] NOT NULL,
[maxlong_lobsize] [int] NOT NULL,
[all_elements] [int] NOT NULL,
[fixed_null_num] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[max_num_threads] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_fun_ora] ON [dbo].[fun_ora] ([fun_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[fun_ora] TO [udmadmin_group]
GRANT INSERT ON  [dbo].[fun_ora] TO [udmadmin_group]
GRANT DELETE ON  [dbo].[fun_ora] TO [udmadmin_group]
GRANT UPDATE ON  [dbo].[fun_ora] TO [udmadmin_group]
GO