Oracle Database Discussions

Hi,

I need to upgrade timezone version from 2 to 4. Kindly suggest.

Os:- Windows 32 bit




SQL> select version from v$timezone_file;

VERSION
----------
2

Steps taken,

exec dbms_dst.begin_upgrade(11);

While apply this command , I am getting following error.


##################################################




SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup upgrade;
ORACLE instance started.

Total System Global Area 629145600 bytes
Fixed Size 1250572 bytes
Variable Size 209718004 bytes
Database Buffers 385875968 bytes
Redo Buffers 32301056 bytes
Database mounted.
Database opened.
SQL>
SQL> exec dbms_dst.begin_upgrade(4);
BEGIN dbms_dst.begin_upgrade(4); END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_DST.BEGIN_UPGRADE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

#################################################



Thanks,
Ramesh