Create table works, create materialized view doesn't - long column names?
Hi.
I have no probs creating a table thus:-
CREATE TABLE blah
(
DEVICE_ID
)
as select
"Device_ID" AS DEVICE_ID
from "Aggregate"."Device"@ed_link_3
where "Device_ID" < 5;
But when I try to create a materialized view:-
CREATE MATERIALIZED VIEW blah1
(
DEVICE_ID
)
<various materialized view parms>
as select
"Device_ID" AS DEVICE_ID
from "Aggregate"."Device"@ed_link_3
where "Device_ID" < 5;
it fails with errors:-
ORA-04052: error occurred when looking up remote object Aggregate.Device@ED_LINK_3
ORA-01948: identifier's name length (31) exceeds maximum (30)
Is there a way around this?
Is the problem with columns in the remote Device table, which I do NOT need to import, having column names that are longer than 30 chars?
For now, I only want the Device_ID column which is a mere 9 chars long.
Oh, and the remote database is MySQL.
I am comfortable with the <various materialized view parms> as they work fine when I choose a different remote table having only short column names.
Thanks.