When I delete a field (on the user entity) i get an error like this. Note the missing " s

    Database error cycle starting with error: SQLSTATE[HY000]: General error: 2243 OCIStmtExecute: ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option
     (/patched-php-src-5.3.9RC3/php-5.3.9RC3/ext/pdo_oci/oci_statement.c:148)

    Rollback failed with error: 

    error query: ALTER INDEX {L#1375_L} RENAME TO "L#1375_L" (prepared: ALTER INDEX DRUPAL"."L#1375_L RENAME TO "L#1375_L" ) e: SQLSTATE[HY000]: General error: 2243 OCIStmtExecute: ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option
     (/patched-php-src-5.3.9RC3/php-5.3.9RC3/ext/pdo_oci/oci_statement.c:148) args: Array
    (
    )


Error message
PDOException: ALTER INDEX {L#1375_L} RENAME TO "L#1375_L" (prepared: ALTER INDEX DRUPAL"."L#1375_L RENAME TO "L#1375_L" ) e: SQLSTATE[HY000]: General error: 2243 OCIStmtExecute: ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option (/patched-php-src-5.3.9RC3/php-5.3.9RC3/ext/pdo_oci/oci_statement.c:148) args: Array ( ) in db_rename_table() (line 2777 of /var/www/html/project/includes/database/database.inc).
The website encountered an unexpected error. Please try again later.

Comments

aaaristo’s picture

aaaristo commented
Status: Active » Postponed (maintainer needs more info)

Which versions are you using?

Which kind of field are you using?

Have you patched somehow the driver?

I've just tried on a fresh install drupal 7.23 and oracle 1.12 and works fine.. Adding a new content type "test", adding a new field "test1" type text and removing it,
is not throwing any error

batje’s picture

batje commented
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

Indeed, we changed so much. Let's close this.