create a View from tables of different schemas

hi all,

can u pls give solution to create a View from tables of different schemas.

i have to bring data from one DB Server A,

which contains different schemas and tables in the schemas...

i need to insert that data in another DBServer B.

i made a procedure for this...

but when the connection fails from A, then i could not get data...

please suggest some solution..

thanks,

neelima

[444 byte] By [Neelima.Sridhara] at [2007-11-27 6:26:47]