ORA-02155: invalid DEFAULT tablespace identifier

Question Posted / guest

2 Answers
10435 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-07495: spwat: lm_wait failed.

1 Answers

DRG-13004: language is invalid

1 Answers

QSM-02021: set operator encountered in mv

1 Answers

ORA-29366: invalid CONSUMER_GROUP argument specified

1 Answers

ORA-32021: parameter value longer than string characters

1 Answers

ORA-01278: error creating file 'string'

1 Answers

NNO-00069: warning: too many administrative region check failures, checking disabled

1 Answers

ORA-16703: cannot set the property while the database is enabled

1 Answers

ORA-23302: application raised communication failure during deferred RPC

1 Answers

LPX-00258: invalid "Mixed" specification in element declaration

1 Answers

LFI-00144: File [string][string] does not exist

1 Answers

NID-00330: The following datafiles are offline immediate:

1 Answers

For more Oracle Errors Interview Questions Click Here