Vince,
I have some of the information on the attribute table view "LICENSE" and Spatial Table "CLAIMS"
The views are "not materialized" so they are just plain SDE views.
The view contains attribute data about a land parcel. Owner, issue date, cost and few more similar fields.
Here is the code from the creation of the views.
Thanks again for your help.
CREATE OR REPLACE VIEW LICENSE AS
SELECT l.license_nbr, l.file_nbr AS filenum, c.client_name, l.LOCATION,
l.num_curr_claims AS numclaims, l.status, l.stake_dt AS stakedate,
l.record_dt AS recdate, l.issue_dt AS issdate,
l.wr_due_dt AS wrkdue,
map_num1
|| ' '
|| map_num2
|| ' '
|| map_num3
|| ' '
|| map_num4
|| ' '
|| map_num5 AS mapsheets,
w.total_exp
FROM owners.licenses l, owners.clients c, owners.license_exp w
WHERE l.client_id = c.client_id and L.LICENSE_ID=W.LICENSE_ID(+) AND status IN ('IS', 'RC', 'P');
-- Create table
create table CLAIMS
(
objectid NUMBER(38) not null,
cdate DATE,
operator VARCHAR2(30),
zone NUMBER(6),
license_nbr VARCHAR2(10),
shape INTEGER
)
tablespace LANDPARCELS_SMALL
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 80K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate indexes
create unique index A90_IX1 on CLAIMS (SHAPE)
tablespace LANDPARCELS_INDX
pctfree 10
initrans 4
maxtrans 255
storage
(
initial 80K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
create unique index R116_SDE_ROWID_UK on CLAIMS (OBJECTID)
tablespace LANDPARCELS_INDX
pctfree 10
initrans 4
maxtrans 255
storage
(
initial 80K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table CLAIMS
add constraint A90_FK1 foreign key (SHAPE)
references F90 (FID)
disable;
-- Grant/Revoke object privileges
grant select, insert, update, delete on CLAIMS to SDE;
grant select on CLAIMS to VIEWER;
