Support Center
Explore, Analyze & Document your Code

Oracle Deprecated and Desupported Features

Why this article?

Each new Oracle release brings its set of deprecated or unsupported features. When you upgrade from one version to another, it's difficult to list all the functions or types that have become obsolete, and then check that they are no longer used in your database (see our Oracle Migration Guide).

This article compiles the deprecated features for each version since Oracle 18.

Oracle 18c

Oracle 18c Deprecated Features

  • Extended Datatype Support (EDS) is deprecated from the DBMS_LOGSTDBY package. All EDS-supported Oracle data types are now supported natively by logical standbys or Oracle GoldenGate.
  • DBMS_LOCK.SLEEP procedure is deprecated.
    Use DBMS_SESSION.SLEEP instead
  • *GET_MODEL_DETAILS functions are deprecated.
    • Deprecated subprogram
      • GET_ASSOCIATION_RULES Function
      • GET_FREQUENT_ITEMSETS Function
      • GET_MODEL_DETAILS_AI Function
      • GET_MODEL_DETAILS_EM Function
      • GET_MODEL_DETAILS_EM_COMP Function
      • GET_MODEL_DETAILS_EM_PROJ Function
      • GET_MODEL_DETAILS_GLM Function
      • GET_MODEL_DETAILS_GLOBAL Function
      • GET_MODEL_DETAILS_KM Function
      • GET_MODEL_DETAILS_NB Function
      • GET_MODEL_DETAILS_NMF Function
      • GET_MODEL_DETAILS_OC Function
      • GET_MODEL_SETTINGS Function
      • GET_MODEL_SIGNATURE Function
      • GET_MODEL_DETAILS_SVD Function
      • GET_MODEL_DETAILS_SVM Function
      • GET_MODEL_TRANSFORMATIONS Function
      • GET_MODEL_DETAILS_XML Function
      • GET_TRANSFORM_LIST Procedure
    • Deprecated Datatype
      • DM_CENTROID
      • DM_CENTROIDS
      • DM_CHILD
      • DM_CHILDREN
      • DM_CLUSTER
      • DM_CLUSTERS
      • DM_CONDITIONAL
      • DM_CONDITIONALS
      • DM_COST_ELEMENT
      • DM_COST_MATRIX
      • DM_EM_COMPONENT
      • DM_EM_COMPONENT_SET
      • DM_EM_PROJECTION
      • DM_EM_PROJECTION_SET
      • DM_GLM_COEFF
      • DM_GLM_COEFF_SET
      • DM_HISTOGRAM_BIN
      • DM_HISTOGRAMS
      • DM_ITEM
      • DM_ITEMS
      • DM_ITEMSET
      • DM_ITEMSETS
      • DM_MODEL_GLOBAL_DETAIL
      • DM_MODEL_GLOBAL_DETAILS
      • DM_NB_DETAIL
      • DM_NB_DETAILS
      • DM_NMF_ATTRIBUTE
      • DM_NMF_ATTRIBUTE_SET
      • DM_NMF_FEATURE
      • DM_NMF_FEATURE_SET
      • DM_PREDICATE
      • DM_PREDICATES
      • DM_RANKED_ATTRIBUTE
      • DM_RANKED_ATTRIBUTES
      • DM_RULE
      • DM_RULES
      • DM_SVD_MATRIX
      • DM_SVD_MATRIX_SET
      • DM_SVM_ATTRIBUTE
      • DM_SVM_ATTRIBUTE_SET
      • DM_SVM_LINEAR_COEFF
      • DM_SVM_LINEAR_COEFF_SET
      • DM_TRANSFORM
      • DM_TRANSFORMS

    Use: Model Detail Views instead.

  • DBMS_XMLQUERY package is deprecated.
    Use: DBMS_XMLGEN
  • DBMS_XMLSAVE package is deprecated. : VEPLSQLRULE197
    Use: DBMS_XMLSTORE
    • ORD_AUDIO
    • ORD_DOC
    • ORD_IMAGE
    • ORD_VIDEO
    • Oracle Multimedia ORDAudio
    • Oracle Multimedia ORDDoc
    • Oracle Multimedia ORDImage
    • Oracle Multimedia ORDVideo
    Use: Oracle SecureFiles with third-party tools.

Oracle 18c Desupported Features

  • The following subprograms are desupported from DBMS_XDB package
    • ADDHTTPEXPIREMAPPING
    • ADDMIMEMAPPING
    • ADDSCHEMALOCMAPPING
    • ADDSERVLETMAPPING
    • ADDSERVLETSECROLE
    • ADDXMLEXTENSION
    • CFG_GET
    • CFG_REFRESH
    • CFG_UPDATE
    • DELETEHTTPEXPIREMAPPING
    • DELETEMIMEMAPPING
    • DELETESCHEMALOCMAPPING
    • DELETESERVLET
    • DELETESERVLETMAPPING
    • DELETESERVLETSECROLE
    • DELETEXMLEXTENSION
    • GETFTPPORT
    • GETHTTPPORT
    • GETLISTENERENDPOINT
    • SETFTPPORT
    • SETHTTPPORT
    • SETLISTENERENDPOINT
    • SETLISTENERLOCALACCESS
    Use: DBMS_XDB_CONFIG
  • UTL_FILE_DIR initialization parameter is desupported from the DBMS_LOGMNR_D package: 
    Use Directory object
  • Constants desupported from DBMS_XDB package
    • XDB_ENDPOINT_HTTP
    • XDB_ENDPOINT_HTTP2
    • XDB_PROTOCOL_TCP
    • XDB_PROTOCOL_TCPS
    Use: DBMS_XDB_CONFIG
  • Subprograms GENERATESCHEMA and GENERATESCHEMAS from DBMS_XMLSCHEMA package
    Note: No replacements
  • DBMS_XMLTRANSLATIONS package is desupported
    Note: No replacement

Oracle 19c

Oracle 19c Deprecated Features

  • DBMS_SESSION.IS_ROLE_ENABLED function is deprecated : VEPLSQLRULE205
    Use DBMS_SESSION.CURRENT_IS_ROLE_ENABLED or SESSION_IS_ROLE_ENABLED
  • SERVICE_NAMES parameter is deprecated
    Use: SRVCTL or GDSCTL command line utilities or DBMS_SERVICE package
  • RECOVER…SNAPSHOT TIME method of recovering a database to a point in time using a particular snapshot is deprecated
    Use: ALTER DATABASE BEGIN/END BACKUP and RECOVER .. UNTIL TIME
    Preferred: Use RMAN

Oracle 19c Desupported Features

  • Flat file dictionary dumps of PDBs
    Use: DBMS_LOGMNR.START_LOGMNR with SCN/time
  • CONTINUOUS_MINE option in the DBMS_LOGMNR.START_LOGMNR package
  • Oracle Streams DBMS_STREAMS_ADM package desupported: VEPLSQLRULE206
    Use: Oracle GoldenGate
  • Oracle Multimedia: VEPLSQLRULE201
    Use: Oracle SecureFiles + open source or third-party tools
  • MAX_CONNECTIONS attribute of LOG_ARCHIVE_DEST_n Desupported
    Note: Removed to support streaming mechanism
  • Extended Datatype Support (EDS)
    Note: Now natively supported
  • O7_DICTIONARY_ACCESSIBILITY initialization parameter
    Note: Removed for enhanced security

Oracle 21c

Oracle 21c Deprecated Features

  • Oracle Wallet Manager (OWM)
    Use: orapki, mkstore
  • SHA-1 usage in SQLNET and DBMS_CRYPTO
  • MD5 and MD4 algorithms
  • Oracle Enterprise Manager Database Express (EM Express)

Oracle 21c Desupported Features

  • Multitenant-only architecture — only CDBs supported
  • DBMS_XMLSAVE
  • DBMS_XMLQUERY
  • DBMS_CRYPTO — algorithms MD4, MD5, RC4 are removed : VEPLSQLRULE137
  • XML DB related changes:
    • Package: DBMS_XDBT
    • Procedures: DBMS_XSLPROCESSOR.CLOB2FILE, DBMS_XSLPROCESSOR.READ2CLOB
      Use: DBMS_LOB.CLOB2FILE, DBMS_LOB.LOADCLOBFROMFILE
  • Large Object (LOB) features DBMS_LOB.LOADFROMFILE & LOB Buffering (BUFFERING_ENABLED) is desupported
    Use: DBMS_LOB.LoadClobFromFile, DBMS_LOB.LoadBlobFromFile
  • DBMS_OBFUSCATION_TOOLKIT — removed
    Use: DBMS_CRYPTO
  • Flat file dictionary dumps of PDBs
    Use:DBMS_LOGMNR.START_LOGMNR
  • OPTIMIZE_PROGRESS_TABLE parameter from DBMS_APPLY_ADM.SET_PARAMETER procedure

Oracle 23ai

Oracle 23ai Deprecated Features

  • mkstore tool
    Use: orapki
  • DBMS_RESULT_CACHE function renaming: VEPLSQLRULE210
    • BLACK_LIST function. Use BLOCK_LIST function.
    • BLACK_LIST_ADD procedure. Use BLOCK_LIST_ADD procedure.
    • BLACK_LIST_CLEAR procedure. Use BLOCK_LIST_CLEAR procedure
    • BLACK_LIST_REMOVE procedure. Use BLOCK_LIST_REMOVE procedure
    • OBJECT_BLACK_LIST function. Use OBJECT_BLOCK_LIST function
    • OBJECT_BLACK_LIST_ADD procedure. Use OBJECT_BLOCK_LIST_ADD procedure.
    • OBJECT_BLACK_LIST_CLEAR procedure. Use OBJECT BLOCK LIST_CLEAR procedure.
    • OBJECT_BLACK_LIST_REMOVE procedure. Use OBJECT_BLOCK_LIST_REMOVE procedure.
  • DBMS_XMLSTORE VEPLSQLRULE211
    Use: SQL DML and with standard XQuery and SQL/XML to store and manage XML data
  • DBMS_XMLGEN VEPLSQLRULE212
    Use: SQL/XML operators
  • XML DB Repository and all related interfaces (e.g., oracle.xdb.servlet, oracle.xdb.event, and oracle.xdb.spi)
  • DBMS_HANG_MANAGER : VEPLSQLRULE213
    Use: DBMS_BLOCKER_RESOLVER
  • Traditional auditing packages/functions: VEPLSQLRULE215
    • INIT_CLEANUP, DEINIT_CLEANUP, IS_CLEANUP_INITIALIZED
  • Oracle OLAP (OLAP DML, Java API, Analytic Workspaces)
    Use: Oracle Analytic Views or Oracle Essbase

Oracle 23ai Desupported Features

  • Oracle Enterprise Manager Database Express (EM Express)
    Use: OCI DB Management, Cloud Control, or SQL Developer
  • service attribute values SESSION_STATE_CONSISTENCY = STATIC with FAILOVER_TYPE = TRANSACTION
    Use:
    • FAILOVER_TYPE = AUTO, SESSION_STATE_CONSISTENCY = AUTO
    • FAILOVER_TYPE = TRANSACTION, SESSION_STATE_CONSISTENCY = DYNAMIC
  • Oracle Wallet Manager (OWM)
    Use: orapki command line tool

More from Code Review features in Visual Expert

Oracle Deprecated Features, Code Cleanup, Code Quality, Code Maintenance, Visual Expert

Visual Expert Featured Resources


Videos