Have you tried a SELECT query against your materialized view to make sure there isn't a permissions problem with the view or one of the underlying tables?
-dpf- ----------------------- David P. Fannin Database Administrator [EMAIL PROTECTED] UM-Rolla Computing and Information Services FAX (573) 341-4216 URL http://www.umr.edu/~dpf PHONE (573) 341-4841 ----------------------- -----Original Message----- From: Mimmus [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 8:16 AM To: [EMAIL PROTECTED] Subject: 'CREATE INDEX' and DBD-ORACLE? Hi list, is it possible to execute 'CREATE INDEX' statement with DBD-Oracle? I tried with: $sth = $dbh->prepare( qq{ CREATE INDEX ID_BIL_VCEE_IDX ON BEATRICE.VOCI_CEE (ID_BILANCIO) unrecoverable }) || die "Can't prepare statement: $DBI::errstr"; $sth->execute || die "Can't execute statement: $DBI::errstr\n"; but I got following error: DBD::Oracle::db prepare failed: ORA-00942: table or view does not exist even if BEATRICE.VOCI_CEE exists and I'm connected as 'BEATRICE'. I have to say that 'VOCI_CEE' is not a regular table but a snapshot (materialized view). Any suggestion? Oracle 8.1.6.3, DBI-1.14, DBD-Oracle-1.06 Thanks in advance Domenico Viggiani
