Oracle Message ORA-12902 - default temporary tablespace must be SYSTEM or of TEMPORARY type ORA-12902 NOTES ERRORdefault temporary tablespace must be SYSTEM or of TEMPORARY type CAUSEin a dictionary managed database, default temporary tablespace must be SYSTEM or TEMPORARY type ACTIONNone 683075Oracle9i: Default Temporary Tablespace659946FAQ: Temporary tablespaces