Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Manage tables in Dataverse - Training
Dataverse tables are similar to tables in a database. Every instance of a Dataverse database includes a base set of tables that provide structure for data that is commonly used by business applications.