ORA-30079: cannot alter database timezone when database has
TIMESTAMP WITH LOCAL TIME ZONE columns



ORA-30079: cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE columns..

Answer / guest

Cause: An attempt was made to alter database timezone with
TIMESTAMP WITH LOCAL TIME ZONE column in the database.

Action: Either do not alter database timezone or first drop
all the TIMESTAMP WITH LOCAL TIME ZONE columns.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-22807: cannot resolve to a scalar type or a collection type

1 Answers  


ORA-09984: SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf does not exist

1 Answers  


ORA-31509: publication does not exist

1 Answers  


RMAN-08117: channel string: the autobackup does not contain an SPFILE

1 Answers  


ORA-30506: system triggers cannot be based on tables or views

1 Answers  






NNL-00580: register_ns: <name server> <address> <domain>

1 Answers  


PLS-00736: user-declared operators are not allowed

1 Answers  


ORA-31500: change source string is not a ManualLog change source

1 Answers  


ORA-39134: Cannot include "string" tablespace as a Transportable Tablespace

1 Answers  


ORA-23365: site string does not exist

1 Answers  


ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

1 Answers  


ORA-33066: (XSAGDNGL32) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must be a hierarchy dimension of the relation.

1 Answers  


Categories