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-16624: broker protocol version mismatch detected

1 Answers  


NNL-00282: Cancelled restart

1 Answers  


ORA-16073: archiving must be enabled

1 Answers  


ORA-27017: skgfcls: media handle returned by sbtinfo exceeds max length(SSTMXQMH)

1 Answers  


ORA-26716: message limit reached

1 Answers  


ORA-14521: Default tablespace string block size [string] for string string does not match existing string block size [string]

1 Answers  


SQL*Loader-00608: subpartition not empty for INSERT option; table string, subpartition string

1 Answers  


NNC-00426: no such data type

1 Answers  


ORA-13036: Operation [string] not supported for Point Data

1 Answers  


ORA-00097: use of Oracle SQL feature not in SQL92 string Level

1 Answers  


SQL*Loader-00703: Internal error: argument number

1 Answers  


PLS-00259: rights model (AUTHID) must be specified

1 Answers  


Categories