Specifying the Database Time Zone File

All databases that share information must use the same time zone data file.

qa testing training courses malaysia

The database server always uses the large time zone file by default.

software development training courses malaysia

To use the small time zone file on the client and know that all your data will refer only to regions in the small file:

• Set the ORA_TZFILE environment variable on the client to the full path name of the timezone version.dat file on the client, where version matches the time zone file version that is being used by the database server.

it security training courses malaysia

If you are already using the default larger time zone file on the client, then it is not practical to change to the smaller time zone file, because the database may contain data with time zones that are not part of the smaller file.

networking training courses malaysia