ORA-02155: invalid DEFAULT tablespace identifier

Question Posted / guest

2 Answers
10340 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

NNL-00852: Renames refused, name is a topology name: number

1 Answers

RMAN-08011: including current controlfile in backupset

1 Answers

SQL*Loader-00709: Internal error calling SLTS layer: string failed

1 Answers

ORA-29289: directory access denied

1 Answers

DRG-10518: an operation is in progress which conflicts with string request

1 Answers

DRG-11439: index name length exceeds maximum of string bytes

1 Answers

ORA-16575: request terminated at broker discretion

1 Answers

ORA-01140: cannot end online backup - all files are offline or readonly

1 Answers

PLS-00330: invalid use of type name or subtype name

1 Answers

RMAN-06029: the controlfile may be included only in a datafile backup set

1 Answers

TNS-00021: INTCTL: missing INTERCHANGE_DATA in INTCHG.ORA

1 Answers

CLSS-03201: An attempt to begin a nested reconfiguration failed.

1 Answers

For more Oracle Errors Interview Questions Click Here