New answers tagged

0

Change existing: SQL> create bigfile tablespace users2 datafile '/oradata/ORCL2/users.dbf' size 100M; Tablespace created. SQL> alter database default tablespace users2; Database altered. Create new one: DBCA allows you to choose bigfile tablespace for a Custom Database: A "General Purpose" or "Data Warehouse" database is actually a pre-created ...


0

Yes it's possible. As documented in the manual you can specify a tablespace when creating a table. However, tablespaces are rarely used in Postgres as they don't really provide any advantage. One of the few reasons to use them is, when you can't easily expand the size of your filesystem where the data directory is located.


Top 50 recent answers are included