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-16097: ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY

1 Answers  


ORA-22862: specified object identifier doesn't match existing object identifier

1 Answers  


ORA-23398: user name "string" at database link "string" does not match local user name "string"

1 Answers  


SQL*Loader-00516: Control file (string) has no contents

1 Answers  


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

1 Answers  






ORA-06137: NETTCP: error during connection handshake

1 Answers  


ORA-26053: Row was not loaded due to conversion error.

1 Answers  


ORA-13046: invalid number of arguments

1 Answers  


ORA-30053: invalid upper limit snapshot expression

1 Answers  


SQL*Loader-00103: Invalid log file name on command line

1 Answers  


ORA-16035: missing required keyword string

1 Answers  


SQL*Loader-00562: record too big

1 Answers  


Categories