Does tables under schema uses multiple tablespaces other than default tablespace

I have schema A in a database and have assigned the default tablespace as myspace.

There are 20 tables that reside under this single schema and all the tables are using different tablespaces.

My question is:

Why are all tables using different tablespaces instead of the default tablespace?

Database Administrators Asked by Maheshnagakumar on December 28, 2020

1 Answers

One Answer

A default tablespace is just that, a default. If you specify a different tablespace when you create a table, the table will be created in the tablespace you specified. Though it would generally not make sense to do so, you could put each table in a different tablespace so that the user owned 20 tables in 20 different tablespaces none of which were the default tablespace.

Alternately, a user's default tablespace can be changed so it is possible that the 20 tables were created without a specified tablespace but when the user's default tablespace was different. Then the user's default tablespace was changed after all the tables were created.

Answered by Justin Cave on December 28, 2020

Add your own answers!

Related Questions

Install mysql through deb file on ubuntu 20.04

1  Asked on September 13, 2020 by ajeetkumar


Indexes not used for join

1  Asked on September 11, 2020 by dmitriy-grankin


tables inheritance stored procedure

1  Asked on September 10, 2020 by juclart-ngouedi


Schema for scarce goods

1  Asked on September 5, 2020 by empedokles


Restoring multiple files to multiple database with pg_restore

1  Asked on September 2, 2020 by irakli-ugulava


Getting midnight of today

4  Asked on August 25, 2020 by logu


Compare 2 columns in 2 different tables with non uniques values

3  Asked on August 18, 2020 by deepak-garg


How to easily convert utf8 tables to utf8mb4 in MySQL 5.5

10  Asked on August 14, 2020 by geoaxis


SSIS Package Not Being Deployed

1  Asked on August 14, 2020 by steveg


Ask a Question

Get help from others!

© 2022 All rights reserved.