Database DataWarehousing (MOSC)

MOSC Banner

In 11gR2 is there a way to combine two tables into one without using DML?

edited May 3, 2012 1:42AM in Database DataWarehousing (MOSC) 7 commentsAnswered
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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center