ORA-02155: invalid DEFAULT tablespace identifier

Question Posted / guest

2 Answers
10206 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-25179: invalid PCTTHRESHOLD storage option value

1 Answers

ORA-19578: end of volume while duplexing to sequential files, backup piece incomplete

1 Answers

ORA-22800: invalid user-defined type

1 Answers

ORA-03231: the INITIAL extent may not be deallocated

1 Answers

ORA-09809: Unable to get user's group ID from connection

1 Answers

LSX-00111: type "~S" contains invalid facets

1 Answers

IMG-00834: merged area queue is full

1 Answers

RMAN-06476: channel number out of range (1-254): number

1 Answers

PROT-00006: The specified import file cannot be found

1 Answers

ORA-32408: materialized view log on "string"."string" already has new values

1 Answers

ORA-29306: datafile string is not online

1 Answers

NNL-00275: Trace level is currently number

1 Answers

For more Oracle Errors Interview Questions Click Here