ORA-02155: invalid DEFAULT tablespace identifier

Question Posted / guest

2 Answers
10192 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-25454: error during evaluation of rule set: string.string for iterator: string

1 Answers

IMG-00578: missing quantize argument

1 Answers

RMAN-00553: internal recovery manager package failed to load

1 Answers

ORA-23323: parameter length exceeds deferred RPC limits

1 Answers

PLS-01417: Use of %%attribute

1 Answers

ORA-12151: TNS:received bad packet type from network layer

1 Answers

ORA-24501: invalid UTF16 string passed in

1 Answers

ORA-02353: files not from the same unload operation

1 Answers

ORA-01037: maximum cursor memory exceeded

1 Answers

ORA-13900: missing or invalid parameter string

1 Answers

ORA-27021: sequential file handle must be specified

1 Answers

ORA-29255: Cursor contains both bind and define arrays which is not permissible

1 Answers

For more Oracle Errors Interview Questions Click Here