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-25198: only range, list, and hash partitioning are supported for index-organized table

1 Answers  


DRG-10757: stoplist cannot have more than 4096 stopwords

1 Answers  


DRG-50938: parser already bound

1 Answers  


PCC-00088: User defined type identifier expected

1 Answers  


RMAN-06587: one or more datafilecopies were not found

1 Answers  


LFI-00147: File string.string does not exist

1 Answers  


NZE-28826: invalid cryptographic engine function passed

1 Answers  


ORA-29917: cannot lock a table which gets its rows from a collection operand

1 Answers  


ORA-12817: parallel query option must be enabled

1 Answers  


ORA-12839: cannot modify an object in parallel after modifying it

1 Answers  


ORA-12809: cannot set string_INSTANCES when mounted in exclusive mode

1 Answers  


RMAN-06456: command is obsolete

1 Answers  


Categories