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

RMAN-06559: MAXSIZE must be larger than 1 kb

1 Answers  


TNS-00304: Status Information for Connection Manager:

1 Answers  


ORA-30679: JDWP-based debugging not supported in this configuration

1 Answers  


SQL-02118: Invalid row for a WHERE CURRENT OF operation

1 Answers  


ORA-24039: Queue string not created in queue table for multiple consumers

1 Answers  






NNL-00851: Renames refused, name is not a leaf name: number

1 Answers  


ORA-23312: not the masterdef according to string

1 Answers  


ORA-04084: cannot change NEW values for this trigger type

1 Answers  


KUP-04030: invalid numeric data

1 Answers  


ORA-27073: Trying to close a file which has async I/Os pending to be dequeued

1 Answers  


TNS-01174: The sum of the POOL_SIZEs from each PRESPAWN_DESC is greater than the PRESPAWN_MAX

1 Answers  


PCC-02306: illegal name of C function

1 Answers  


Categories