Lesson 7: Inserting data

In this lesson, you insert some more data into the remote and consolidated databases using the new schema.

Prerequisites

This lesson assumes you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Changing a schema using the script version clause.

This lesson assumes you have completed all preceding lessons. See Lesson 1: Creating and configuring the consolidated database.

Using Interactive SQL, execute the following SQL statements on the remote database.

INSERT INTO customer VALUES( 3, 'Mo Hamid', '613-411-9999', '613-502-1212' );
COMMIT;

Using Interactive SQL, execute the following SQL statements on the consolidated database.

INSERT INTO customer VALUES( 101, 'Theo Tug', '212-911-7677', '212-311-3900' );
COMMIT;

Results

Data is inserted into the remote and consolidated databases using the new schema.

Next

Proceed to Lesson 8: Synchronizing.

Discuss this page in DocCommentXchange.