Check and Set the Default tablespace for User in Oracle
SELECT * FROM database_properties
WHERE property_name = ‘DEFAULT_PERMANENT_TABLESPACE’;
You can set the default tablespace for user with following commands:
alter database default tablespace users;
Advertisements
