My Oracle Support Banner

Data Extract View Job Fails with Ora-12911 Creating User (Doc ID 269086.1)

Last updated on FEBRUARY 21, 2023

Applies to:

Oracle Clinical - Version 4.5.1 and later
Information in this document applies to any platform.


Data Extract Views job ends with FAILURE status. The log file of the job shows the following error messages:

Executed command: rmdir /s /q d:\opapps\sas_view\ocdev\av018\24feb2004
Default table space for DX_VIEW_TABLESPACE USERS
Error creating user <USER>$24FEB2004
ORA-12911: permanent tablespace cannot be temporary tablespace
ERR level 1
Unable to create account.
ERR level 1
Error when calling create_account





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.