ORA-02155: invalid DEFAULT tablespace identifier

Question Posted / guest

2 Answers
9232 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-02379: profile string already exists

1 Answers

PCC-02426: Incompatible LOB types

1 Answers

NCR-03020: NCRO: Invalid call context

1 Answers

ORA-24039: Queue string not created in queue table for multiple consumers

1 Answers

ORA-24100: error in ktz testing layer

1 Answers

ORA-06928: CMX: wrong ORACLE_SID

1 Answers

ORA-02217: duplicate storage option specification

1 Answers

ORA-12039: unable to use local rollback segment "string"

1 Answers

RMAN-03020: asynhronous RPC test will take 1 minute

1 Answers

ORA-22958: This operation is not allowed in check constraints or triggers

1 Answers

RMAN-06423: requested limit of number exceeds vendor limit of number

1 Answers

ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.

1 Answers

For more Oracle Errors Interview Questions Click Here