We do not have problem using create index with DBD::oracle.
-----Original Message-----
From: Mimmus [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 9: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
