on 10g R2, on AIX 6.1, I have the following in DB control/Policy violation.
I can not understand what it wants to say and do not know what I should do.
Default Permanent Tablespace Set to a System Tablespace
Thanks for help.
It means default tablespace for new created user will this tablespace.If it is system tablespace then change it as
select PROPERTY_VALUE from database_properties where PROPERTY_NAME='DEFAULT_PERMANENT_TABLESPACE'
alter database default tablespace users;
ALTER DATABASE DEFAULT TABLESPACE users; or ALTER DATABASE DEFAULT TABLESPACE <any_existing_tablespace_you_want_to_be_default>;