Unsharing multi-site shared tables
In a multi-site environment where there are many sites, large amounts of data, and many users, you might want to set up one site as the master site for an intranet. In that case, certain _all and user tables can reside only on the master site database and are shared (read and written to through a SQL view) by other sites on the same intranet. For more information, see Setting Up Multi-Site Shared Tables.
See these topics: