Creating Test Tables

Create a test table in the primary and replicate databases, and grant maintenance user permissions to it to test that replication works.

1. In the Oracle primary database pdb1 in the Oracle data server, create a table named testtab with three columns: c1 integer, c2 integer and c3 char(10). See Oracle documentation for syntax.

2. In the replicate database iqdb in the Sybase IQ IQSRVR data server, enter:

   use iqdb
   go
   create table dbo.testtab(c1 int primary key, c2 int,
   c3 char(10))
   go
   grant all on dbo.testtab to public
   go