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

PLS-00402: alias required in SELECT list of cursor to avoid duplicate column names

2 Answers  


DRG-52109: error in reading thesaurus

1 Answers  


ORA-00823: Specified value of sga_target greater than sga_max_size

1 Answers  


ORA-02094: replication option not installed

1 Answers  


QSM-02144: aggregate functions are present without a GROUP BY clause

1 Answers  


RMAN-06054: media recovery requesting unknown log: thread string seq string lowscn string

1 Answers  


LPX-00005: ~1s buffer overflow, maximum size is ~2u bytes

1 Answers  


ORA-09859: sfngat: the input file name is not in the autobackup OMF format

1 Answers  


ORA-01614: instance string (thread string) is busy - cannot enable

1 Answers  


IMG-00843: internal image structure allocation failed

1 Answers  


ORA-25293: Remote Recipient Subsribers and buffered operations not possible for Queue string

1 Answers  


ORA-15068: maximum number of diskgroups string already mounted

1 Answers  


Categories