Skip to content

manage-oracle-tablespaces.md

Latest commit

 

History

History
43 lines (31 loc) · 2.45 KB

manage-oracle-tablespaces.md

File metadata and controls

43 lines (31 loc) · 2.45 KB
title Manage Oracle Tablespaces | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql
ms.prod_service database-engine
ms.reviewer
ms.technology replication
ms.topic conceptual
helpviewer_keywords
Oracle publishing [SQL Server replication], managing tablespaces
tablespaces [SQL Server replication]
ms.assetid b8ea6c3b-01d6-4efc-bbfb-03b264530bbd
author MashaMSFT
ms.author mathoma

Manage Oracle Tablespaces

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] A tablespace is a unit of database storage that is roughly equivalent to a file group in [!INCLUDEmsCoName] [!INCLUDEssNoVersion]. 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