Using non spatial view in sde

[mohd_syafidabdullah]

Hi Guru..

I have a scenario like this.I have sde and non spatial attributes in different database.
How can i use the oracle attributes in sde environment.
I able to create view in sde from non spatial database but it can't be used in sde..
Please guide..thanks.

[VinceAngelo]

Views across DATABASE LINKs are possbile, but usually perform poorly if not
carefully tuned. 

You cannot use the ArcSDE API to create a database link view, but you can create
a dummy table with the same columns (and same types), create_view to that, then
edit the view in SQL Developer, etc... so that it crosses databases.

- V