Data Set Options for Oracle

All SAS/ACCESS data set options in this table are supported for Oracle. Default values are provided where applicable. For details, see Data Set Options for Relational Databases.

SAS/ACCESS Data Set Options for Oracle
Option	Default Value
BL_BADFILE=	creates a file in the temporary file directory as specified in the SAS UTILLOC= system option1 or with the default file specifications.
BL_API_BULKLOAD=	NO
BL_CONTROL=	creates a file in the temporary file directory as specified in the SAS UTILLOC= system option1 or with the default file specifications.
BL_DATAFILE=	creates a file in the temporary file directory as specified in the SAS UTILLOC= system option1 or with the default file specifications.
BL_DEFAULT_DIR=	<database-name>
BL_DELETE_DATAFILE=	YES
BL_DELETE_ONLY_DATAFILE=	none
BL_DIRECT_PATH=	YES
BL_DISCARDFILE=	creates a file in the temporary file directory as specified in the SAS UTILLOC= system option1 or with the default file specifications.
BL_INDEX_OPTIONS=	none
BL_LOAD_METHOD=	When loading an empty table, the default value is INSERT. When loading a table that contains data, the default value is APPEND.
BL_LOG=	If a log file does not already exist, it creates a file in the temporary file directory as specified in the SAS UTILLOC= system option1 or with the default file specifications. If a log file does already exist, the Oracle bulk loader reuses the file, replacing the contents with information from the new load.
BL_OPTIONS=	ERRORS=1000000
BL_PARFILE=	none
BL_PRESERVE_BLANKS=	NO
BL_RECOVERABLE=	YES
BL_RETURN_WARNINGS_AS_ERRORS=	NO
BL_SUPPRESS_NULLIF=	NO
BL_USE_PIPE=	NO
BULKLOAD=	NO
DBCOMMIT=	LIBNAME option value
DB_ONE_CONNECT_PER_THREAD=	YES
DBCONDITION=	none
DBCREATE_TABLE_OPTS=	LIBNAME option value
DBFORCE=	NO
DBGEN_NAME=	DBMS
DBINDEX=	LIBNAME option value
DBKEY=	none
DBLABEL=	NO
DBLINK=	LIBNAME option value
DBLARGETABLE=	none
DBMAX_TEXT=	1024
DBNULL=	YES
DBNULLKEYS=	LIBNAME option value
DBNULLWHERE=	LIBNAME option value
DBPROMPT=	LIBNAME option value
DBSASLABEL=	COMPAT
DBSASTYPE=	see Data Types for Oracle
DBSLICE=	none
DBSLICEPARM=	THREADED_APPS,2
DBTYPE=	see LIBNAME Statement Data Conversions
ERRLIMIT=	1
INSERTBUFF=	LIBNAME option value
NULLCHAR=	SAS
NULLCHARVAL=	a blank character
OR_IDENTITY_COLS=	none
OR_PARTITION=	an Oracle table partition name
OR_UPD_NOWHERE=	LIBNAME option value
ORHINTS=	no hints
POST_DML_STMT_OPTS=	none
POST_STMT_OPTS=	none
POST_TABLE_OPTS=	none
PRE_STMT_OPTS=	none
PRE_TABLE_OPTS=	none
PRESERVE_COL_NAMES=	LIBNAME option value
READ_ISOLATION_LEVEL=	LIBNAME option value
READ_LOCK_TYPE=	LIBNAME option value
READBUFF=	LIBNAME option value
SASDATEFORMAT=	DATETIME20.0
SCHEMA=	LIBNAME option value
UPDATE_ISOLATION_LEVEL=	LIBNAME option value
UPDATE_LOCK_TYPE=	LIBNAME option value
UPDATEBUFF=	LIBNAME option value
1 For details, see SAS System Options: Reference.

Last updated: February 3, 2026