Answer / guest

alter user user1 temporary tablespace 'ts_tmp1';  --wrong
alter user user1 temporary tablespace ts_tmp1;   --correct

We don't wrap it in single quotation marks to tablespace name.

Answer / guest

Cause: An identifier does not follow TEMPORARY TABLESPACE.

Action: Place a tablespace name after TEMPORARY TABLESPACE.

Please add more information about this Error

NID-00332: The following datafiles are in unknown state:

1 Answers  

---

DRG-50702: error in drtlsleep()

1 Answers  

---

ORA-12160: TNS:internal error: Bad error number

1 Answers  

---

ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyword

1 Answers  

---

IMG-00556: incorrect number of gamma values

1 Answers  

---

---

RMAN-08590: channel string: datafile conversion complete, elapsed time: string

1 Answers  

---

DRG-11003: invalid value string for string

1 Answers  

---

ORA-16066: remote archival disabled

1 Answers  

---

DRG-13104: indexes do not have equivalent settings for string

1 Answers  

---

ORA-32766: instr with negative offset: use varchar semantics on LOBs

1 Answers  

---

ORA-12423: invalid position specified

1 Answers  

---

PLS-00239: invalid external type specification for SQLCODE

1 Answers  

---