ORA-10644: SYSTEM tablespace cannot be default temporary
tablespace



ORA-10644: SYSTEM tablespace cannot be default temporary tablespace..

Answer / guest

Cause: When SYSTEM tablespace is being migrated no user
should have SYSTEM as the default temporary tablespace.

Action: Reissue this command after altering the default
temporary tablespace setting for all users.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }

1 Answers  


SQL*Loader-00350: Syntax error at line number.

1 Answers  


ORA-24004: invalid column name string in SORT_LIST, should be ENQ_TIME or PRIORITY

1 Answers  


NZE-29030: SSL handshake is requested.

1 Answers  


ORA-12225: TNS:destination host unreachable

1 Answers  






NCR-03015: NCRO: No transport address

1 Answers  


ORA-02047: cannot join the distributed transaction in progress

1 Answers  


ORA-01194: file string needs more recovery to be consistent

1 Answers  


TNS-00299: Response from Navigator: string

1 Answers  


LPX-00204: syntax error

1 Answers  


ORA-01591: lock held by in-doubt distributed transaction string

1 Answers  


ORA-22150: variable-length array has not been initialized

1 Answers  


Categories