Manage Oracle Tablespaces

Applies to: SQL Server

A tablespace is a unit of database storage that is roughly equivalent to a file group in Microsoft SQL Server. Tablespaces allow storage and management of database objects within individual groups. For more information, see the Oracle documentation.

When you configure a table as part of an Oracle publication, you can optionally specify an existing Oracle tablespace to be used when storing replication logging information. If unspecified, the tablespace for the replication objects is the default tablespace associated with the replication administrative user schema that was configured when configuring the Publisher.

To specify a tablespace for an article logging table:

  • Specify a tablespace in the Article Properties dialog box. For more information about accessing this dialog box, see View and Modify Publication Properties.

  • Use sp_changearticle (Transact-SQL). To use sp_changearticle, specify the following:

    • The name of the Oracle Publisher for the parameter @publisher.

    • The name of the Oracle publication for the parameter @publication.

    • The name of the article for the parameter @article.

    • A value of 'tablespace' for the parameter @property.

    • The name of the tablespace for the parameter @value.

See Also

Configure an Oracle Publisher
Objects Created on the Oracle Publisher