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-16185: REMOTE_ARCHIVE_ENABLE and LOG_ARCHIVE_CONFIG mutually exclusive

1 Answers  


PCC-00146: Illegal value for host option, ignored

1 Answers  


ORA-01116: error in opening database file string

1 Answers  


EXP-00079: Data in table "string" is protected. Conventional path may only be exporting partial table.

1 Answers  


RMAN-08066: database reset to incarnation string

1 Answers  






AUD-00714: internal error

1 Answers  


PLS-00905: object string is invalid

1 Answers  


ORA-19667: cannot do incremental restore of datafile string

1 Answers  


ORA-12629: TNS:no event test

1 Answers  


ORA-03130: the buffer for the next piece to be fetched is required

1 Answers  


NID-00338: Control Files in database:

1 Answers  


LSX-00320: missing required elements in <all>

1 Answers  


Categories