ORA-02156: invalid TEMPORARY tablespace identifier
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
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
| Is This Answer Correct ? | 0 Yes | 2 No |
ORA-27141: invalid process ID
ORA-23332: group string is in use; cannot drop
SQL*Loader-00649: Quoted string missing closing quote
ORA-33014: (XSAGDNGL06) In AGGMAP workspace object, variable operator workspace object cannot be dimensioned by rollup dimension workspace object.
PLS-00126: selector ALL is not allowed
ORA-09944: Password entry is corrupt.
ORA-19751: could not create the change tracking file
NID-00139: Mismatched dbname for datafile string, expected string, found string
NID-00352: string (number), error: number
NNL-00581: unregister_ns: <name server> <domain>
IMG-00552: invalid inputChannels specified
ORA-12318: database (link name string) is already mounted