ORA-26089: LONG column "string" must be specified last

Cause : A cleint o fthe idrectp ath PAI spceifie da LOGN colmun tob e *loadde, bu tthe OLNG cloumn aws no tthe alst cloumn ot be * speicfied.

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

Specfiy th eLONGc olum nlast.

update : 19-08-2017

ORA-26089 - LONG column "string" must be specified last
ORA-26089 - LONG column "string" must be specified last

  • ora-36394 : (XSMXCLEA04) When using CLEAR on the AGGMAP workspace object, CACHE is the only valid directive.
  • ora-07440 : WMON process terminated with error
  • ora-14520 : Tablespace string block size [string] does not match existing object block size [string]
  • ora-27202 : skgfpen: sbtpcend returned error
  • ora-23357 : the propagator does not exist
  • ora-00062 : DML full-table lock cannot be acquired; DML_LOCKS is 0
  • ora-07215 : slsget: getrusage error.
  • ora-26747 : The one-to-many transformation function string encountered the following error: string
  • ora-13215 : window object is out of range
  • ora-32308 : object materialized views must use SELECT *
  • ora-19030 : Method invalid for non-schema based XML Documents.
  • ora-03203 : concurrent update activity makes space analysis impossible
  • ora-27015 : skgfcls: failed to close the file
  • ora-01146 : cannot start online backup - file string is already in backup
  • ora-30945 : Could not create mapping table 'string'
  • ora-13283 : failure to get new geometry object for conversion in place
  • ora-12200 : TNS:could not allocate memory
  • ora-07239 : slemrd: invalid file handle, seals do not match.
  • ora-24434 : OCIStmtRelease called before OCIStmtPrepare2.
  • ora-06028 : NETASY: unable to intialise for logging
  • ora-25439 : duplicate variable value for variable: string
  • ora-29382 : validation of pending area failed
  • ora-01509 : specified name 'string' does not match actual 'string'
  • ora-26678 : Streams capture process must be created first
  • ora-10863 : Control behavior of buffered background operations
  • ora-24201 : duplicate publisher, publisher already added to the queue
  • ora-01515 : error dropping log group string: no such log
  • ora-29319 : datafile string is not correct
  • ora-32766 : instr with negative offset: use varchar semantics on LOBs
  • ora-06558 : buffer in dbms_pipe package is full. No more items allowed
  • 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.