ORA-14461: cannot REUSE STORAGE on a temporary table TRUNCATE

Cause : REUSE STORAGE was specified with TRUNCATE on a temporary table. This is unsupported as it is meaningless.

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

Specify DROP STORAGE instead (which is the default).

update : 17-08-2017

ORA-14461 - cannot REUSE STORAGE on a temporary table TRUNCATE
ORA-14461 - cannot REUSE STORAGE on a temporary table TRUNCATE

  • ora-32642 : non-unique cell values from the ORDER BY clause
  • ora-29286 : internal error
  • ora-25193 : cannot use COMPRESS option for a single column key
  • ora-19101 : CONTENT keyword expected
  • ora-12342 : open mounts exceeds limit set on the OPEN_MOUNTS parameter
  • ora-03123 : operation would block
  • ora-27120 : unable to removed shared memory segment
  • ora-01027 : bind variables not allowed for data definition operations
  • ora-04098 : trigger 'string.string' is invalid and failed re-validation
  • ora-09921 : Unable to get information label from connection
  • ora-32767 : No server connection for this operation
  • ora-01924 : role 'string' not granted or does not exist
  • ora-29878 : warning in the execution of ODCIINDEXTRUNCATE routine
  • ora-39171 : Job is experiencing a resumable wait. string
  • ora-01546 : tablespace contains active rollback segment 'string'
  • ora-14096 : tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns
  • ora-14122 : only one REVERSE or NOREVERSE clause may be specified
  • ora-15151 : missing or invalid version number for rolling upgrade or downgrade
  • ora-19282 : XQ0068 - It is a static error if a Prolog contains more than one xmlspace declaration
  • ora-38959 : Failed to update block 0 to new version 10 format
  • ora-39046 : Metadata remap string has already been specified.
  • ora-31465 : cannot obtain a lock on the subscription
  • ora-39218 : type check on object type "string"."string" failed
  • ora-06114 : NETTCP: SID lookup failure
  • ora-00832 : no streams pool created and cannot automatically create one
  • ora-00234 : error in identifying or opening snapshot or copy control file
  • ora-06545 : PL/SQL: compilation error - compilation aborted
  • ora-09979 : skxfqhsnd: Error Sending a message to another endpoint
  • ora-14152 : invalid number of partitions specified in PARTITIONS clause
  • ora-00371 : not enough shared pool memory, should be atleast string bytes
  • 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.