ORA-30022: Cannot create segments in undo tablespace

Answers were Sorted based on User's Feedback



ORA-30022: Cannot create segments in undo tablespace..

Answer / antony ankrose

Cause: Cannot create segments in undo tablespace


Answer: You cannot create a Table in undo tablespace. Check
the default tablespace is what? is undo tablespace is
specified .. Using alter user .. change the default
tablespace ....

Is This Answer Correct ?    0 Yes 0 No

ORA-30022: Cannot create segments in undo tablespace..

Answer / guest

Cause: Cannot create segments in undo tablespace

Action: Check the tablespace name and reissue command

Please add more information about this Error

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-20034: resync not needed

1 Answers  


ORA-38752: file string does not exist

1 Answers  


ORA-13039: failed to update spatial index for element string.string.string

1 Answers  


TNS-00202: Failure in redirecting call : Original to string Redirect to string

1 Answers  


ORA-02040: remote database string does not support two-phase commit

1 Answers  


PCC-02113: DBMS=V6 no longer supported; using DBMS=NATIVE, CHAR_MAP=VARCHAR2.

1 Answers  


SQL*Loader-00703: Internal error: argument number

1 Answers  


ORA-09841: soacon: Name translation failure.

1 Answers  


QSM-02018: subquery present in the WHERE clause

1 Answers  


ORA-01945: DEFAULT ROLE[S] already specified

1 Answers  


ORA-24194: attempt to read data in a message as the wrong type

1 Answers  


NNL-01069: Log file name: string

1 Answers  


Categories