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

ORA-23427: deferred purge queue argument string out of range

1 Answers  

---

ORA-01943: IDENTIFIED BY already specified

1 Answers  

---

LSX-00011: internal error: ~s

1 Answers  

---

QSM-02140: agg(expr) requires correspondng SUM(expr*expr) function

1 Answers  

---

ORA-16953: Type of SQL statement not supported.

1 Answers  

---

ORA-09749: pws_look_up: port lookup failure

1 Answers  

---

ORA-16043: managed recovery session canceled

1 Answers  

---

ORA-19693: backup piece string already included

1 Answers  

---

ORA-19611: backup piece out of order. Expected string but found string

1 Answers  

---

ORA-13410: invalid layerNumbers or bandNumbers parameter

1 Answers  

---

ORA-00369: Current log of thread string not useable and other log being cleared

1 Answers  

---

IMG-00517: height or width not present in parameter string

1 Answers  

---