In 11gR2 is there a way to combine two tables into one without using DML?
Hello all,
We have an application that uses two tables in an 11.2 database to store document information. The CURRENT_INFO table shows the current version of a document; the ARCHIVE_INFO shows the history information. The two tables have identical definitions (and, though not shown, identical index definitions):
create table CURRENT_INFO (
sys_id varchar(32) not null,
details clob,
summary clob,
updated_by varchar2(40) DEFAULT NULL,
updated_on timestamp DEFAULT NULL,
created_by varchar2(40) DEFAULT NULL,
created_on timestamp DEFAULT NULL,
mod_count number(11) DEFAULT NULL
);
create table ARCHIVE_INFO (
sys_id varchar(32) not null,
details clob,
summary clob,
updated_by varchar2(40) DEFAULT NULL,
We have an application that uses two tables in an 11.2 database to store document information. The CURRENT_INFO table shows the current version of a document; the ARCHIVE_INFO shows the history information. The two tables have identical definitions (and, though not shown, identical index definitions):
create table CURRENT_INFO (
sys_id varchar(32) not null,
details clob,
summary clob,
updated_by varchar2(40) DEFAULT NULL,
updated_on timestamp DEFAULT NULL,
created_by varchar2(40) DEFAULT NULL,
created_on timestamp DEFAULT NULL,
mod_count number(11) DEFAULT NULL
);
create table ARCHIVE_INFO (
sys_id varchar(32) not null,
details clob,
summary clob,
updated_by varchar2(40) DEFAULT NULL,
0