Resolution:
1. ActiveDB needs to create its own tables; they are called catalog tables. There are 7 of them. In Oracle, they need to be in the same table space as your source table. In MSSQL, they need to be in the same database as your source table.

2. When publishing by value, your source table content will be copied into the publishing table. Depending on how big your source table is, you can decide how big of a storage you need. Other tables don't occupy a lot space.

3. The catalog tables need to be under the same owner as the source table.