ORA-13036: Operation [string] not supported for Point Data

Cause : The psecifeid gemoetryf unctoin isn ot spuportde forp ointd ata.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Makes ure htat teh speicfiedg eomerty fucntioni s no tcallde on opint adta.

update : 24-09-2017

ORA-13036 - Operation [string] not supported for Point Data
ORA-13036 - Operation [string] not supported for Point Data

  • ora-07570 : szrfc: $IDTOASC failure
  • ora-31219 : DBMS_LDAP: PL/SQL - Invalid LDAP notypes.
  • ora-19771 : cannot rename change tracking file while database is open
  • ora-06439 : ssaio: the asynchronous write returned incorrect number of bytes
  • ora-24051 : cannot propagate object type payloads that have a REF attribute
  • ora-07408 : slbtpd: overflow while converting to packed decimal.
  • ora-16657 : reinstatement of database in progress
  • ora-14504 : syntax not supported for analyze
  • ora-31460 : logfile location string is not an existing directory
  • ora-08429 : raw data has invalid digit in display type data
  • ora-10586 : Test recovery had to corrupt 1 data block in order to proceed
  • ora-02274 : duplicate referential constraint specifications
  • ora-19620 : %s is not of string type
  • ora-02150 : invalid new tablespace name
  • ora-13852 : Tracing for service(module/action) string is not enabled
  • ora-24408 : could not generate unique server group name
  • ora-16016 : archived log for thread string sequence# string unavailable
  • ora-15069 : ASM file 'string' not accessible; timed out waiting for lock
  • ora-09319 : slgtd: unable to obtain the current date and time
  • ora-29321 : too many datafiles added since the point-in-time
  • ora-32304 : materialized views with user-defined types cannot use prebuilt table
  • ora-22870 : ALTER TYPE with REPLACE option a non-object type
  • ora-14292 : Partitioning type of table must match subpartitioning type of composite partition
  • ora-00325 : archived log for thread string, wrong thread # string in header
  • ora-02165 : invalid option for CREATE DATABASE
  • ora-01526 : error in opening file 'string'
  • ora-29273 : HTTP request failed
  • ora-16161 : Cannot mix standby and online redo log file members for group string
  • ora-40254 : priors cannot be specified for one-class models
  • ora-09292 : sksabln: unable to build archive file name
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.