Tag: Oracle

Community

Oracle on Windows

(Steve Callan) Microsoft takes a beating at times from frustrated users of its own products and from users of third party products hosted on Windows. When it comes to using Oracle on Windows, it seems that a frequently appearing solution to problems is to reboot the PC. In reality, rebooting is nece

Community

Using Oracle’s Time Zone Feature

(James F. Koopmann) A few articles back I wrote on a comparison between the DATE datatype and the TIMESTAMP datatype. This article goes one step further and explores Oracle’s TIME ZONE feature of the TIMESTAMP datatype. In particular, Oracle has added the "WITH TIME ZONE" and the "WITH LOCAL TIME ZO

Community

Safety in Numbers

(Shari Caudron) Every hour of every day, in countries all around the world, people work in hazardous environments. They dive deep below the surface of the ocean on salvage expeditions. They descend into mines, clean toxic waste, and fight fires—or try to prevent them. These people know their jobs ar

Community

Cloning a Oracle Database

Cloning a database means creating an identical copy of a database, either on the same machine as the original, or on a different one. Additonally, it means changing the database name, and the Instance name. But those are both optional steps if the clone is being created on a different machine. Ev