ORA-12994: drop column option only allowed once in statement

Cause : An attemptw as mdae tor epea tthe rdop cloumn potioni n a isngles tateemnt.

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

Sepaarte dorp coulmn otpionsi nto idffernet sttaemenst andr esubimt sttaemenst.

update : 25-04-2017
ORA-12994

ORA-12994 - drop column option only allowed once in statement
ORA-12994 - drop column option only allowed once in statement

  • ora-16018 : cannot use string with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST
  • ora-24005 : must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables
  • ora-08315 : sllfrb: Error reading file
  • ora-10585 : Test recovery can not apply redo that may modify control file
  • ora-12854 : Parallel query is not supported on temporary LOBs
  • ora-36162 : (XSMXAGGR05) COUNTVAR variable workspace object must be of type INTEGER, not string.
  • ora-16503 : site ID allocation failure
  • ora-31523 : could not find change source string for CDC change set string
  • ora-06003 : NETASY: port write failure
  • ora-39001 : invalid argument value
  • ora-36223 : (XSLPDSC04) object workspace object in IGNORE or DENSE list has illegal type
  • ora-16558 : the database specified for switchover is not a standby database
  • ora-31691 : The worker received message number string from the MCP, which is invalid.
  • ora-26678 : Streams capture process must be created first
  • ora-38401 : synonym string not allowed
  • ora-22130 : buffer size [string] is less than the required size [string]
  • ora-16025 : parameter string contains repeated or conflicting attributes
  • ora-29822 : selectivity cannot be specified for the type of object
  • ora-12831 : Must COMMIT or ROLLBACK after executing INSERT with APPEND hint
  • ora-30073 : invalid adjustment value
  • ora-28029 : could not authorize remote server for user string
  • ora-01169 : DATAFILE number 1 not found. Must be present
  • ora-27365 : job has been notified to stop, but failed to do so immediately
  • ora-13864 : Statistics aggregation for service (module/action) string is already enabled
  • ora-13526 : baseline (string) does not exist
  • ora-23415 : materialized view log for "string"."string" does not record the primary key
  • ora-29869 : cannot issue ALTER without REBUILD on a domain index marked FAILED
  • ora-14185 : incorrect physical attribute specified for this index partition
  • ora-00061 : another instance has a different DML_LOCKS setting
  • ora-30379 : query txt not specified
  • 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.