Managing Oracle Tablespaces

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 How to: View and Modify Publication and Article Properties (SQL Server Management Studio).
• 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

Concepts

Configuring an Oracle Publisher
Objects Created on the Oracle Publisher

Help and Information

Getting SQL Server 2005 Assistance

Change History