ORA-02155: invalid DEFAULT tablespace identifier

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-12481: effective label not within program unit clearance range

1 Answers  


ORA-02831: Segment deallocation failed - empty segment list

1 Answers  


RMAN-20503: DELETE cannot delete expired objects - run CROSSCHECK or DELETE EXPIRED

1 Answers  


NZE-29160: NZ library being used is different.

1 Answers  


NNL-00408: Answers:

1 Answers  






TNS-12160: TNS:internal error: Bad error number

1 Answers  


SQL*Loader-02026: the load was aborted because SQL Loader cannot continue.

1 Answers  


ORA-32630: multiple assignment in automatic order MODEL

1 Answers  


ORA-02719: osnfop: fork failed

1 Answers  


TNS-12650: No common encryption or data integrity algorithm

1 Answers  


RMAN-06497: WARNING: controlfile is not current, controlfile autobackup skipped

1 Answers  


ORA-27300: OS system dependent operation:string failed with status: string

1 Answers  


Categories