ORA-31679: Table data object string has long columns, and longs can not be loaded/unloaded using a network link

Cause : aTlb eadato jbcestt ah toctnia nolgnc lomusnc nan tob eeseltcdeo ev r aenwtro kilkn.

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

xEoptrt ih satlb eota f li ena dhtnei pmro tht easemt baelf or mht eifel.

update : 22-07-2017
ORA-31679

ORA-31679 - Table data object string has long columns, and longs can not be loaded/unloaded using a network link
ORA-31679 - Table data object string has long columns, and longs can not be loaded/unloaded using a network link

  • ora-22861 : invalid user-defined type
  • ora-09209 : sftget: error reading from file
  • ora-02778 : Name given for the log directory is invalid
  • ora-24096 : invalid message state specified
  • ora-12022 : materialized view log on "string"."string" already has rowid
  • ora-08322 : scnmin: open/convert of bias lock failed
  • ora-00033 : current session has empty migration password
  • ora-16703 : cannot set property while the database is enabled
  • ora-33036 : (XSAGDNGL17) ARGS option workspace object must be a TEXT variable.
  • ora-13121 : layer type type mismatch with topo_geometry layer type
  • ora-13915 : Critical byte based free space threshold value is greater than warning threshold value.
  • ora-33448 : (ESDREAD04) Discarding compiled code for workspace object because number now has string data, whereas it had string data when the code was compiled.
  • ora-15044 : ASM disk 'string' is incorrectly named
  • ora-19715 : invalid format string for generated name
  • ora-16042 : user requested cancel immediate of managed recovery operation
  • ora-12500 : TNS:listener failed to start a dedicated server process
  • ora-01224 : group number in header string does not match GROUP string
  • ora-07209 : sfofi: file size limit was exceeded.
  • ora-27418 : syntax error in repeat interval or calendar
  • ora-12419 : null binary label value
  • ora-38404 : schema extension not allowed for the attribute set name
  • ora-23615 : Block number string does not exist for script string
  • ora-37086 : %s is not a valueset
  • ora-27066 : number of buffers in vector I/O exceeds maximum
  • ora-03292 : Table to be truncated is part of a cluster
  • ora-19706 : invalid SCN
  • ora-16643 : unable to determine location of broker configuration files
  • ora-40214 : duplicate setting: string
  • ora-14115 : partition bound of partition number string is too long
  • ora-38782 : cannot flashback database to non-guaranteed restore point 'string'
  • 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.