ORA-02155: invalid DEFAULT tablespace identifier

Question Posted / guest

2 Answers
10320 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

ORA-02155: invalid DEFAULT tablespace identifier..

Answer / guest

Cause: An identifier does not follow DEFAULT TABLESPACE.

Action: Place a tablespace name after DEFAULT TABLESPACE.

Please add more information about this Error

Is This Answer Correct ?

3 Yes

0 No

ORA-02155: invalid DEFAULT tablespace identifier..

Answer / abhishek tyagi

alter database default tablespace users are define

Is This Answer Correct ?

0 Yes

1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-26683: invalid value for value_type

1 Answers

ORA-09771: osnmwrtbrkmsg: bad return code from msg_send.

1 Answers

ORA-01626: rollback segment number 'string' cannot handle more transactions

1 Answers

NNL-00511: Shows or sets the server's system query authority requirements

1 Answers

ORA-22163: left hand and right hand side collections are not of same type

1 Answers

PLS-00368: in RAISE statement, 'string' must be an exception name

1 Answers

DRG-12201: section group string already exists

1 Answers

ORA-10621: data block does not belong to the segment

1 Answers

DRG-11708: too many thesauri

1 Answers

ORA-02705: osnpol: polling of communication channel failed

1 Answers

ORA-01470: In-list iteration does not support mixed operators

1 Answers

QSM-01062: query has one or more manual partition(s)

1 Answers

For more Oracle Errors Interview Questions Click Here