ORA-01135: file string accessed for DML/query is offline

Oracle error

ORA-01135: file string accessed for DML/query is offline

Cause: Attempted to access a data file that is offline

Action: Bring the data file back online

See more oracle error here.

Oracle error- ORA-00840: PGA_AGGREGATE_TARGET cannot be modified to the specified value

Oracle error

ORA-00840: PGA_AGGREGATE_TARGET cannot be modified to the specified value

Cause: The specified value of PGA_AGGREGATE_TARGET was not compatible with current settings of SGA_TARGET and MEMORY_TARGET/MEMORY_MAX_TARGET.

Action: Set PGA_AGGREGATE_TARGET to be no more than the difference of MEMORY_TARGET/MEMORY_MAX_TARGET and SGA_TARGET.

See more oracle error here.

ORA-01129: user's default or temporary tablespace does not exist

Oracle error

ORA-01129: user's default or temporary tablespace does not exist

Cause: The user's default or temporary tablespace was dropped.

Action: Reassign the default or temporary tablespace.

See more oracle error here.