Oracle Error description:
ORA-03212 : Temporary Segment cannot be created in locally-managed tablespace
Cause : Attempt to create a temporary segment for sort/hash/lobs in in permanent tablespace of kind locally-managed
Action : Alter temporary tablespace of user to a temporary tablespace or a d
I will recommend to check the temporary tablespace for the user you are logged.
Please run this SQL's in the DreamCoder for Oracle and open the ouput.
| Code: |
select 'drop tablespace temp;' from dual
|
| Code: |
select 'create temporary tablespace temp tempfile '''||file_name||''' reuse
extent management local uniform size 4 M;'
from dba_data_files
where tablespace_name = 'TEMP'
|
Regards,
Peter
