A local temp table is only available to the session that creates it, while a global temp table is available across multiple sessions. Global temp tables are denoted by a '##' prefix, as opposed to the '#' prefix for local temp tables.