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-01333: failed to establish Logminer Dictionary

1 Answers  


PLS-00623: FLOAT precision constraint must be between 1 and 126

1 Answers  


ORA-13367: wrong orientation for interior/exterior rings

1 Answers  


ORA-25305: enqueue failed, expiration must be zero for queue string.string

1 Answers  


ORA-35280: (SNSYN165) The format of the AGGREGATE command is: AGGREGATE varname1 [varname2 varname3 ...] USING aggmap-name [COUNTVAR intvar-name1 [intvar-name2 intvar-name3 ...]] [FUNCDATA] [THREADS #]

1 Answers  






ORA-16014: log string sequence# string not archived, no available destinations

1 Answers  


ORA-36740: A CHILDLOCK was detected in your valueset

1 Answers  


ORA-39090: Cannot add devices to file oriented job.

1 Answers  


ORA-16078: media recovery disabled

1 Answers  


RMAN-08551: recovering datafilecopy fno=string name=string

1 Answers  


NZE-29011: Finished message is incorrect.

1 Answers  


ORA-33920: (MAKEDCL34) The string SURROGATE must have one of the following data types: ID, NTEXT, TEXT, NUMBER, or INTEGER.

1 Answers  


Categories