SAS/ACCESS Interface to Oracle supports temporary tables. For more information, see Temporary Table Support for SAS/ACCESS.