#### HOW to solve it.
## To check the default temporary tablespace of the database:
SQL> select property_name, property_value from database_properties;
## check DEFAULT_TEMP_TABLESPACE, if it use wrong temporary tablespace, run:
SQL> alter database default temporary tablespace temp;
## check user with temporary tablespace, run command:
SQL> select username, temporary_tablespace, account_status from dba_users;
## change temporary tablespace:
SQL> create temporary tablespace temp1 tempfile '/data/u01/app/oracle/oradata/TIS/temp_b.dbf' size 100m;
SQL> alter database default temporary tablespace temp1;
SQL> drop tablespace temp including contents and datafiles;
SQL> create temporary tablespace temp tempfile '/data/u01/app/oracle/oradata/TIS/temp01.dbf' size 100m autoextend off extent management local uniform size 1m;
SQL> alter database default temporary tablespace temp;
SQL> drop tablespace temp1 including contents and datafiles;
It works! Thank you very much
ReplyDeleteThank You and that i have a keen offer: How Much House Renovation Cost house and renovation show
ReplyDelete