-- Create table
create table BACKUP_JOB
(
process_order NUMBER,
duplicate NUMBER,
dump_fileid NUMBER,
dump_position NUMBER,
dump_length NUMBER,
dump_orig_length NUMBER,
dump_allocation NUMBER,
completed_rows NUMBER,
error_count NUMBER,
elapsed_time NUMBER,
object_type_path VARCHAR2(200),
object_path_seqno NUMBER,
object_type VARCHAR2(30),
in_progress CHAR(1),
object_name VARCHAR2(500),
object_long_name VARCHAR2(4000),
object_schema VARCHAR2(30),
original_object_schema VARCHAR2(30),
original_object_name VARCHAR2(4000),
partition_name VARCHAR2(30),
subpartition_name VARCHAR2(30),
dataobj_num NUMBER,
flags NUMBER,
property NUMBER,
trigflag NUMBER,
creation_level NUMBER,
completion_time DATE,
object_tablespace VARCHAR2(30),
size_estimate NUMBER,
object_row NUMBER,
processing_state CHAR(1),
processing_status CHAR(1),
base_process_order NUMBER,
base_object_type VARCHAR2(30),
base_object_name VARCHAR2(30),
base_object_schema VARCHAR2(30),
ancestor_process_order NUMBER,
domain_process_order NUMBER,
parallelization NUMBER,
unload_method NUMBER,
load_method NUMBER,
granules NUMBER,
scn NUMBER,
grantor VARCHAR2(30),
xml_clob CLOB,
parent_process_order NUMBER,
name VARCHAR2(30),
value_t VARCHAR2(4000),
value_n NUMBER,
is_default NUMBER,
file_type NUMBER,
user_directory VARCHAR2(4000),
user_file_name VARCHAR2(4000),
file_name VARCHAR2(4000),
extend_size NUMBER,
file_max_size NUMBER,
process_name VARCHAR2(30),
last_update DATE,
work_item VARCHAR2(30),
object_number NUMBER,
completed_bytes NUMBER,
total_bytes NUMBER,
metadata_io NUMBER,
data_io NUMBER,
cumulative_time NUMBER,
packet_number NUMBER,
instance_id NUMBER,
old_value VARCHAR2(4000),
seed NUMBER,
last_file NUMBER,
user_name VARCHAR2(30),
operation VARCHAR2(30),
job_mode VARCHAR2(30),
queue_tabnum NUMBER,
control_queue VARCHAR2(30),
status_queue VARCHAR2(30),
remote_link VARCHAR2(4000),
version NUMBER,
job_version VARCHAR2(30),
db_version VARCHAR2(30),
timezone VARCHAR2(64),
state VARCHAR2(30),
phase NUMBER,
guid RAW(16),
start_time DATE,
block_size NUMBER,
metadata_buffer_size NUMBER,
data_buffer_size NUMBER,
degree NUMBER,
platform VARCHAR2(101),
abort_step NUMBER,
instance VARCHAR2(60),
cluster_ok NUMBER,
service_name VARCHAR2(100),
object_int_oid VARCHAR2(32)
)
tablespace XXXXX
pctfree 10
initrans 10
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table BACKUP_JOB
is 'Data Pump Master Table EXPORT SCHEMA ';
-- Create/Recreate indexes
create index SYS_MTABLE_000017160_IND_1 on BACKUP_JOB (OBJECT_SCHEMA, OBJECT_NAME, OBJECT_TYPE)
tablespace xxxxxxx
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
create index SYS_MTABLE_000017160_IND_2 on BACKUP_JOB (BASE_PROCESS_ORDER)
tablespace XXXXXXXX
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table BACKUP_JOB
add unique (PROCESS_ORDER, DUPLICATE)
using index
tablespace XXXXXXX
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);