Tiffany Thang writes:
> Thanks Tom. As the superuser, I'm able to create the table in the specific
> tablespace. Does myuser require additional privileges?
Yes, USAGE on the tablespace if memory serves (check the GRANT man page
for details).
> My aim is to be able to create table in a specific t
Thanks Tom. As the superuser, I'm able to create the table in the specific
tablespace. Does myuser require additional privileges?
My aim is to be able to create table in a specific tablespace (in this
case, mytablespace) by default without having to explicitly specific one. I
would think that is p
Tiffany Thang writes:
> According to the documentation, a table can be created in a specific
> tablespace by performing the following:
> 1. Specify the tablespace parameter in the create database statement.
> 2. Specify the tablespace parameter in the create table statement.
> I've tried both but
Hi,
I'm not able to create tables in a specific tablespace. I'm not sure what I
have missed.
According to the documentation, a table can be created in a specific
tablespace by performing the following:
1. Specify the tablespace parameter in the create database statement.
2. Specify the tablespace